Users With No Orders | Dataford Interview Questions

Grammarly's commerce team wants to identify users who have never placed an order. Write a PostgreSQL query that finds these users from the users and orders tables.

Requirements

Return each qualifying user's user_id and full_name.
Include users with no matching order, including users who have never purchased Grammarly Pro or another paid product.
Exclude users who have at least one order, and do not let orphaned or incomplete order records create false matches.
Sort the results alphabetically by full_name, then by user_id.

Schema

users

Column	Type	Description
user_idPK	INTEGER	Unique Grammarly user identifier
full_name	VARCHAR(100)	User's display name
email	VARCHAR(255)	User's email address

orders

Column	Type	Description
order_idPK	INTEGER	Unique order identifier
user_id	INTEGER	User associated with the order
product_name	VARCHAR(100)	Purchased Grammarly product
order_status	VARCHAR(20)	Order processing status

Your question is Users With No Orders. 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