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 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
Get step-by-step solutions from verified subject matter experts
