Practice SQL Window Functions | Xorthax's Trading Post

Tables Used

orders

Column	Type
orderid	bigint
customerid	bigint
orderdate	timestamp without time zone
totalamount	double precision
status	text

Expected Output

Column
customerid
totalorders
frequencytier

35. Customer Frequency Classes

Group customers by how often they place orders at Xorthax's post.

Xorthax wants to segment customers into 3 groups based on the total number of orders they placed. Write a query to assign each customer to a transaction frequency tier.

Write Your Query