user: Question: What is the David Norris with a Michael D. Higgins that is 46.2%?
Columns: ['Constituency', 'Michael D. Higgins', 'Seán Gallagher', 'Martin McGuinness', 'Gay Mitchell', 'David Norris', 'Dana Rosemary Scallon', 'Mary Davis']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Carlow–Kilkenny', '36.7%', '33.8%', '12.4%', '7.7%', '4.8%', '2.7%', '1.9%']
SQL:

assistant: SELECT "David Norris" FROM "Table" WHERE "Michael D. Higgins" = '46.2%';