Pergunta de entrevista da empresa ChromeInfotech

what is group by Difference between where and having Self join Ditinct