Fyle interview question

Basic sql question( group by, select, etc )