Table: irish_national_cycling_champs
Columns: year
location
gold
silver
bronze

Question: What location did david mccann receive a siver and morgan fox win the gold?
SQL: SELECT "location" FROM irish_national_cycling_champs WHERE "silver" = 'david mccann' AND "gold" = 'morgan fox'

Question: Who received the bronze in 2011?
SQL: SELECT "bronze" FROM irish_national_cycling_champs WHERE "year" = '2011'

Question: Who received the silver in 2006?
SQL: SELECT "silver" FROM irish_national_cycling_champs WHERE "year" = '2006'