user: Question: What location did David McCann receive a siver and Morgan Fox win the gold?
Columns: ['Year', 'Location', 'Gold', 'Silver', 'Bronze']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1997', 'Carrick On Suir', 'Morgan Fox', 'David McCann', 'Raymond Clarke']
SQL:

assistant: SELECT "Location" FROM "Table" WHERE "Silver" = 'David McCann' AND "Gold" = 'Morgan Fox';