Meta interview question

SQL question that required a trick to solve it