Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed SQL Reporting by Example!
You have completed SQL Reporting by Example!
Preview
What's the total capacity of the school?
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
[MUSIC]
0:00
Welcome to your first day,
I hope you're ready to get started.
0:04
The fire department showed up, and they
need an update on the school's seating
0:08
capacity before they'll let school start.
0:11
If you could figure out the total capacity
of the school, that would be really,
0:13
really helpful.
0:17
To find the total capacity of the school,
we'll need to use the rooms table.
0:19
And if we look at the rooms table,
it looks like a pretty simple table,
0:24
there's just an ID and a capacity.
0:29
So to get the total
capacity of the school,
0:31
we just need to add up all these capacity
numbers and see what they add up to.
0:33
To do this in sequel,
we just need to select the sum of
0:37
the capacity column from the rooms table.
0:41
Semicolon, and then run the query,
and there we go.
0:49
We have a capacity for 596 total students.
0:52
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up