First and Last Purchase Dates | Dataford Interview Questions

Write a SQL query to get the first and last purchase date for each customer.

Use the purchases table. Include customers whose records contain only a NULL purchase date.

Output

purchases

Column	Type	Description
purchase_idPK	INT	Unique identifier for the purchase
customer_id	INT	Identifier of the customer who made the purchase
purchase_date	DATE	Date on which the purchase occurred

Your question is First and Last Purchase Dates. 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.

Write a SQL query to get the first and last purchase date for each customer.

Use the purchases table. Include customers whose records contain only a NULL purchase date.

purchases

Column	Type	Description
purchase_idPK	INT	Unique identifier for the purchase
customer_id	INT	Identifier of the customer who made the purchase
purchase_date	DATE	Date on which the purchase occurred

Your question is First and Last Purchase Dates. 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.