SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: Total sales of each month of customer

Madhu.149Sep 27 2013 — edited Sep 27 2013

Dear All,

I have the below two tables

Customers (customer_id, custer_name,customer_address)

Sales (sales_id, sales_cust_id, sales_order_date, sales_amount)

I need to write the SQL query to display the total sales made by each customer, each month with grand total of all months of current year

can anyone help regarding this..

Sample

customer_id	customer_name	month	total_sales
12	aaa	Jan	15242
12	aaa	Feb	17889
		(Total)	33131
13	bbb	Feb	1487
13	bbb	Jun	19987
		(Total)	21474

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2013

Added on Sep 27 2013

6 comments

1,447 views