Table: province_population_trend
Columns: year
population
five_year_change
ten_year_change
rank_among_provinces

Question: What is the average year having a rank among provinces over 5 and ten-year percentage change of 67.3?
SQL: SELECT AVG("year") FROM province_population_trend WHERE "ten_year_change" = '67.3' AND "rank_among_provinces" > 5

Question: What is the highest population for the province having a rank under 5?
SQL: SELECT MAX("population") FROM province_population_trend WHERE "rank_among_provinces" < 5

Question: What is the number of population values having a rank among provinces under 5 with a five-year percentage change of 3.6?
SQL: SELECT COUNT("population") FROM province_population_trend WHERE "five_year_change" = '3.6' AND "rank_among_provinces" < 5

Question: What is the highest year having a ten-year percentage change of 7.9?
SQL: SELECT MAX("year") FROM province_population_trend WHERE "ten_year_change" = '7.9'