Complex SQL Query: Watch Me Write It (#2)

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 PostgreSQL, but the concepts can be applied to any SQL database.

You can use this approach with your own complex query.

⏱ TIMESTAMPS:
00:00 - Our process
00:18 - The problem
01:30 - Start our query
03:02 - Add salary
03:45 - Add friend data
06:20 - Filtering data

🔗 VIDEO LINKS:

[yassinebouchoucha]

solving SQL (and any software related problems) in chunks is the way to go! jumping directly to the solution with no intermediate step will never lead to the solutions.

[taslimsuman]

Please make a database design for a SaaS app