yes. my apologies.
select max ( capacity ) from classroom where building = "Lamberton"
What is the maximum capacity of all of the rooms?
select max ( capacity ) from classroom
How many rooms are there?
select sum ( room_number ) from classroom
What is the average capacity of the rooms?
select avg ( capacity ) from classroom
Which classroom is the smallest?
select * from classroom order by capacity limit 1
What room seats 120 people?
select * from classroom where capacity = 120