GROUP BY and HAVING CLAUSE IN SQL: SQL 30 Day Challenge Day 12
Day 12 is about grouping data and filter data based on these groups in SQL. Learn the GROUP BY and HAVING clauses to get statistical summaries of your data by groups and to filter data based on a grouping variable.
Video Questions:
/* return the total amount each customer
has spent on invoices in total */
/* return the total amount each customer
has spent on invoices only if the customer has spent
more than 40 */
/* return the total amount each customer
has spent on invoices only if the customer has spent
more than 40 -- we only care about CA customers */
-----------------------------------------------------------------
Download SQLite Studio Here: https://sqlitestudio.pl/
Download the Chinook Database: https://www.sqlitetutorial.net/sqlite...
Link to Topic List: https://docs.google.com/document/d/1f...
Link to Facebook Support Group: / 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/learningwith...
#sql #sqltutorial #sqlforbeginners
