Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

In this step-by-step video tutorial, you will learn some more advanced SQL aggregation concepts by using the GROUP BY, HAVING, and WHERE clauses!
Learn about the BASIC aggregation Functions: • Basic Aggregate Functi...
Queries:
1) Pull aggregate information with the GROUP BY clause: SELECT column1, column2, COUNT(column3) FROM table GROUP BY column1, column2
2) Use the HAVING clause to filter your aggregation: SELECT column1, COUNT(column2) FROM table GROUP BY column1 HAVING COUNT(column2) = 5
3) Use WHERE and HAVING clauses in the same query: SELECT column1, COUNT(column2) FROM table WHERE column1 = 3 GROUP BY column1 HAVING COUNT(column2) = 5
Get the Northwind Database: • How to Load a Sample P...
Support the Channel:
1) Subscribe: www.becomingads.com/o/youtube
2) DataCamp:
3) Udacity:

[@talalbow]

You taught me in 6 minutes what my university class failed to teach me in 2 weeks lol Subscribed ❤️

[@lauraaparicio3076]

Or even years, online education is amazing, the future of universities is a political issue but most of education should move to the digital environment in my opinion of course, I’m from Mexico y went to the university but i am updating my stack with platzi, the biggest platform to learn digital stuff, marketing, dev, data science, in Spanish is like udemy but even better and i love it

[@ajinzrathod]

3 minutes in 2X speed

[@andrematos3353]

Same for me

[@karlwhitford7523]

Well you know what an unsigned byte address looks like after packing.

[@hannahmeng4497]

@@lauraaparicio3076 I agree with you!

[@gustavshochat7792]

Thanks for clarifying that WHERE cannot be used on aggregations. This is exactly what I was looking for regarding WHERE vs. HAVING. Not sure why I haven't seen this mentioned elsewhere, subscribed!

[@markkoech289]

Was looking for the same

[@pharaoh9483]

I dont get why it cant be used, in their documentatoin they also say u cant use them, but then they go on to provide examples like SELECT city, count(*) FILTER (WHERE temp_lo < 45), max(temp_lo) FROM weather GROUP BY city; which are combing both

[@focusgratitude9724]

​@@markkoech289ditto 😊

[@eecolme]

I'm so happy to finally found someone able to explain HAVING so easily. Thank you so much man

[@hankbreckenridge5680]

These are amazing tutorials. Keep up the great work!

[@sarahemslie6105]

Thank you Nathan. So nicely explained in such a seemingly effortless way! Please keep up the great work as you might just keep me sane.

[@MadFunnyfails]

for two years I've been struggling to understand how and when to use these clauses and you just taught me all that in 6 minutes. You are a legend. Thank you. It is going to save me from a lot of trouble from my Uni exam next week

[@VishalPatel-ly9uq]

You are a legend, this guy saved my life In university. :D

[@Mori-Chan613]

This is easier to understand than what my online mentor taught me. Thank you!

[@goinggoinggone535]

Just subscribed. If you ever get tired of BEING a data scientist, you should definitely go into teaching. You've got a knack for making complex things simple.

[@majeyork]

Thank you, I've spent a week trying to make it all make sense. You've just done that!

[@ras2930]

Oh my gosh! You answered the question that was stumping me the last few days. I’m taking the google analytics course and I keep having errors with my aggregate functions. When you added city to the SELECT clause, I keep doing that with the data set I’m working on and keep getting an error message. Then I saw you added country and city under GROUP BY which I have never done before so I think your video was the answer to my question. Thank you!!!

[@1800bth]

Thank you for your concise delivery. Not too slow nor fast.

[@SD-vj9rr]

Finally understanding how GROUP BY & HAVING work, this was definitely helpful.

[@rungxanh2901]

A 6-minute watch saves me from a lengthy 2-hour lecture, not to mention the lecture didn't even serve its purpose of teaching us in such intuitive explanation ❤️

[@colevarney8990]

This was very helpful!! Cleared up a lot of confusion I am having in my undergrad database class. Clutch for my exam tomorrow! :)

[@topazdazzlesDA]

Super simple, easy to follow! Thank you for uploading!

[@sarahfinley6606]

Thank you for sorting this out so clearly!

[@groundbreakingdig]

This is SOOO much clearer than what my instructor teaches at NAIT. Excellent tutorials.

[@mskafridi4815]

Straight to the point without any BS.. You are my hero

[@faiqahaider8296]

Thank you so MUCH! I just loved the way you explained everything in this short video it helped me to understand very well. Please keep making short videos!

[@COOKINGBIRD]

Your SQL video was exactly what I needed. Thank you for explaining it so clearly. 😄🎬💻🔍

[@tosinoloruntoba449]

Great job Nathan so explicit

[@mrreese2342]

i love how this guy in 6 minutes managed to explain GROUP BY and HAVING whilst i've been struggling with them for the whole semester

[@lilygranger6264]

This is a life savior!! Thank you THANK YOU!!!!!

[@nicoborromeo1150]

Very concise and clear! Thank you so much

[@McCallumClips]

Nice job. Thanks! Very useful and to the point. None of the stupid music or crazy intros!

[@alokjha780]

Many thanks for this very short and crisp information. Thank you!!

[@GreenSlugg]

I've been struggling with a problem like this all day. Thank you!

[@liamquiros]

Thank you so much. This is the video I was looking for! 🙌

