Level up your SQL skills in just 20 minutes with SQL Pocket Guide author, Alice Zhao. In this video, we'll cover 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! 🔗 Helpful links: 👉 Downloadable project file: +Downloads/ 👉 Advanced SQL Querying Course: Maven: Udemy: 👉 MySQL Specialist Path: 👉 Follow us on LinkedIn: Alice: Maven Analytics: ⏱️Timestamps ⏱️ 0:00 Intro 01:05 UNION vs UNION ALL 03:01 Subqueries 04:14 LEFT JOIN vs INNER JOIN 06:44 CTEs 10:02 Recursive CTEs 11:16 Date Expressions 12:16 CAST 14:28 COALESCE 15:55 ROUND 16:33 Window Functions (ROW_NUMBER, LAG & LEAD) 19:35 Final Query 21:09 Outro At Maven Analytics, we empower everyday people with life-changing data & AI skills. Head to and master in-demand tools like Excel, SQL, Power BI, Tableau, Python and more. Design your own personalized learning plan and get started for FREE! Looking for more opportunities to sharpen your skills? Explore sample datasets and practice solving real business problems with unique, expert-led guided projects: