EY Interview Question

joins subquery, having and where difference