SQL Sorting by Last Name | Dataford Interview Questions

Your question is SQL Sorting by Last Name. Start with the requirements and the three tables on the right.

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

Problem

Retool administrators need a consistently organized member list for the Support Operations workspace. Write a PostgreSQL query that returns eligible workspace members and sorts their names by last name.

Requirements

Join users to workspace memberships and workspaces.
Return only users who are active and have an active membership in the Support Operations workspace.
Display the user ID, first name, last name, combined display name, and workspace role.
Sort by last name ascending, then first name ascending, with missing last names listed last.

Schema

users

Column	Type	Description
user_idPK	INTEGER	Unique user identifier
first_name	VARCHAR(50)	User's first name
last_name	VARCHAR(50)	User's last name
account_status	VARCHAR(20)	Current account state

workspaces

Column	Type	Description
workspace_idPK	INTEGER	Unique workspace identifier
workspace_name	VARCHAR(100)	Workspace display name

workspace_memberships

Column	Type	Description
membership_idPK	INTEGER	Unique membership identifier
workspace_id	INTEGER	Referenced workspace
user_id	INTEGER	Referenced user
membership_status	VARCHAR(20)	Current membership state
role	VARCHAR(30)	Role within the workspace