Generation

text to sql syntaxWed, 11 Jan 2023

Write a query that returns the employee_id, last name, and hire date of the employees --who have worked for more than 90 months since the date of employment which is January 01, 2000.

SELECT employee_id,last_name,hire_date FROM employees WHERE hire_date > (CURDATE() - INTERVAL 90 MONTH);

Want to kickstart your project?Use the new AI Studio to create your code