Find the name and gender of the staff who has been assigned the job of Sales Person but never Clerical Staff.
CREATE TABLE staff (
    staff_name VARCHAR,
    staff_gender VARCHAR,
    staff_id VARCHAR
)

CREATE TABLE Staff_Department_Assignments (
    staff_id VARCHAR,
    job_title_code VARCHAR
)
SELECT T1.staff_name, T1.staff_gender FROM staff AS T1 JOIN Staff_Department_Assignments AS T2 ON T1.staff_id = T2.staff_id WHERE T2.job_title_code = "Sales Person" EXCEPT SELECT T1.staff_name, T1.staff_gender FROM staff AS T1 JOIN Staff_Department_Assignments AS T2 ON T1.staff_id = T2.staff_id WHERE T2.job_title_code = "Clerical Staff"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the name and gender of the staff who has been assigned the job of Sales Person but never Clerical Staff. ### Input: CREATE TABLE staff (
    staff_name VARCHAR,
    staff_gender VARCHAR,
    staff_id VARCHAR
)

CREATE TABLE Staff_Department_Assignments (
    staff_id VARCHAR,
    job_title_code VARCHAR
) ### Response: SELECT T1.staff_name, T1.staff_gender FROM staff AS T1 JOIN Staff_Department_Assignments AS T2 ON T1.staff_id = T2.staff_id WHERE T2.job_title_code = "Sales Person" EXCEPT SELECT T1.staff_name, T1.staff_gender FROM staff AS T1 JOIN Staff_Department_Assignments AS T2 ON T1.staff_id = T2.staff_id WHERE T2.job_title_code = "Clerical Staff"