What is the staff id of Bosco?
select staff_id from staff where staff_last_name = "Bosco"
Are there any problems reported by staff id 1?
select problem_id from problems where reported_by_staff_id = 1
How many total problems are there reported by staff ID 1?
select count ( * ) from problems where reported_by_staff_id = 1
What is the full set of information associated with staff with last name Bosco?
select * from staff where staff_last_name = 'Bosco'
What are the ids of the problems reported by staff first name Lacey?
select t1.problem_id from problems as t1 join staff as t2 on t1.reported_by_staff_id = t2.staff_id where t2.staff_first_name = "Lacey"
Find the ids of all problems reported by staff with last name Bosco
select t1.problem_id from problems as t1 join staff as t2 on t1.reported_by_staff_id = t2.staff_id where t2.staff_last_name = "Bosco"