Question: 1 . Find average product ( item ) price. 2 . Find the total number of orders by each city. Display city names by order
Find average product item price.
Find the total number of orders by each city. Display city names by order counts.
Find the total number of orders by each customer.
a Display result by cid attribute.
b Display result by fname and lname attributes.
Calculate and display order prices for customer Display order id and order price values.
List the cities which had orders on and Use division operation
Find all addresses for customer Display all address details. Use division operation
Find the customers who ordered the most expensive items Display only the customers full names.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
