with table like this I want to answer:
AnnualReviews tables, write a query to return all employees who have never had a review sorted by HireDate.
Here is my query, kindly help to correction:
from Employee a leftjoin AnnualReviews b ON a.
ID = b.
where HireDate desc
SELECT * FROM employee WHERE terminationdate IS NULL AND lastname LIKE ‘SMITH%’ ORDER BY lastname, firstname;