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
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
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
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 ❤️
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!!!
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.
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
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
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.
Thank you making such a great informational, informative, simplified video to teach us individuals who are willing to learn all of these topics discussed.
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!
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!
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
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!
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!
Was looking for the same
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
@@markkoech289ditto 😊
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
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 ❤️
Brief and clear ! My Database teacher failed to explain this clause for 2 years
This is SOOO much clearer than what my instructor teaches at NAIT. Excellent tutorials.
I'm so happy to finally found someone able to explain HAVING so easily. Thank you so much man
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!!!
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.
This is easier to understand than what my online mentor taught me. Thank you!
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
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
These are amazing tutorials. Keep up the great work!
dud that was fast and so much useful
i don't usually comment any thing but it was really great!
thank you❤
Thank you, I've spent a week trying to make it all make sense.
You've just done that!
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
This was very helpful!! Cleared up a lot of confusion I am having in my undergrad database class. Clutch for my exam tomorrow! :)
I was lost reading through Microsoft SQL pages on HAVING vs WHERE, but with this video I got it right away😀 Thank you ❤
Finally understanding how GROUP BY & HAVING work, this was definitely helpful.
Straight to the point without any BS.. You are my hero
Thank you for your concise delivery. Not too slow nor fast.
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.
Your SQL video was exactly what I needed. Thank you for explaining it so clearly. 😄🎬💻🔍
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.
Thanks sir, it just take me 6 mins to watch but it's completely comprehensive. Amazing turorials, thanks for clarifying my confusion.
Videos like this are why I love the internet.
I've been struggling with a problem like this all day. Thank you!
This answered all my questions while doing the google data analytics certificate. Thanks for taking the time to do this.
Nice job. Thanks! Very useful and to the point. None of the stupid music or crazy intros!
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.
You teach like an real expert.
Thank you making such a great informational, informative, simplified video to teach us individuals who are willing to learn all of these topics discussed.
One of the best video outhere. It really helped me out to understand what's the use of GROUP BY
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.
The clarity here is amazing
learning relational database in university, this video helped a lot. thanks man!
That was the most helpful explanation. I kept having the trouble of understanding when and how to use these two.
Great job Nathan so explicit
Great tutorial (Revisiting) 😊🎉⭐️⭐️⭐️⭐️⭐️
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.
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!
it is a 100% useful and effective tutorial. I really thank you so much.
That was totally explanatory, i appreciate it boss
You helped me a lot, i had a lot of issue with having and group by. Thank you
Man I love your content! you're a savior! thanks for the educational videos!!
Many thanks for this very short and crisp information. Thank you!!
Thank you! You made it so easy to understand. Much appreciated
thank man, this really helped clarify these concepts
Thank you so much. This is the video I was looking for! 🙌
This is a life savior!! Thank you THANK YOU!!!!!
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!
Thank you for sorting this out so clearly!
Thanks.. Clear the confusion of grouping
You're the best. Much love from Miami U.
Very concise and clear! Thank you so much
I love the tempo of this video. Thanks.
Man your explanation is amazing. Ill check all of your's videos. Thank you a lot
My professors are dumb as shit. You made this simple! Thanks
Thanks! Very helpful for my interview preparation recap.
Second video of yours I watch. You have such a great way of explaining things! Subscribed
Very Helpful i was looking for how to display multiple column by using group by .. thanks ,
from Saudi Arabia
Super simple, easy to follow! Thank you for uploading!
Such a simple and powerful explanation video
I'm having an exam today, thanks for the wishes for a good day - it will be good :D
this was really helpful watched this after getting a hacker rank question where I had to stack overflow too much.
Best example i found so far, thank you!
it helped alot thank you for short and clear explnation
Thanks for the video and your examples, you can really explain it in simple words, nice work :)))))
Very easily explained! Big thanks!!
Thank you for the great explanation! This was very helpful! Liked and subscribed!
Just found this video and it's really helpful
This was incredibly helpful. Thank you!
im so happy I found this video!!😆
Clear and concise! Great and very informative videos!
Excellent explanation!!
Superb video. Straight to the point and very concise 👍🏾
Thank you for the quick tutorial!
Very helpful, you are a great teacher!!
It couldn't be clearer. Thank you!
You are a lifesaver! Thank you!
great & simple explanations- thank you!
I learned everything I needed to know !
You are an amazing teacher
Brilliant vid man , thnaks a ton
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
Thx it really helped me understand the HAVING and WHERE Statement
This is the fastest way i learned the diff between Group by and having
Best explanation I have come across. Thanks
Your video is great! Helps me a lot!!!
great job very straight and clear tutorial, thank you
Great video! Very helpful and made a ton of sense! Thanks!!
Simple and concise. Thank you so much
... thanks man, you just made my life easier 👌
Now it is clear. Thanks for posting this video.
I wouldn't say this is that advanced but accurate and useful for sure
Thank you so much! Very helpful :)
Thank you, well explained! Subscribed!
Thank you! This was great help!!!
Saved my day at bootcamp sprint :D thanks