Skip to content

Complex SQL Query Breakdown Step By Step

Bram Adams
Bram Adams
1 min read

Table of Contents

 <https://www.youtube.com/watch?v=f1vuGPuug9s&ab_channel=DatabaseStar>
03:02

use the FROM clause to understand tables in the query

 04:60

LEFT JOIN (only join items into the union from the left table) uses a subquery where we can SELECT inside and the JOIN it on a field to the computed table

 08:50

any filters? HAVING is filtering where sum values != 0

 14:34

Run the main query in parts

Post Mortem

https://bram-adams.ghost.io/content/images/2023/01/Complex-SQL-Query-Breakdown-Step-By-Step-Screenshot-2023-01-09-17-42-25.png
Complex SQL Query Breakdown Step By Step Screenshot 2023-01-09 17-42-25.png
https://bram-adams.ghost.io/content/images/2023/01/Complex-SQL-Query-Breakdown-Step-By-Step-Screenshot-2023-01-09-17-46-07.png
Complex SQL Query Breakdown Step By Step Screenshot 2023-01-09 17-46-07.png
https://bram-adams.ghost.io/content/images/2023/01/LEFT-JOIN-Screenshot-2023-01-09-17-48-36.png
LEFT JOIN Screenshot 2023-01-09 17-48-36.png
sqlyoutube-notes

Bram Adams

writer, programmer

Comments


Related Posts

Members Public

Notes on The History of Menswear

All about the history of menswear, from the Chinese ruling class wearing nail polish to the introduction of modern streetwear.

Notes on The History of Menswear
Members Public

Notes on OpenAI Q&A Finetuning GPT-3 Vs Semantic Search - Which to Use, When, and Why

A great video about finetuning vs semantic search. Finetuning teaches a model to write new patterns, not to have a theory of mind.

Members Public

I Programmed a YouTube Clipper

Just to capture this goated moment on a Kripp vid Are you on the guest list? x 3 It captures the current time from a YouTube share link and adds 5 seconds to the end time, subtracts 5 seconds from the start time. Get it here ⬇️ GitHub - bramses/ytclip-10s