What are all the names of the staff members that have reported problems?
select t2.staff_first_name, t2.staff_last_name from problems as t1 join staff as t2 on t1.reported_by_staff_id = t2.staff_id
What was the problem id and date of the last problem they each reported?
select t2.staff_first_name, t2.staff_last_name, t1.problem_id, max(date_problem_reported) from problems as t1 join staff as t2 on t1.reported_by_staff_id = t2.staff_id group by t2.staff_first_name, t2.staff_last_name
Show me the date for staff named Ryan Homenick
select max(date_problem_reported) from problems as t1 join staff as t2 on t1.reported_by_staff_id = t2.staff_id where t2.staff_first_name = "Rylan" and t2.staff_last_name = "Homenick"
Now show any problem id that was reported after this date!
select t1.problem_id from problems as t1 join staff as t2 on t1.reported_by_staff_id = t2.staff_id where date_problem_reported > ( select max(date_problem_reported) from problems as t3 join staff as t4 on t3.reported_by_staff_id = t4.staff_id where t4.staff_first_name = "Rylan" and t4.staff_last_name = "Homenick" )