Retrieve employees' names and job titles from the "Sales" department hired after January 1, 2020.

Question

Write an SQL query to retrieve the names and job titles of all employees in the "Sales" department who have been hired after January 1, 2020.

Accepted Answer

SELECT name, job_title
FROM employees
WHERE department = 'Sales' AND hire_date > '2020-01-01';

Answer

SELECT name, job_title
FROM employees
WHERE department LIKE '%Sales%' AND hire_date < '2020-01-01';

Answer

SELECT name, job_title
FROM employees
WHERE department = 'Sales' OR hire_date > '2020-01-01';

Answer

SELECT employee_id, name, job_title
FROM employees
WHERE department = 'Sales' AND hire_date > '2020-01-01';

Question from the SQL - Fundamentals test