How many problem logs have to do with problem id 1?
select count(*) from problem_log where problem_id = 1
Show the log ids, dates, descriptions for these.
select problem_log_id, log_entry_date, log_entry_description from problem_log where problem_id = 1
Also show the staff for each.
select problem_log_id, log_entry_date, log_entry_description, assigned_to_staff_id from problem_log where problem_id = 1
Can you give me a distinct list of the names of all staff members!
select distinct staff_first_name, staff_last_name from staff as t1 join problem_log as t2 on t1.staff_id = t2.assigned_to_staff_id where t2.problem_id = 1