Database: tracking_software_problems
Question: Which staff members are assigned to the problem with id 1? Give me their first and last names.
SQL:
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