Summarizing Data

Aggregate Functions
.MAX()
.MIN()
.AVG()
.SUM()
.COUNT()

 GROUP BY Clause
 HAVING Clause
ROLLUP Operator

 WRITING COMPLEX QUERIES

Subqueries in WHERE Clause
Subqueries with IN / NOT IN
Subquery vs Join
ALL Keyword
ANY Keyword
Correlated Subquery
EXISTS Operator
Subqueries in SELECT Clause
Subqueries in FROM Claus





