Table: gaeltacht_data
Columns: county
english_name
irish_name
population
irish_speakers

Question: What is the population for County Mayo with the English Name Carrowteige?
SQL: SELECT "population" FROM gaeltacht_data WHERE "county" = 'County Mayo' AND "english_name" = 'Carrowteige'

Question: What is the Irish name listed with 62% Irish speakers?
SQL: SELECT "irish_name" FROM gaeltacht_data WHERE "irish_speakers" = '62%'

Question: What is the population for the Irish Name Leitir mealláin?
SQL: SELECT "population" FROM gaeltacht_data WHERE "irish_name" = 'Leitir Mealláin'

Question: What is the county for the Irish name Carna?
SQL: SELECT "county" FROM gaeltacht_data WHERE "irish_name" = 'Carna'

Question: How many County Kerry have 53% Irish speakers?
SQL: SELECT COUNT("english_name") FROM gaeltacht_data WHERE "irish_speakers" = '53%' AND "county" = 'County Kerry'

Question: What is the population for the English name Spiddal?
SQL: SELECT "population" FROM gaeltacht_data WHERE "english_name" = 'Spiddal'