SQL quiz. Given two columns from Elements table <pre><code c

Given two columns from Elements table

+--------+------+
| Name   | Year |
+--------+------+
| Au     | NULL |
| Be     | 1798 |
| Fr     | 1939 |
| Uus    | 2010 |
+--------+------+

how many records will the following query return?

SELECT * FROM Elements
WHERE Year NOT IN (SELECT Year FROM Elements)

Inner sub-query will eliminate every possible record the outer query could have returned.

or Read more about SQL Quizzes