You are working with the Chinook database and want to filter on the hiredate column to find all employees hired on or after ‘2003-10-17’ (October 17, 2003). Replace –??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)

Tools of the Trade: Linux and SQL | Weekly challenge 4 Quiz | 

You are working with the Chinook database and want to filter on the hiredate column to find all employees hired on or after ‘2003-10-17’ (October 17, 2003). Replace –??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)

SELECT firstname,lastname,hiredateFROM employees–???
SELECT firstname,lastname,hiredate
FROM employees
–???

How many employees were hired on or after October 17, 2003?

  • 4
  • 1
  • 3
  • 2

 

Leave a Comment