Skip to main content
Roudy
Home
About
Portfolio
Library
Quiz
Snake
SQL PROFICIENCY TEST
Question 1 of 5
You have a table employees(id, name, department, salary). Which query returns all employees in the 'Engineering' department earning more than $80,000?
A)
SELECT * FROM employees WHERE department = 'Engineering' AND salary > 80000
B)
SELECT * FROM employees WHERE department = 'Engineering' OR salary > 80000
C)
SELECT name FROM employees WHERE department = Engineering AND salary > 80000
D)
SELECT * FROM employees WHERE department LIKE 'Engineering' AND salary >= 80000
← Previous
Next →