We are looking to hire a SQL programmer and need a good screening question similar to the FizzBuzz question but for SQL.
While it is certainly possible to write a FizzBuzz solution using SQL, I think the effort is misplaced. The FizzBuzz question assesses coding fundamentals such as looping, conditionals, output, and basic math. With SQL, I think something related to queries, joins, projections, and the like would be more appropriate. But, just as with FizzBuzz, it should be simple enough that 'good' SQL programmers can write a solution on paper in a couple minutes.
What is a good 'FizzBuzz' question for a SQL programmer?