Window Functions in SQL | Dataford Interview Questions

Tell me about a window function query you have written or debugged.

Using the provided tables, write a PostgreSQL query that returns the latest review for every employee, including employees who have no reviews. If an employee has multiple reviews on the latest date, select the review with the greatest review ID.

Output

One row per employee, ordered by employee_id ascending.
Columns: employee_id, employee_name, department, review_id, review_date, and rating.
Employees without reviews must remain in the result with NULL review fields.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee display name
department	VARCHAR(100)	Employee department

employee_reviews

Column	Type	Description
review_idPK	INT	Unique review identifier
employee_id	INT	Employee receiving the review
review_date	DATE	Date the review was recorded
rating	INT	Review rating from 0 to 5
review_status	VARCHAR(30)	Review workflow status

Your question is Window Functions in SQL. Start with the requirements and the two tables 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