1
00:00:00,000 --> 00:00:04,891
[MUSIC]

2
00:00:04,891 --> 00:00:08,210
Welcome to your first day,
I hope you're ready to get started.

3
00:00:08,210 --> 00:00:11,270
The fire department showed up, and they
need an update on the school's seating

4
00:00:11,270 --> 00:00:13,780
capacity before they'll let school start.

5
00:00:13,780 --> 00:00:17,240
If you could figure out the total capacity
of the school, that would be really,

6
00:00:17,240 --> 00:00:18,070
really helpful.

7
00:00:19,870 --> 00:00:24,020
To find the total capacity of the school,
we'll need to use the rooms table.

8
00:00:24,020 --> 00:00:29,037
And if we look at the rooms table,
it looks like a pretty simple table,

9
00:00:29,037 --> 00:00:31,601
there's just an ID and a capacity.

10
00:00:31,601 --> 00:00:33,561
So to get the total
capacity of the school,

11
00:00:33,561 --> 00:00:37,810
we just need to add up all these capacity
numbers and see what they add up to.

12
00:00:37,810 --> 00:00:41,880
To do this in sequel,
we just need to select the sum of

13
00:00:41,880 --> 00:00:46,880
the capacity column from the rooms table.

14
00:00:49,410 --> 00:00:52,610
Semicolon, and then run the query,
and there we go.

15
00:00:52,610 --> 00:00:56,300
We have a capacity for 596 total students.