Question

Create a query that shows columns employee last name, job title and hire date for those employees who joined the company on or after the first day of December 2016. Do not display job title of stock clerk. Show records in descending order by job title (Z to A).

Answer 1

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;

Step-by-step 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.