Inequality operator gives a different result than an OR result even though I logically think it should be the same

I have been solving problem set 0 from Harvard’s CS50 for SQL online course. There is a question in it, which says: