We are going to go deeper into the SQL abyss in the advanced SQL tutorial, and start to cover material that typical SQL tutorials don't teach.
We'll cover higher-level concepts such as:
Most importantly, we'll put it all together to solve a real Instacart SQL Data Analytics case study, where we'll write long SQL queries to solve an open-ended business problem.
So without further ado, the first lesson in the advanced SQL tutorial: CTEs vs. Subqueries.
CTE vs. SUBQUERY 🥊