MySQL Employee Join Query | Dataford Interview Questions

Write a MySQL query to retrieve all the employees who joined within three years from an employee table.

Use PostgreSQL syntax for the solution. Interpret this as the three-year period ending today, excluding future joining dates and employees with missing joining dates.

Output

One row per qualifying employee.
Columns: employee_id, employee_name, and joined_date.
Order by joined_date descending, then employee_id ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
joined_date	DATE	Date the employee joined the organization

Your question is MySQL Employee Join Query. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem