how many students are living in each state province county?
select count ( * ), state_province_county from addresses as t1 join students as t2 on t1.address_id = t2.address_id group by state_province_county
show me the first and last names of students in Wisconsin.
select t2.first_name, t2.last_name from addresses as t1 join students as t2 on t1.address_id = t2.address_id where t1.state_province_county = "Wisconsin"