user: ### NOW ANSWER:
Question: How many joined the Warriors?
Columns: ['Institution', 'Location', 'Founded', 'Type', 'Enrollment', 'Joined', 'Nickname']
Types: ['text', 'text', 'real', 'text', 'real', 'real', 'text']
Sample row: ['Briar Cliff University', 'Sioux City, Iowa', 1930.0, 'Private', 1150.0, 2002.0, 'Chargers']
SQL:

assistant: SELECT COUNT("Joined") FROM "Table" WHERE "Nickname" = 'Warriors';