Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)

Learn how to use SQL's basic aggregation functions like COUNT, SUM, AVG, MAX, and MIN in this step-by-step tutorial!

Queries:
1) Get a count of all the rows: SELECT COUNT(*) FROM table
2) Get a SUM of a column in all the rows: SELECT SUM(column1) FROM table
3) Get the maxium number in a column: SELECT MAX(column1) FROM table
4) Get the minimum number in a column: SELECT MIN(column1) FROM table
5) You can also do arithmatic with these aggregate functions: SELECT MAX(column1)-MIN(column1) AS range FROM table
6) Or, like this: SELECT AVG(column1*column2) FROM table

Support the Channel:

[RDD_TTV]

You may not see this, but this video has helped me tremendously. Aggregate functions drove me crazy until I watched this video. Now I have a better foundation and feel a lot more confident with this topic now.✊🏽🔥🔥

[mang]

You are single-handedly saving my grade and finals preparation for my databases module. I appreciate all the hard work, thanks a ton!

[enriqueperez]

Clear and concise! Thank you! Really cool video!

[jayreigning]

Great content, your introduction of the topic got me going pretty quick

[maxficcardi]

great video brotha, really helping me out studying!!!

[juliakristavilladiego]

Thank you. Really helpful! I'm binge watching haha

[gintomino]

Glad I found your channel. Happy learning and thanks for sharing ur knowledge

[michealangelodelacruz]

Thank you for this! Currrently studying SQL on my weekends! <3

[aaronmubiru]

my teacher explained and i could not understand anything and i watched your video and understood everything, i appreciate you and your channel so much, thank you !!!!

[olgakwoczak]

Very helpful video, thank you so much!

[angelandradeolvera]

Great videos!! how would you exclude an item from a total? example, total quantity excluding beer.

[mostinho]

Done thanks
Simple aggregate functions like max min etc
Where clause is applied first, then aggregate functions applied to what that where clause has filtered

[wholesalingtony]

Great vid, it makes more since now. Thx

[crosselen]

I love you dude your so good at explaining and teaching man

[maywu]

So helpful and so Would you want to teach us about leetcode as well???? haha thank you for your hard work.

[GrumpyOldMan]

How do you put the total of a column into all the cells of another column?

[nizwudg]

I cant help feeling nervous seeing the sales funnel book on the shelf. I am about to end up buying a weekend workshop and mentor?

[VeronicaAngryPolak]

i don't know if you've answered this in any of your videos but are you actually going to be SELECT * on a massive database? is there a query that can show you how many rows / columns you have so you don't crash your system? or can you do a query that shows column names and how many rows?