Question

Create sql query command for the following.

Modify your query and produce the following results. Customer #000000001 1 1428873.61 9 Customer #000000002 2 1156504.92 10 Customer #000000004 4 4134567.39 31 Customer#000000005 5 1084042.74 9 Customer #000000007 7 3922020.98 24 Column 1 is the customer Name, Column 2, is the customer key, column 3 is the total of the customer orders ($$) and column 4 is the number of orders.

Answer 1

• Select customer_name, customer_key,sum(order_amount),count(orders) from customers group by customer_key;

This query retrieves the name, key and the count of orders and the amount for all orders. We have just written the name and key attribute here, then we need the sum of amount so we have written sum function it adds the respective amount in that column and the count function will give the count of orders.

Niw if we simply write this the result will be horrible, here we need to have for every respective customer individually, for that we are using group by Clause it groups according to the given attribute. In this it is customer key we are given. It groups according to the customer key then gives the result.