Question: Please help me find the right MySQL code based on the above logical schema. 1) Display CustomerState and Number of customers from that state for

 Please help me find the right MySQL code based on the

Please help me find the right MySQL code based on the above logical schema.

1) Display CustomerState and Number of customers from that state for states which have more than average number of customers from a state.

2) Display the order number and the total value of products purchased in all orders

3) Display the order number and the total value of products purchased for the largest value order

4) Display the name and address of the customer who place more than one order with the number of orders placed as Norders.

5) Display the SalespersonID and the number of distinct customers orders they have handled

6) Display total sales of products by productline

7) Display total sales of those products by productline which have been ordered in atleast 4 distinct orders.

8) Display total sales and salespersonID in descending order (based on sales) for those salaespersons sales value greater than 4000

9) Display total sales per productlinID for each salesperson

10) Display salespersonID of the salespersons who get more than average number of orders by salesperson

11) Display ProductLineID and the number of products ordered in it

For the rest of the query questions, please refer to the logical schema representations as follows when you're writing your SQL queries: Product T

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!