What is the total seating numbers from the track?
select sum(seating) from track
What about the average value?
select avg(seating) from track
Which tracks have a higher seating number than that?
select * from track where seating > (select avg(seating) from track)
Only keep the name, location, open year of them.
select name, location, year_opened from track where seating > (select avg(seating) from track)