All right.
So let's go ahead and look at something very interesting in this group by class.
Now we have level two count.
And we get every strand from each of these countries.
And now what if you are asked to give the countries where strands are above or equal to 6 or 5 or specific
number, or 20 or 40 or 100.
How can you be able to do that?
So this is a really big challenge.
And you may be like, wow, how can we be able to give that comparison right in here?
Now let me go ahead and show you how to do this.
Now you have been able to count and now you say count every column from strands group by country.
Then order by country and order by country is to make these things to be alphabetical.
Right?
Now, if I want to actually get the number of countries that are above that have students above 6 or
5, or I need to know is that before I order it, I will go ahead and put in a cloth known as heaven
and go right in here, group by country, a warhead, and see heaven.
And then, because we need the count, people who are above 6 or 5, we don't start from five.
All I need to do is go ahead and say count, and I'm going to count every column.
Therefore, I'll go ahead and put exteriors, and then I will go ahead and say, I want people who are
greater than five, and let's go ahead and execute this query.
Now I have people who are greater than five and I have 30 of these.
The score ahead and drag this up a little bit.
All right.
Now you can see that I have Afghanistan six, Argentina 16 and seven and so on.
I have no one which is less than or equal to five.
What if I want to include five?
Let me say people who are from five and above.
All I need to do is to go ahead and say greater than or equal to five.
And then if I execute this query, you can see I have a bunch of five and many of five Bangladesh five.
All right.
But you don't have anything less than five right in here.
You don't have anything less than five right in here.
And in that case, if you are asked to get people who are less than or equal to five, you are here
and say this is less than or equal to five.
And if you go ahead and execute this query, we are going to get only people who are less than or equal
to five.
And you can see we have only the countries where the students are just less than or equal to five.
And if I go ahead and remove the equal sign, I'm not going to include five.
So every of this country have students less than five.
So just like we know that there are countries that have students above 100.
And if I go ahead and say we need country where students are equal to greater than or equal to 100,
I'll go ahead and change this to 100.
Let's go ahead and check it out.
And we are going to get China and Indonesia.
You see that?
China and Indonesia.
So these are the only countries where students are greater than or equal to 100.
So the the having clause has also to be able to group these according to specific number.
So you can able to group according to specific number for right.
I hope that is cool.
So the group by clause group this according to the accounts.
But having grouped these according to the non bias the specific non bias that you need.
So you can be able to filter that using the operators greater than equal less than or less than or equal
and so on.
So while I check it out practice with it.
And if you have any questions, go ahead and use the question and answer section.
And I'm going to get back to you as soon as possible.
Thank you so much.
And I'm going to see you in the next video lecture.