Pergunta de entrevista da empresa TrustArc

Self join with the same sql table, group by, having keyword?