How to use SELECT statement to answer business questions
IN THE VIDEO:
0:00 - Introduction
0:43 - Data setup, explanation & basic queries
6:24 - Adding calculated columns in SELECT
8:39 - Our first WHERE clause
10:28 - Ordering query results with ORDER BY
13:24 - More Where clause examples
16:42 - Between conditions
19:06 - Working with Dates
21:50 - Using other tables
23:47 - IN clause
24:36 - Pattern matching in SQL
26:30 - CASE operator and branching logic
30:30 - JOINS
36:32 - LEFT Join vs. RIGHT Join
38:28 - More Join examples
42:10 - Adding conditions to Joins
47:30 - GROUP BY and creating reports with SQL
54:50 - Showing Top 10 Products by Amount
57:12 - Closing remarks & next steps for you