Scribd
Upload
4 views5 pages

Customer Orders and Revenue Analysis

The document outlines a series of queries related to customer orders, products, and sales data. Key tasks include calculating total revenue by country, identifying furniture products, analyzing order details based on sales and discounts, and determining customer order frequency. Additional queries focus on profit analysis, net sales calculations, and order status counts.

Uploaded by

nf5rj85my9
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views5 pages

Customer Orders and Revenue Analysis

The document outlines a series of queries related to customer orders, products, and sales data. Key tasks include calculating total revenue by country, identifying furniture products, analyzing order details based on sales and discounts, and determining customer order frequency. Additional queries focus on profit analysis, net sales calculations, and order status counts.

Uploaded by

nf5rj85my9
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Customer (CusID, CusName, CusCountry, CusCity, CusState, CusRegion,

CusEmail)
Orders (OrdID, OrdDate, ShipMode, CusID)
Product (ProID, Category, Sub-Category)
Order_Detail (OrdID, ProID, Sales, Quantity, Discount, Profit, OrdStatus)

1. Find the total revenue generated from each country.


2. List all products that belong to the 'Furniture' category.
3. Show all order details where the sales amount is greater than 500.
4. Find the average profit for each product sub-category.
5. Find the customer who has placed the highest number of orders (most frequent buyer).
6. Calculate the Net Sales (Total Sales after Discount) for each order detail.
7. Find order details where the quantity is greater than 5 and the discount is higher than
10%.
8. List all orders where the profit is less than 0.
9. List all invoices where the total transaction amount exceeds 2,000.
[Link] the number of orders for each status in the Order_Detail table.

You might also like