Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
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