Table: miss_earth_runners
Columns: year
miss_earth
miss_air_1st_runner_up
miss_water_2nd_runner_up
miss_fire_3rd_runner_up

Question: What year was Caroline Medina Miss Fire (3rd Runner-up)?
SQL: SELECT AVG("year") FROM miss_earth_runners WHERE "miss_fire_3rd_runner_up" = 'caroline medina'

Question: Who won Miss Air (1st Runner-up) when Catherine Untalan was Miss Water (2nd Runner-up) earlier than 2007?
SQL: SELECT "miss_air_1st_runner_up" FROM miss_earth_runners WHERE "year" < 2007 AND "miss_water_2nd_runner_up" = 'catherine untalan'