Order Volume, Customer by Customer
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
totalorders

13. Order Volume, Customer by Customer

Count total orders per customer and display them alongside each order.

Xorthax is reviewing his intergalactic sales data. Help him count the total number of orders placed by each customer at his trading post. Display each order's details along with the total number of orders for that customer.
Write Your Query