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.