GEP interview question

define group by, having, joins