What state or province has the most staff living in it?
select t1.state_province_county from addresses as t1 join staff as t2 on t1.address_id = t2.staff_address_id group by t1.state_province_county order by count ( * ) desc limit 1
What is the number of staff living in Georgia?
select count ( * ) from addresses as t1 join staff as t2 on t1.address_id = t2.staff_address_id group by t1.state_province_county order by count ( * ) desc limit 1
What city in Georgia has the most staff living in it?
select t1.city from addresses as t1 join staff as t2 on t1.address_id = t2.staff_address_id where t1.state_province_county = "Georgia" group by t1.city order by count ( * ) desc limit 1
both please
select t2.first_name, t2.last_name from addresses as t1 join staff as t2 on t1.address_id = t2.staff_address_id where t1.city = "Port Melyssa"
What are all their birthdays?
select t2.date_of_birth from addresses as t1 join staff as t2 on t1.address_id = t2.staff_address_id where t1.city = "Port Melyssa"