Table: gaa_stadiums
Columns: rank
stadium
capacity
location
county

Question: What Gaelic Athletic Association stadium is located in Carrick-on-Shannon?
SQL: SELECT "stadium" FROM gaa_stadiums WHERE "location" = 'carrick-on-shannon'

Question: What is the Gaelic Football Stadium at McHale Park's ranking in total capacity?
SQL: SELECT COUNT("rank") FROM gaa_stadiums WHERE "stadium" = 'mchale park'