solulubeta
Sign in
SQL / Window functions & CTEs
06.07 · SQL

Latest purchase of each customer

For each customer who bought something, return customer_name, sale_date and total_price of their most recent sale.

Hard 3 min Pro

This lesson is part of solulu Pro

For each customer who bought something, return customer_name, sale_date and total_price of their most recent sale.

Lifetime ₹2,000 ₹1,000 · Beta offer
Mark this as done when you are finished.

Item 62 of 77 · updated 2026-10-12