CREATE TABLE race (race_id NUMBER, name CLOB, class CLOB, date CLOB, track_id CLOB)
CREATE TABLE track (track_id NUMBER, name CLOB, location CLOB, seating NUMBER, year_opened NUMBER)

What is the name, location and seating for the most recently opened track?
SELECT name, location, seating FROM track ORDER BY year_opened DESC LIMIT 1
SELECT "name", "location", "seating" FROM "track" ORDER BY "year_opened" DESC FETCH FIRST 1 ROWS ONLY