GEP Interview Question

define group by, having, joins