A. Describe the data in hand in your own words. (Word Limit is 500)
B. Identify and list the Primary Keys and Foreign Keys for this dataset
Write the SQL queries for the following:
A. Find the total and the average sales
B. Display the number of customers in each region in decreasing order of no_of_customers. The result should contain columns Region, no_of_customers
C. Find the region having maximum customers
D. Find the number and id of products sold in decreasing order of products sold
E. Find all the customers from Atlantic region who have ever purchased ‘TABLES’ and the number of tables purchased
Write sql queries for the following:
A. Display the product categories in descending order of profits?
B. Display the product category, product sub-category and the profit within each sub-category in three columns.
C. Where is the least profitable product subcategory shipped the most? For the least profitable product sub-category, display the region-wise no_of_shipments and the profit made in each region in decreasing order of profits (i.e. region, no_of_shipments, profit_in_each_region)