Table: miss_universe_countries
Columns: country_territory
former_pageant
last_competed
new_pageant
franchise_since

Question: which country has miss universe Hungary as former pageant?
SQL: SELECT "country_territory" FROM miss_universe_countries WHERE "former_pageant" = 'Miss Universe Hungary'

Question: which is the former pageant in the country where the new pageant is miss bahamas?
SQL: SELECT "former_pageant" FROM miss_universe_countries WHERE "new_pageant" = 'Miss Bahamas'

Question: when did new zealand last compete?
SQL: SELECT MAX("last_competed") FROM miss_universe_countries WHERE "country_territory" = 'New Zealand'

Question: How many new pageants does Aruba have?
SQL: SELECT COUNT("new_pageant") FROM miss_universe_countries WHERE "country_territory" = 'Aruba'

Question: which is the new pageant from spain?
SQL: SELECT "new_pageant" FROM miss_universe_countries WHERE "country_territory" = 'Spain'