CREATE TABLE stadium (id NUMBER, name CLOB, capacity NUMBER, city CLOB, country CLOB, opening_year NUMBER)
CREATE TABLE event (id NUMBER, name CLOB, stadium_id NUMBER, year CLOB)
CREATE TABLE swimmer (id NUMBER, name CLOB, nationality CLOB, meter_100 NUMBER, meter_200 CLOB, meter_300 CLOB, meter_400 CLOB, meter_500 CLOB, meter_600 CLOB, meter_700 CLOB, time CLOB)
CREATE TABLE record (id NUMBER, result CLOB, swimmer_id NUMBER, event_id NUMBER)

Find the names of stadiums whose capacity is smaller than the average capacity.
SELECT name FROM stadium WHERE capacity < (SELECT AVG(capacity) FROM stadium)
SELECT "name" FROM "stadium" WHERE "capacity" < (SELECT AVG("capacity") FROM "stadium")