user: ### NOW ANSWER:
Question: When was the University founded that joined in 1978?
Columns: ['Institution', 'Location', 'Nickname', 'Founded', 'Type', 'Enrollment', 'Joined']
Types: ['text', 'text', 'text', 'real', 'text', 'real', 'real']
Sample row: ['Averett University', 'Danville, Virginia', 'Cougars', 1859.0, 'Private/Non-sectarian', 2719.0, 1978.0]
SQL:

assistant: SELECT MAX("Founded") FROM "Table" WHERE "Joined" = 1978.0;