TrustArc Interview Question

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