TIAA interview question

MySQL joins , group by , having clauses.