TIAA Interview Question

MySQL joins , group by , having clauses.