Self join Sql

Question

i have a table called Employees. i want to query last_name and hire_date for any employee hired after Taylor. i dont know how to write query for it. what i did is

select last_name, hire_date
from employees
where hire_date>(select hire_date from employees where last name='Taylor') ;

plz help me with this code

Answer 1

Your query looks reasonable. The only problem I see is you're missing an underscore in the last mention of 'last name'. If after fixing this it still doesn't work, post what output you get and what you expect instead.