Fill in the order form to get the price

Subject

Category

Deadline

Timezone:

Title *

Task *

{"ops":[{"insert":"1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Display 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)\n2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Display 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)\n3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0From customers table, Count all customers is each region where region is not null. (Table: Customers)\n4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Write a query to display the number of ContactName with same ContactTitle. Sort contact title in descending order. (Table: Customers)\n5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Write a query that count all orders against each product id. No of orders should be greater than 50. (Table: [Order Details])\n"}]}

I need basic explanations

Special Requirements

Upload files (if required)

Drop files here to upload

Add files...

Account info

Already have an account?

Name *

E-mail *

Password *

The password must be at least 6 characters.

I agree with terms & conditions