InfoCepts interview question

Question on SQL using ground by and having