Citizens interview question

A simple SQL query problem.