1. GROUP BY, HAVING 2. EXISTS 3.INTERSECT

SELECT

GROUP BY

GROUP BY

SubQuery

GROUP BY, HAVING

DATE

SELECT

GROUP BY

EXISTS, LEFT JOIN

SELECT, CASE

SELECT, CASE

STRING, DATE

SELECT

Sub Query, WINDOW

JOIN

Sub Query

JOIN

DATE()

INNER JOIN