3. Data Retrieval
3.1 Construct and analyze queries that select data
• INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN (Cartesian product),
and FULL OUTER JOIN; self joins; combine result sets by using UNION and
INTERSECT; DISTINCT; column alias; computed columns
3.2 Construct and analyze queries that sort and filter data • ORDER BY, WHERE, LIKE, BETWEEN, AND, OR, NOT, TOP (LIMIT), IN, NOT IN, ANY, ALL, NULL, NOT NULL, comparison operators
3.3 Construct and analyze queries that aggregate data • GROUP BY, HAVING, MIN, MAX, COUNT, AVG (AVERAGE), SUM
3.2 Construct and analyze queries that sort and filter data • ORDER BY, WHERE, LIKE, BETWEEN, AND, OR, NOT, TOP (LIMIT), IN, NOT IN, ANY, ALL, NULL, NOT NULL, comparison operators
3.3 Construct and analyze queries that aggregate data • GROUP BY, HAVING, MIN, MAX, COUNT, AVG (AVERAGE), SUM
An Illustrated Guide to the SQL CROSS JOIN or Cartesian Product_ LearnSQL.pdf