Curso SQL en Oracle 🚀 #29 | Ejercicios Prácticos de LEFT JOIN en SQL

In this video from the Oracle SQL course, we continue solving practical SQL query exercises. This time, we focus on advanced JOINs, especially LEFT JOIN, one of the most widely used join types in relational databases. You will learn to solve real-world exercises using: ✅ LEFT JOIN in Oracle SQL ✅ Differences between INNER JOIN and LEFT JOIN ✅ Queries to retrieve unrelated records ✅ COUNT with LEFT JOIN ✅ GROUP BY and ORDER BY ✅ Using NULL in SQL queries ✅ Alternatives with MINUS and subqueries GitHub repository with everything you need: https://github.com/DiscoDurodeRoer/cu... ✅ Exercise statements: 21. Code for rooms where no games have been played. 22. Number of games played by each player, including those who haven't played any games. Order by the number of games played, from highest to lowest. PLAYER_NAME | games ✅ Chapters: 00:00 Introduction 00:20 Exercise 21 v1 03:12 Exercise 21 v2 04:24 Exercise 22 ✅ Subscribe to the Channel to See More Videos: https://www.youtube.com/@DiscoDurodeR... ✅ Important Links: 👉 Need a quality server? Webempresa offers it to you: https://www.webempresa.com/ 👉 Website: https://discoduroderoer.es/ 👉 Become our Patron!: https://www.patreon.com/profile/creat... 👉 Discount on my Udemy courses: https://cupones.discoduroderoer.es/#/... 👉 Follow my upcoming events: https://eventos.discoduroderoer.es/ 👉 Want to follow our work? Visit our GitHub: https://github.com/DiscoDurodeRoer ✅ Connect with me: 👉 YouTube (Secondary Channel): https://www.youtube.com/@ctrl_alt_mee... 👉 Twitch:   / discoduroderoer_prog   👉 Facebook: https://www.facebook.com/profile.php?... 👉 TikTok:   / discoduroderoer   👉 Twitter: https://x.com/DiscoDurodeRoer 👉 Discord:   / discord   📩 For business inquiries: [email protected] ============================== ✅ Other videos you might be interested in: 👉    • Curso Consultas SQL en Oracle 🚀 #12 | GROU...   👉    • Curso Consultas SQL en Oracle 🚀 #11 | Func...   👉    • Curso Consultas SQL en Oracle 🚀 #10 | Cons...   👉    • Curso Consultas SQL en Oracle 🚀 #9 | NVL, ...   ============================= #sql #oracle #SQLOracle #leftjoin #JoinsSQL #database #sqltutorial #learnsql #SQLqueries SQL in Oracle Course 🚀 #29 | Practical Exercises on LEFT JOIN in SQL