M-DAQ interview question

SQL and Group Bys related