Citizens Interview Question

A simple SQL query problem.