Table: riga_marathon_stats
Columns: country
total
marathon_mens
marathon_womens
half_marathon_mens
half_marathon_womens

Question: What is the minimum number for the half marathon (womens)?
SQL: SELECT MIN("half_marathon_womens") FROM riga_marathon_stats

Question: Whatis the total number of half marathon (mens) that represented kazakhstan?
SQL: SELECT COUNT("half_marathon_mens") FROM riga_marathon_stats WHERE "country" = 'Kazakhstan'

Question: What is amount of countries where half marathon (women) is larger than 1.0?
SQL: SELECT COUNT("country") FROM riga_marathon_stats WHERE "half_marathon_womens" > 1.0

Question: How many times is Moldova the winner of half marathon (womens)?
SQL: SELECT COUNT("half_marathon_womens") FROM riga_marathon_stats WHERE "country" = 'Moldova'

Question: Which country has half marathon (womens) that is larger than 1.0?
SQL: SELECT "country" FROM riga_marathon_stats WHERE "half_marathon_womens" > 1.0