Learn about subqueries in SQL. Subqueries can be in the SELECT, FROM, or WHERE clauses. Common Table Expressions can limit the use of subqueries.
Video Practice Problem:
/* Return customer/id
for all customers whose total invoice amount
is greater than the avg invoice amt for all customers */
-----------------------------------------------------------------
Download SQLite Studio Here: https://sqlitestudio.pl/
Download the Chinook Database: https://www.sqlitetutorial.net/sqlite-sample-database/
Link to Topic List: https://docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7wUQI8OrNM7vBA0/edit?usp=sharing
Link to Facebook Support Group: https://www.facebook.com/groups/767988395118964/
Link to my Data Etsy Shop (support me to keep making content): https://jellysgeekygoods.etsy.com
Buy me a coffee to show support: https://buymeacoffee.com/learningwithjelly
#sql #sqltutorial #sqlforbeginners
