user: ### NOW ANSWER:
Question: What was the preliminary average for the one who had a semifinal average of 8.966 (3)?
Columns: ['State', 'Preliminary Average', 'Interview', 'Swimsuit', 'Evening Gown', 'Semifinal Average']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Florida', '8.336 (6)', '8.785 (4)', '9.036 (1)', '9.055 (5)', '8.958 (4)']
SQL:

assistant: SELECT "Preliminary Average" FROM "Table" WHERE "Semifinal Average" = '8.966 (3)';