Scribd
Upload
2 views1 page

SQL Queries for Sales Analysis Report

The document outlines various SQL queries to analyze sales data, including running totals, organizational charts, and customer order fulfillment. It also includes performance metrics for employees, product sales by month, and warehouse inventory details. The queries aim to provide insights into sales performance and inventory management.

Uploaded by

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

SQL Queries for Sales Analysis Report

The document outlines various SQL queries to analyze sales data, including running totals, organizational charts, and customer order fulfillment. It also includes performance metrics for employees, product sales by month, and warehouse inventory details. The queries aim to provide insights into sales performance and inventory management.

Uploaded by

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

SQL Set 1

1 Daywise running total of total sale (ordered amount)

2 Orgchart for organization and total sale at each employee level

3 List of customers whose orders are fulfilled from other contries

4 List of products sold its sold quanity in each month and sold quantity before sixth month

5 Second Top and second from bottom performer employee of the year

6 Select total qty and total amount when


product sold at List (standard) Price
and sold at different price other than
standard price

7 Name of Employees and total amount of order he sold in each month


Jan Feb … Dec
Salesman1 1000 2000 5000
Salesman2 1000 2000 5000
Salesman3 1000 2000 5000

8 Name and location of warehouses which has inventory for all products of same category

You might also like