What does x <> y mean?

x <> y

means "not equal", either less than or greater than

in SQl <> is the same as != (not equal) excepts for NULLS of course, in that case you need to use IS NULL or IS NOT NULL