Get my free SQL Cheat Sheets: https://www.databasestar.com/getsql...
Learn and become confident in SQL: https://databasestar.mykajabi.com/sql...
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 stepbystep.
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:
HackerRank problem: https://www.hackerrank.com/challenges...
SQL queries: https://github.com/bbrumm/databasesta...