Mozilla interview question

in sql group by question