Answer:
SELECT last_name, job_title, hire_date FROM employee WHERE hire_date>="01-12-2016" AND job_title != "STOCK CLERK" ORDER BY job_title DESC;
Explanation:
The SQL code queries the employee table returning records of the last_name, job_title, and hire_date columns matching the employees hired on or after December 2016 and job titles that are not stock clerks in the employee table.
The WHERE and AND clause is responsible for the condition while the ORDER BY clause returns the query result in the of the job title in descending order.
I know that this might be wrong but is it light?
Answer:
1) = input and output should be defines precisely
2) = it shouldn't include computer code
