Question

You want to create a report that includes each employee's last name, employee identification number, date of hire, and salary. The report should include only those employees who have been with the company for more than one year and whose salary exceeds $40,000. Which of the following select statements will accomplish this task?

a) SELECT * FROM employees WHERE hire_date > DATE_SUB(NOW(), INTERVAL 1 YEAR) AND salary > 40000;
b) SELECT last_name, employee_id, hire_date, salary FROM employees WHERE hire_date < DATE_SUB(NOW(), INTERVAL 1 YEAR) AND salary > 40000;
c) SELECT last_name, employee_id, hire_date, salary FROM employees WHERE hire_date < DATE_SUB(NOW(), INTERVAL 1 YEAR) OR salary > 40000;
d) SELECT last_name, employee_id, hire_date, salary FROM employees WHERE hire_date < DATE_SUB(NOW(), INTERVAL 1 YEAR) AND salary > 40000;

Answer 1

The correct select statement to generate the requested report is option d.

Step-by-step explanation:

The correct select statement that will accomplish the task is d) SELECT last_name, employee_id, hire_date, salary FROM employees WHERE hire_date < DATE_SUB(NOW(), INTERVAL 1 YEAR) AND salary > 40000;

This select statement correctly selects the last_name, employee_id, hire_date, and salary columns from the employees table. It also includes the conditions that hire_date must be less than one year from the current date and salary must exceed $40,000.

The other options (a, b, and c) either include incorrect conditions or select all columns from the table.