We are going to discuss about grabbing cheaver. So, you know very well that the GROUP BY clause you use the GROUP BY clause while using the aggregate functions. But in this case, when you use a group like class, what happens if I use the weight loss where possibles as it hit it to them three button so it will give you the error. Why? Because you cannot use the where clause when you use the crowbar. So, this is the illegal I'm not going to tell you why it's illegal, because this is the basic cities but I'm so this is the solution.

I'm just telling you that What is sorry, this is a problem and what is the solution? The solution is you have to use the having, having an account as Id greater than one, Control Enter. So now as you can see it's giving because if you if you use this one, right, so now as you can see, it's saying you that you have 4111 and now here you are saying the greater than one, so greater than one not equals to one. So if you use the greater than or equal to Control Enter, so it will give you the one rigor on results and ask for the data to them. Ctrl f5, so we represent ones that means I'm talking about the 234 onwards, now if I'm saying equals to one, so as you can see, it's only showing you that has only one already if I'm saying that greater than zero, it will give you Sorry, it will give you all the records because it's getting the 1111 and four.

So in this way you are having to ask work. So this is the role you can not use the where clause when you use the globe by in the same query, make sure I'm not talking about that energy. So if you're not familiar with the inner query or security, so don't worry about it. Now, you only use the airing with aggregate function, why the hall you cannot move. Okay, so I think this is enough for the next session. We are going to cover some other topics.

So thank you for watching.