Just found out about this way to use the "alias" i.e the AS command what you think it returnes as a result ?

Question

SELECT DISTINCT a.First_Name, a.Last_Name FROM CHECKED_OUT AS a, CHECKED_OUT AS b where a.Last_Name = b.Last_Name AND a.First_Name != b.First_Name

Answer 1

Why don't you run it and see for yourself?
I think no record will be returned