Table: pageant_results
Columns: city_nation
first_place
second_place
third_place
total_top_3_placements
first_place_winning_year_s_if_applicable

Question: What is the total number of second place finishes when the city & nation was Chicago, USA?
SQL: SELECT COUNT("second_place") FROM pageant_results WHERE "city_nation" = 'Chicago, USA'

Question: What is the total number of third place finishes when the city & nation was Vancouver, Canada?
SQL: SELECT MIN("third_place") FROM pageant_results WHERE "city_nation" = 'Vancouver, Canada'

Question: What is the largest third place finish when first place winning year(s) (if applicable) was n/a?
SQL: SELECT MAX("third_place") FROM pageant_results WHERE "first_place_winning_year_s_if_applicable" = 'N/A'

Question: What is the smallest third place finish?
SQL: SELECT MIN("third_place") FROM pageant_results