Informatica Interview Question

Write a SQL query consisting group by, select, having, and where. All in one query