CREATE TABLE problems (problem_id VARCHAR2, reported_by_staff_id VARCHAR2)
CREATE TABLE staff (staff_id VARCHAR2, staff_last_name VARCHAR2)

Find the ids of the problems that are reported by the staff whose last name is 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"
SELECT "T1"."problem_id" FROM "problems" "T1" JOIN "staff" "T2" ON "Bosco" = "T2"."staff_last_name" AND "T1"."reported_by_staff_id" = "T2"."staff_id"