What are the problem reported by named Ryan Homenick.
select * from staff as t1 join problems as t2 on t1.staff_id = t2.reported_by_staff_id where t1.staff_first_name = "Rylan" and t1.staff_last_name = "Homenick"
How about the problems on which closure is authorized by him?
select from staff as t1 join problems as t2 on t1.staff_id = t2.closure_authorised_by_staff_id where t1.staff_first_name = "Rylan" and t1.staff_last_name = "Homenick"
Actually can you show the different problem_logs that he is assigned to!
select * from staff as t1 join problem_log as t2 on t1.staff_id = t2.assigned_to_staff_id where t1.staff_first_name = "Rylan" and t1.staff_last_name = "Homenick"
For these, show the distinct problem ids and log ids!
select distinct t2.problem_id, t2.problem_log_id from staff as t1 join problem_log as t2 on t1.staff_id = t2.assigned_to_staff_id where t1.staff_first_name = "Rylan" and t1.staff_last_name = "Homenick"