Table: earth_rankings
Columns: rank
country_territory
miss_earth
miss_air
miss_water
miss_fire
semifinalists
total

Question: What is the highest total for any country/territory? 
SQL: SELECT MAX("total") FROM earth_rankings

Question: How many semifinalists has Romania had? 
SQL: SELECT "semifinalists" FROM earth_rankings WHERE "country_territory" = 'Romania'

Question: How many Miss Waters has Canada had?
SQL: SELECT MAX("miss_water") FROM earth_rankings WHERE "country_territory" = 'Canada'

Question: What is the most Miss Fires any country has had?
SQL: SELECT MAX("miss_fire") FROM earth_rankings

Question: What is the least amount of Miss Airs any country has had?
SQL: SELECT MIN("miss_air") FROM earth_rankings