Calculating School Capacity0:56 with Ben Deitch
What's the total capacity of the school?
[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 up