Which state have more than 2 staff members living there?
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 having count ( * ) > 2
Of those 2 states, which ones have less than 4 staff members living there?
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 having count ( * ) > 2 and count ( * ) < 4
Precisely how many staff members live in Connecticut?
select count ( * ) from addresses as t1 join staff as t2 on t1.address_id = t2.staff_address_id where t1.state_province_county = "Connecticut"
Can you list the first names of these 3 staff members?
select t2.first_name from addresses as t1 join staff as t2 on t1.address_id = t2.staff_address_id where t1.state_province_county = "Connecticut"
Can you provide me with the nickname of Janessa?
select nickname from staff where first_name = "Janessa"
Of the 3 staff members living in Connecticut, can you tell me which one joined the staff first?
select t2.first_name from addresses as t1 join staff as t2 on t1.address_id = t2.staff_address_id where t1.state_province_county = "Connecticut" order by date_joined_staff asc limit 1