Complex SQL Query: Watch Me Write It

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:

[eminjs]

You are constantly producing ONLY top-notch videos. Kudos to you and please, keep this kind of stuff. It is of invaluable importance for us to see the "inner kitchen" of how professionals write complex queries.

[kanugupta]

That has been the best video to teach complex SQL in a very light manner!

[melspiglet]

I love this video and find it incredibly useful. Yes, please, do more videos breaking down the thought process of writing complex queries. Funny, I was like, 'you can't put that in the WHERE clause it goes in a HAVING clause!'... and then that's what you demonstrated & the reason behind it. That boosted my confidence.

[katsukido]

You need more recognition, your videos are really helpful!

[tuilathang]

Thank you, i am new to SQL and your chanel. You help me a lot sir.

[michellemontemayor]

This is very useful! I would love to see more.

[nirshadnijam]

Very concise. Thank you for this video!

[rachaelhanna]

Thanks Ben an excellent video. At my work we write a lot of complex queries. I have often wondered if there is a 'best practice' approach to writing them.

[obadmatar]

Thank you for this well explained video, appreciate your efforts to produce this perfect content.

[Franaman]

This is so good and well explained! This is perfect!

[-.-smile]

Amazing videos, enjoy actually your doing and healing the complex queries. Keep up the great content!

[damishito]

it was a moment when u do a references using pk and fk for the tables? or u just straight do the inner joins ? great vid

[engr_mark]

You didn't provide the link to the hackrank question as you claimed.

[ramsay]

please, next video about : "Complex PL/SQL Query: Watch Me Write It"

[EUK]

how to fetch first 3 and last 3 records in oracle sql in single query