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

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

[@mang755]

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

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

[@enriqueperez4082]

Clear and concise! Thank you! Really cool video!

[@michealangelodelacruz7740]

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

[@crosselen9766]

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

[@maxficcardi3525]

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

[@Sai-069-d6u]

great lecture ever! fantastic👏

[@haseebasif100]

love your teaching style,

[@gintomino4136]

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

[@juliakristavilladiego4425]

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

[@xavi2803]

Clear and helpful, thank you!

[@Cypto-Chris]

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.

[@jayreigning]

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

[@kingtyphoon]

This is a non-nonsense video!

[@wholesalingtony1588]

Great vid , it makes more since now. Thx

[@suketupatel2192]

Really nice explanation

[@manueldesmarais387]

Great! Thank for sharing values! :D

[@becomingADS]

Thanks Manuel! Glad it was helpful to you!

[@josemunguia5660]

Thanks again! Great content!

[@erikaresuello381]

Thank you for simplifying this.

[@savannahb5370]

This was so helpful!!

[@factorise001]

KEEP THE GOOD WORK

[@olgakwoczak481]

Very helpful video, thank you so much!

[@quynhpham898]

very easy to understand, thank you

[@diskursen]

you explain very well!

[@abebewondifraw6810]

thank you very much its clear

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

[@michalroesler]

Great video.

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

[@atcoucou8874]

Tks sir 🎉

[@Vintagetube310]

Hi, which DBMS are you using?

[@viciwo3396]

Thanks!

[@bluelantern5241]

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

[@maywu9944]

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

[@Place2travel]

Thank you

[@-hearts_zad8764]

Thanks bro

[@angelandradeolvera5879]

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

[@BluePaper4550]

Thank you!!!!

[@ma8969]

ThAnKs

[@estitt1973]

I don’t get it. I am just starting in Data Analysis and this is pretty frustrating. But I’ll try and be patient with it and not completely stress out over my not understanding. It will take some time.

[@chandrasekhar1883]

perfect

[@maximedarbouze8255]

love it

[@kabylfx]

Thanks!!!

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

[@bryanurizar]

Did you become a data scientist in the end?

[@zafar2073]

very basic

[@Pane_di_Segale]

my father

[@markreiling7606]

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

[@LegalBro]

Thank you!