How many problems has staff named Lysanne Turcotte reported?
select count(*) from problems as t1 join staff as t2 on t1.reported_by_staff_id = t2.staff_id where t2.staff_first_name = "Lysanne" and t2.staff_last_name = "Turcotte"
Show me their ids, and problem descriptions.
select problem_id, problem_description from problems as t1 join staff as t2 on t1.reported_by_staff_id = t2.staff_id where t2.staff_first_name = "Lysanne" and t2.staff_last_name = "Turcotte"
What is the oldest date these were reported?
select min(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 = "Lysanne" and t2.staff_last_name = "Turcotte"
Show me the ids of all the other problems that were reported before 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 min(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 = "Lysanne" and t4.staff_last_name = "Turcotte" )