MySQL Employee Join Query

EasySQL · PostgreSQL

Problem

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

Tablesemployees

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.