Table: envirothon_results
Columns: year
host
1st_place
2nd_place
3rd_place
4th_place
5th_place

Question: What is the 1st place when Pennsylvania finished 2nd place?
SQL: SELECT "1st_place" FROM envirothon_results WHERE "2nd_place" = 'Pennsylvania'

Question: What is the 2nd place when Virginia finished in 1st place?
SQL: SELECT "2nd_place" FROM envirothon_results WHERE "1st_place" = 'Virginia'

Question: How many years did Florida finish in 4th place?
SQL: SELECT COUNT("year") FROM envirothon_results WHERE "4th_place" = 'Florida'

Question: What is the total number of 3rd placed teams when the host is University of Manitoba, Winnipeg, Manitoba?
SQL: SELECT COUNT("3rd_place") FROM envirothon_results WHERE "host" = 'University of Manitoba, Winnipeg, Manitoba'

Question: Who was in 4th place when Missouri finished in 3rd place?
SQL: SELECT "4th_place" FROM envirothon_results WHERE "3rd_place" = 'Missouri'