Mozilla Interview Question

in sql group by question