human
Schema:
race (Race_ID, Name, Class, Date, Track_ID)
track (Track_ID, Name, Location, Seating, Year_Opened)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the total seating numbers from the track?
assistant
SELECT SUM( seating ) FROM track;
human
What about the minimum, maximum, and average?
assistant
SELECT MIN( seating ) , MAX( seating ) , AVG ( seating ) FROM track ;