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

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

[@FocusOnGratitude]

​@@markkoech289ditto 😊

[@eecolme]

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

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

[@FaktzTV]

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

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

[@hankbreckenridge5680]

These are amazing tutorials. Keep up the great work!

[@groundbreakingdig]

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

[@nizarsaidi1903]

Brief and clear ! My Database teacher failed to explain this clause for 2 years

[@majeyork]

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

[@VishalPatel-ly9uq]

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

[@mostinho7]

Done thanks Where clause filter is applied before aggregation, then the aggregate function is applied on the rows returned by the where clause filter. If you want to filter on the rows returned by the aggregate function itself, you have to use having clause. Having count(*) > n

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

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

[@elderaarondavis1]

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

[@tosinoloruntoba449]

Great job Nathan so explicit

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

[@colevarney8990]

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

[@McCallumClips]

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

[@marcostevanella6051]

Am I another guy saying what all of the previous have said? This 7 min video explains what a college course does in weeks. Then, they say you need to go to college for earning an understanding of such. I rest my case while I subscribe lol. Thank you

[@xternal2072]

great instructions man. I'm you can explain in great details in English I can fully understand cause a bunch of the tutorials I find is mostly from people in India and I just can't understand some the words they are saying. GREAT LESSONS AND VIDEOS IN DETAIL! GREAT INSTRUCTOR. Remember it takes 3 to 10 years to become a overnight success.

[@md.anisurrahman1723]

You teach like an real expert.

[@dumzi]

The clarity here is amazing

[@skylerreeves]

Videos like this are why I love the internet.

[@Nam_David]

Thanks sir, it just take me 6 mins to watch but it's completely comprehensive. Amazing turorials, thanks for clarifying my confusion.

[@COOKINGBIRD]

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

[@roymcpherson1639]

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

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

[@mskafridi4815]

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

[@zenep63]

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

[@JoonJulyAugust]

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

[@XenogearsPS]

I like how fast you go. These text books and courses go slow, use too many examples and confuse the heck out of you. Simple and to the point. Thanks.

[@GreenSlugg]

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

[@KozaiDesign]

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

[@monmon8813]

Thanks.. Clear the confusion of grouping

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

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

[@mahfuzarrahman8897]

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

[@ariannagold4599]

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

[@alokjha780]

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

[@CamillaBlijden]

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

[@Sharry-M]

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

[@ygp47]

Such a simple and powerful explanation video

[@nicoborromeo1150]

Very concise and clear! Thank you so much

[@sarahfinley6606]

Thank you for sorting this out so clearly!

[@lilygranger6264]

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

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

[@danielangelov5948]

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

[@geoafrikana]

I love the tempo of this video. Thanks.

[@abdulazizalmansour7901]

Very Helpful i was looking for how to display multiple column by using group by .. thanks , from Saudi Arabia

[@v1tal_c]

Thanks! Very helpful for my interview preparation recap.

[@liamquiros]

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

[@marwaawad3677]

it helped alot thank you for short and clear explnation

[@mohammadaminghasemi9894]

dud that was fast and so much useful i don't usually comment any thing but it was really great! thank you❤

[@topazdazzlesDA]

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

[@JamRock99]

Excellent explanation!!

[@joepetey]

Thanks! Very useful how to use Having instead of 'where' , helped me count a column then use a condition to check the count greater then a value.

[@aasiralikhan7205]

Very easily explained! Big thanks!!

[@maceb87]

Best example i found so far, thank you!

[@tomaspajonk8354]

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

[@estebandiaz1306]

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

[@Italjamer]

You are a lifesaver! Thank you!

[@MrSkaterview]

Simple and concise. Thank you so much

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

[@christianyaksic3555]

It couldn't be clearer. Thank you!

[@kadekhendradarmasastrawan7694]

Just found this video and it's really helpful

[@evcaliz]

You are an amazing teacher

[@michealangelodelacruz7740]

Clear and concise! Great and very informative videos!

[@originalkaylah]

im so happy I found this video!!😆

[@alexrollins8356]

Thank you for the quick tutorial!

[@scottgaines2677]

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

[@OfisLab]

thank man, this really helped clarify these concepts

[@itsReshad]

Good Video, explained it very well, I was stuck with the silliest problem and because of the way you explained it I sorted the issue! Top Video my friend!

[@ashleyhouseknecht4042]

This was incredibly helpful. Thank you!

[@SuperKiingg]

great job very straight and clear tutorial, thank you

[@veezyp]

Best explanation I have come across. Thanks

[@zaroilorsaint3531]

nice video, I would like to know how would you select the country that most costumers

[@ikeben400]

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

[@MariamOnTheRun]

great & simple explanations- thank you!

[@amitjoshi7353]

This is the fastest way i learned the diff between Group by and having

[@dblacwell]

I learned everything I needed to know !

[@Mona-gh3mh]

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

[@Valivalia777]

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

[@vivvpprof]

I'm having an exam today, thanks for the wishes for a good day - it will be good :D

[@bevedel]

short and helpful. Thank you.

[@moviemagg3096]

Thank you, well explained! Subscribed!

[@azizas9366]

Now it is clear. Thanks for posting this video.

[@beatricebass9245]

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

[@TheFranzKranz]

Thx it really helped me understand the HAVING and WHERE Statement

[@RaphaelSchiavone]

Very helpful, you are a great teacher!!

[@johnbarratt2042]

FANTASTIC! Thank you!!!!

[@ugonnac8937]

This was very helpful and well explained. Thanks

[@enriqueperez4082]

Thank you! This was great help!!!

[@sgrgn98]

Thank you so much! Very helpful :)

[@jettecantoria]

Thank you. This is so helpful.

[@saifulislam-qf8xj]

THANK YOU!! I sorted easily

[@thulanidendere3986]

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

[@bubblebath2892]

Brilliant vid man , thnaks a ton