In this demo, we'll be moving beyond the Big 6 clauses (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY) and introduce more advanced SQL querying topics.

Our goal will be to first generate a series of dates using a recursive CTE, combine it with a sales table using a LEFT JOIN, and finally fill in the missing NULL values using the COALESCE null function and the LAG & LEAD window functions.

Along the way, we'll be covering 12 advanced SQL concepts:

• UNION

• UNION ALL

• Subqueries

• LEFT JOIN

• INNER JOIN

• CTEs

• Recursive CTEs

• Date Expressions

• CAST

• COALESCE

• ROUND

• Window Functions

… all in less than 20 minutes!