Complex SQL Query: Watch Me Write It

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-cheat-sheets/?utm_sou… 🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql-simplified/?utm_sour… If you need to write an SQL query and you think it will be pretty complex, don't fear! Writing a complex SQL query is about starting small and iterating until you get the result you want. In this video, I'll demonstrate a problem that needs to be solved with SQL, load some sample data, and write the query step-by-step. The demo is shown in MySQL, but the concepts can be applied to any SQL database. Hopefully you can use this approach with your own complex query. If you like this style of video, let me know in the comments below. ⏱ TIMESTAMPS: 00:00 - What we will cover 00:29 - The problem 01:45 - Create tables and sample data 03:34 - The first SELECT query 07:56 - Finding the top scores 09:53 - Changing what we see 13:40 - Advice if you want to do this yourself 🔗 VIDEO LINKS: GitHub script for sample data: github.com/bbrumm/databasestar/blob/main/videos/76… HackerRank question: www.hackerrank.com/challenges/full-score/problem

• #science_technology
• #sql_queries
• #sql_query
• #learn_sql
• #complex_sql
• #complex_sql_query