user: ### NOW ANSWER:
Question: If % mcconnell is 47.17% what is the total number of mcconnell ?
Columns: ['County', 'Precincts', 'Lunsford', '% Lunsford', 'McConnell', '% McConnell', 'Total']
Types: ['text', 'real', 'real', 'text', 'real', 'text', 'text']
Sample row: ['Adair', 16.0, 2198.0, '30.88%', 4920.0, '69.12%', '7,118 (R)']
SQL:

assistant: SELECT COUNT("McConnell") FROM "Table" WHERE "% McConnell" = '47.17%';