SELECT, FROM & WHERE: Your First Real SQL Query

Description:
Try it yourself. The full written explainer and an interactive query playground are here:
https://unrote.com/sql/select-from-where/

SELECT, FROM and WHERE are the three keywords behind almost every SQL query you will ever write. In this video we take them apart one at a time, using a single customers table, so you can see exactly what each one does and why queries read almost like English.

What you will learn:
- FROM: how to name the table your data lives in, and why it comes first
- SELECT: how to choose the columns you want back, plus what SELECT * really means
- WHERE: how to filter rows with a condition, checked against every row, one at a time
- The comparison operators (=, not equal, greater than, less than) and when text needs single quotes
- How to combine conditions with AND and OR
- The surprising order the database actually runs your query in: FROM, then WHERE, then SELECT
- Two common beginner traps that quietly break queries

This is the second video in the Unrote SQL track, right after What Is SQL. By the end you will be able to read and write real queries against a real table.

Chapters:
0:00 The query, in one line
0:23 Two questions, three words
0:38 FROM: pick the table
0:54 SELECT: pick the columns
1:08 SELECT * shortcut
1:24 WHERE: filter the rows
1:39 Watch the filter run
1:53 Comparison operators
2:11 Combine with AND and OR
2:25 The full query, end to end
2:41 Written order vs run order
3:00 Two common traps
3:16 Recap

Unrote teaches the idea behind each concept so you understand it instead of memorizing it. New SQL videos every week.

https://unrote.com/sql/select-from-where/