Aggregate Functions in SQL: SQL 30 Day Challenge Day 11 

Learn how to use the COUNT(*), SUM(), AVG() aggregate functions and more in SQL. Aggregate functions are good for exploratory data analysis and can even be used with the GROUP BY clause to get summary statistics for groups.
Code Questions:
/* 1) get the total invoice amount
for california */
/* 2) get the count of invoices
from NY */
/* 3) get the count of invoices
broken out by State -- new concept */
-----------------------------------------------------------------
Download SQLite Studio Here: sqlitestudio.pl/
Download the Chinook Database: www.sqlitetutorial.net/sqlite...
Link to Topic List: docs.google.com/document/d/1f...
Link to Facebook Support Group: / 767988395118964
Link to my Data Etsy Shop (support me to keep making content): jellysgeekygoods.etsy.com
Buy me a coffee to show support: buymeacoffee.com/learningwith...
#sql #sqltutorial #sqlforbeginners