Perfect, that`s just what they were looking for.

Also, usually you'd get to go home early on your second day.

But unfortunately they just got a call from the fire department and

they`re worried about the school`s capacity numbers.

They`re fine for this year but

the fire department thinks it`s possible there will be too many students next year.

Could you find out how many students are in each grade?

And then use that data to predict how many sixth graders they'll have next year?

To figure out how many students are in each grade,

we'll need to use our first GROUP BY clause.

So let's start by selecting everything from STUDENTS.

And luckily we've got a GRADE column.

So let's GROUP BY GRADE.

And let's change from selecting everything to counting what we

get in the results as well as telling us which grade is selected.

So let's do GRADE, COUNT1), or COUNT(*) or whatever count you feel like using.

And if we run this, there we go.

So now we need to figure out how many sixth graders they'll have next year.

Okay, so from grade 8 to 7, it looks like this goes up 24 students.

And then from 7 to 6, that's 27 students.

So 24 to 27.

And then maybe the next sixth graders will be plus 30, so

let's say that the next sixth grade class is probably gonna have about 220 students.