Answer to Question #332508 in Databases | SQL | Oracle | MS Access for Babar302

Question

1.      Display the highest, lowest, sum and average UnitPrice of each Category. Label column as CategoryId, Maximum, Minimum, Sum and Average, respectively. Round your results to the nearest whole number. (Table: Products)

2.      Display the highest, lowest, sum and average UnitPrice of each Category, where highest UnitPrice lies in the range of 50$ to 100$. Label column as CategoryId, Maximum, Minimum, Sum and Average, respectively. (Table: Products)

3.      From customers table, Count all customers is each region where region is not null. (Table: Customers)

4.      Write a query to display the number of ContactName with same ContactTitle. Sort contact title in descending order. (Table: Customers)

5.      Write a query that count all orders against each product id. No of orders should be greater than 50. (Table: [Order Details])

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order