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

Question #332508

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])


0
Service report
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

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS