CREATE TABLE table_name_88 (founded NUMBER, joined NUMBER)

Name the average founded with joined less than 2008
SELECT AVG(founded) FROM table_name_88 WHERE joined < 2008
SELECT AVG("founded") FROM "table_name_88" WHERE "joined" < 2008