What are the staff names with job title code Sales Person?
SELECT T1.staff_name  FROM staff AS T1 JOIN Staff_Department_Assignments AS T2 ON T1.staff_id   =   T2.staff_id WHERE T2.job_title_code   =   "Sales Person"
staff names with job title code Sales Person refers to filtering staff based on job_title_code = 'Sales Person'; joining tables staff and Staff_Department_Assignments on staff_id;