[@KozaiDesign]

That was the most helpful explanation. I kept having the trouble of understanding when and how to use these two.

[@maceb87]

Best example i found so far, thank you!

[@Sharry-M]

Man I love your content! you're a savior! thanks for the educational videos!!

[@ariannagold4599]

You're the best. Much love from Miami U.

[@user-vf4pz1jw3u]

Thank you! You made it so easy to understand. Much appreciated

[@alexrollins8356]

Thank you for the quick tutorial!

[@MariamOnTheRun]

great & simple explanations- thank you!

[@dumzi]

The clarity here is amazing

[@md.anisurrahman1723]

You teach like an real expert.

[@estebandiaz1306]

Second video of yours I watch. You have such a great way of explaining things! Subscribed

[@kopilkaiser8991]

Thank you making such a great informational, informative, simplified video to teach us individuals who are willing to learn all of these topics discussed.

[@Italjamer]

You are a lifesaver! Thank you!

[@zenep63]

One of the best video outhere. It really helped me out to understand what's the use of GROUP BY THANK YOU

[@beatricebass9245]

Great video! Very helpful and made a ton of sense! Thanks!!

[@aasiralikhan7205]

Very easily explained! Big thanks!!

[@veezyp]

Best explanation I have come across. Thanks

[@ikeben400]

Superb video. Straight to the point and very concise 👍🏾

[@neptune7153]

Thank you so much! I have my exam tomorrow and was always confused about when i can use what. No one could explain it to me and it took you 5 minutes lol your‘re a life saver

[@ericakillz2052]

Oh my god, you helped me so much I spent all day on this and you helped me more than the damn instructor did. Thank you so much.

[@roymcpherson1639]

This answered all my questions while doing the google data analytics certificate. Thanks for taking the time to do this.

[@MrSkaterview]

Simple and concise. Thank you so much

[@ashleyhouseknecht4042]

This was incredibly helpful. Thank you!

[@tomaspajonk8354]

Man your explanation is amazing. Ill check all of your's videos. Thank you a lot

[@geoafrikana]

I love the tempo of this video. Thanks.

[@JoonJulyAugust]

learning relational database in university, this video helped a lot. thanks man!

[@danielangelov5948]

You helped me a lot, i had a lot of issue with having and group by. Thank you

[@michealangelodelacruz7740]

Clear and concise! Great and very informative videos!

[@v1tal_c]

Thanks! Very helpful for my interview preparation recap.

[@Mona-gh3mh]

Your video is great! Helps me a lot!!!

[@azizas9366]

Now it is clear. Thanks for posting this video.

[@enriqueperez4082]

Thank you! This was great help!!!

[@SuperKiingg]

great job very straight and clear tutorial, thank you

[@johnbarratt2042]

FANTASTIC! Thank you!!!!

[@elderaarondavis1]

I was lost reading through Microsoft SQL pages on HAVING vs WHERE, but with this video I got it right away😀 Thank you ❤

[@OfisLab]

thank man, this really helped clarify these concepts

[@christianyaksic3555]

It couldn't be clearer. Thank you!

[@user-iz2kv6xq5n]

Very helpful, you are a great teacher!!

[@mahfuzarrahman8897]

it is a 100% useful and effective tutorial. I really thank you so much.

[@moviemagg3096]

Thank you, well explained! Subscribed!

[@simmyjer]

Very helpful. Thank you!

[@bevedel]

short and helpful. Thank you.

[@ygp47]

Such a simple and powerful explanation video

[@user-ff3co9pb8k]

clear and easy to understand !

[@dblacwell]

I learned everything I needed to know !

[@marwaawad3677]

it helped alot thank you for short and clear explnation

[@kadekhendradarmasastrawan7694]

Just found this video and it's really helpful

[@Misfittykitty]

Thank you so much you are a GREAT teacher! :)

[@migelvandevoorde9593]

This was really helpful, thank you!!!!

[@jettecantoria]

Thank you. This is so helpful.

[@bubblebath2892]

Brilliant vid man , thnaks a ton

[@ivankljun2542]

Great explanation, thanks!

[@evcaliz]

You are an amazing teacher

[@originalkaylah]

im so happy I found this video!!😆

[@karlkarnu7641]

Great video, thanks!

[@shakrazj]

What a great video. Subscribed!

[@saifulislam-qf8xj]

THANK YOU!! I sorted easily

[@Runa_Nura]

nice content, easy to understand. THX

[@tanveerulhaq6511]

Great explanation. Thank you so much...

[@scottgaines2677]

Thank you for the great explanation! This was very helpful! Liked and subscribed!

[@ugonnac8937]

This was very helpful and well explained. Thanks

[@JC-ej1xi]

This is super helpful. Thank you.

[@juliakristavilladiego4425]

Thank you so much. Really helpful!

[@hannahmeng4497]

This video is amazing!

[@camilopinzon5957]

Great Job, thanks for sharing Knowledge.

[@skylerreeves]

Videos like this are why I love the internet.

[@Lance-rg9en]

Great video. Keep up the great work!

[@thulanidendere3986]

... thanks man, you just made my life easier 👌

[@kushagraahire1871]

Great Explanation

[@Valivalia777]

Thanks for the video and your examples, you can really explain it in simple words, nice work :)))))

[@samuelrodrigues2939]

thanks a lot man.. that was really helpful

[@gspolima]

you. are. the. guy. thank you!