Aggregate Functions in SQL: SQL 30 Day Challenge Day 11
Vložit
- čas přidán 24. 06. 2024
- 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
Doing Great Jelly
the only other aggregate functions I saw were min and max
Hi Learning with Jelly, do you offer SAS Viya training?
Not currently. I can put it on the request list :)
@@learningwithjelly I would love that. Thank you!