user: ### NOW ANSWER:
Question: Name the average founded with joined less than 2008
Columns: ['Institution', 'Location', 'Nickname', 'Founded', 'Type', 'Enrollment', 'Joined']
Types: ['text', 'text', 'text', 'real', 'text', 'real', 'real']
Sample row: ['Bay Path College †', 'Longmeadow, Massachusetts', 'Wildcats', 1897.0, 'Private', 1501.0, 2008.0]
SQL:

assistant: SELECT AVG("Founded") FROM "Table" WHERE "Joined" < 2008.0;