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!
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
I'm so happy to finally found someone able to explain HAVING so easily. Thank you so much man
These are amazing tutorials. Keep up the great work!
Thank you, I've spent a week trying to make it all make sense.
You've just done that!
This is easier to understand than what my online mentor taught me. Thank you!
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
This was very helpful!! Cleared up a lot of confusion I am having in my undergrad database class. Clutch for my exam tomorrow! :)
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.
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 ❤️
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.
Finally understanding how GROUP BY & HAVING work, this was definitely helpful.
Straight to the point without any BS.. You are my hero
This is SOOO much clearer than what my instructor teaches at NAIT. Excellent tutorials.
I was lost reading through Microsoft SQL pages on HAVING vs WHERE, but with this video I got it right away😀 Thank you ❤
You teach like an real expert.
Thank you for your concise delivery. Not too slow nor fast.
The clarity here is amazing
You are a legend, this guy saved my life In university. :D
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
Your SQL video was exactly what I needed. Thank you for explaining it so clearly. 😄🎬💻🔍
This answered all my questions while doing the google data analytics certificate. Thanks for taking the time to do this.
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
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!!!
Thanks sir, it just take me 6 mins to watch but it's completely comprehensive. Amazing turorials, thanks for clarifying my confusion.
Great job Nathan so explicit
Thank you for sorting this out so clearly!
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
FANTASTIC! Thank you!!!!
This is a life savior!! Thank you THANK YOU!!!!!
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.
You are an amazing teacher
Thank you making such a great informational, informative, simplified video to teach us individuals who are willing to learn all of these topics discussed.
Super simple, easy to follow! Thank you for uploading!
That was the most helpful explanation. I kept having the trouble of understanding when and how to use these two.
I've been struggling with a problem like this all day. Thank you!
You helped me a lot, i had a lot of issue with having and group by. Thank you
One of the best video outhere. It really helped me out to understand what's the use of GROUP BY
THANK YOU
it is a 100% useful and effective tutorial. I really thank you so much.
Very concise and clear! Thank you so much
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!
learning relational database in university, this video helped a lot. thanks man!
Thank you for the quick tutorial!
Best example i found so far, thank you!
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.
Thanks! Very helpful for my interview preparation recap.
Such a simple and powerful explanation video
Best explanation I have come across. Thanks
Now it is clear. Thanks for posting this video.
thank man, this really helped clarify these concepts
This is the fastest way i learned the diff between Group by and having
Thank you! This was great help!!!
great & simple explanations- thank you!
Brilliant vid man , thnaks a ton
Just found this video and it's really helpful
You're the best. Much love from Miami U.
Very easily explained! Big thanks!!
Thank you. This is so helpful.
Thank you so much. This is the video I was looking for! 🙌
Man I love your content! you're a savior! thanks for the educational videos!!
Superb video. Straight to the point and very concise 👍🏾
Nice job. Thanks! Very useful and to the point. None of the stupid music or crazy intros!
Great Explanation
short and helpful. Thank you.
Videos like this are why I love the internet.
it helped alot thank you for short and clear explnation
Many thanks for this very short and crisp information. Thank you!!
I love the tempo of this video. Thanks.
you. are. the. guy. thank you!
Very helpful. Thank you!
Your video is great! Helps me a lot!!!
This video is amazing!
Yes. Great value.
Thank you! You made it so easy to understand. Much appreciated
Great video, thanks!
im so happy I found this video!!😆
THANK YOU!! I sorted easily
You are a lifesaver! Thank you!
Simple and concise. Thank you so much
Great explanation, thanks!
Very well done.
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.
I learned everything I needed to know !
you the man! thank you
Superb explanation
Great video! Very helpful and made a ton of sense! Thanks!!
This was incredibly helpful. Thank you!
Thank you. It helps me so much.
Очень хорошее видео. Автору спасибо
... thanks man, you just made my life easier 👌
Thank you for this!!!
great job very straight and clear tutorial, thank you
Great explanation. Thank you so much...
Second video of yours I watch. You have such a great way of explaining things! Subscribed
Thank you!
this was really helpful watched this after getting a hacker rank question where I had to stack overflow too much.
Thank you!! that helped!
Thank you very much you are a good prof
It couldn't be clearer. Thank you!
Man your explanation is amazing. Ill check all of your's videos. Thank you a lot
You taught me in 6 minutes what my university class failed to teach me in 2 weeks lol
Subscribed ❤️
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
3 minutes in 2X speed
Same for me
Well you know what an unsigned byte address looks like after packing.
@@lauraaparicio3076 I agree with you!