CREATE TABLE problems (problem_id NUMBER, product_id NUMBER, closure_authorised_by_staff_id NUMBER, reported_by_staff_id NUMBER, date_problem_reported TIME, date_problem_closed TIME, problem_description CLOB, other_problem_details CLOB)
CREATE TABLE staff (staff_id NUMBER, staff_first_name CLOB, staff_last_name CLOB, other_staff_details CLOB)
CREATE TABLE problem_category_codes (problem_category_code CLOB, problem_category_description CLOB)
CREATE TABLE product (product_id NUMBER, product_name CLOB, product_details CLOB)
CREATE TABLE problem_log (problem_log_id NUMBER, assigned_to_staff_id NUMBER, problem_id NUMBER, problem_category_code CLOB, problem_status_code CLOB, log_entry_date TIME, log_entry_description CLOB, log_entry_fix CLOB, other_log_details CLOB)
CREATE TABLE problem_status_codes (problem_status_code CLOB, problem_status_description CLOB)

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"