Table: curling_olympics_2006
Columns: locale
skip
w
l
pf
pa
ends_won
ends_lost
blank_ends
stolen_ends
shot_pct

Question: What was the top ends lost where the ends won 47?
SQL: SELECT MAX("ends_lost") FROM curling_olympics_2006 WHERE "ends_won" = 47

Question: What was the location when the stolen ends is 12 and shot pct is 77%?
SQL: SELECT "locale" FROM curling_olympics_2006 WHERE "stolen_ends" = 12 AND "shot_pct" = '77%'

Question: How many stolen ends were there when the locale was Sweden?
SQL: SELECT "stolen_ends" FROM curling_olympics_2006 WHERE "locale" = 'Sweden'