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

[@R3DD_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.✊🏽🔥🔥

[@mang755]

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

[@aaronmubiru4653]

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 !!!!

[@mostinho7]

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

[@Solve_4_X]

I decided to up my skills from just ICT support and venture more into Database Management and Data Science. Your videos are simple to understand. Kindly advice on the best certification for DBM and Data Science.

[@enriqueperez4082]

Clear and concise! Thank you! Really cool video!

[@michealangelodelacruz7740]

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

[@xavi2803]

Clear and helpful, thank you!

[@maxficcardi3525]

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

[@haseebasif100]

love your teaching style,

[@crosselen9766]

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

[@gintomino4136]

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

[@juliakristavilladiego4425]

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

[@Sai-069-d6u]

great lecture ever! fantastic👏

[@wholesalingtony1588]

Great vid , it makes more since now. Thx

[@jayreigning]

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

[@manueldesmarais387]

Great! Thank for sharing values! :D

[@becomingADS]

Thanks Manuel! Glad it was helpful to you!

[@josemunguia5660]

Thanks again! Great content!

[@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?

[@stri06]

I know this is late but for anyone with the same question IRL you never do that , to find out how many rows are in the table COUNT(*) can be used and if a preview of the data is needed LIMIT can help with that i usually use LIMIT 5 or LIMIT 10 For field / columns DESCRIBE table_name can show the colums and data type

[@erikaresuello381]

Thank you for simplifying this.

[@suketupatel2192]

Really nice explanation

[@abebewondifraw6810]

thank you very much its clear

[@olgakwoczak481]

Very helpful video, thank you so much!

[@savannahb5370]

This was so helpful!!

[@quynhpham898]

very easy to understand, thank you

[@factorise001]

KEEP THE GOOD WORK

[@angelandradeolvera5879]

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

[@diskursen]

you explain very well!

[@viciwo3396]

Thanks!

[@CheeseToastie-f1x]

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?

[@Place2travel]

Thank you

[@-hearts_zad8764]

Thanks bro

[@michalroesler]

Great video.

[@bluelantern5241]

Was (quantity) a function or a variable you could have named anything?

[@BluePaper4550]

Thank you!!!!

[@ma8969]

ThAnKs

[@atcoucou8874]

Tks sir 🎉

[@Vintagetube310]

Hi, which DBMS are you using?

[@kabylfx]

Thanks!!!

[@GrumpyOldMan9]

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

[@maywu9944]

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

[@chandrasekhar1883]

perfect

[@maximedarbouze8255]

love it

[@bryanurizar]

Did you become a data scientist in the end?

[@Place2travel]

I'm trying to do this problem: Which student from Georgia has the highest GPA? I do SELECT MAX (GPA) From Students WHERE State='GA' and I only get the GPA without names. how can I specify the student Name? please help

[@chopramo]

SELECT MAX (GPA) , StudentName (Whatever column name identifies with students) From Students WHERE State='GA'

[@erickcanals2553]

I think this would work too: SELECT StudentName, GPA FROM Students WHERE State='GA' ORDER BY GPA DESC LIMIT 1;

[@manniyayo1023]

Did you ever figure this out? I have a similar scenario

[@Pane_di_Segale]

my father

[@zafar2073]

very basic

[@markreiling7606]

Great vid! Whats wrong with youre nose tho...

[@LegalBro]

Thank you!