Fill in the order form to get the price

Subject

Category

Deadline

Timezone:

Title *

Task *

{"ops":[{"insert":"1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0How many people are in each unique city in the employee table that have more than one person in the city? Select the city and display the number of how many people are in each if it's greater than 1.(Table: Employees)\n2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0List only those cities in which more than or equals to 2 employees are living.\n3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0From the [Order Details] table, select the Product\u2019s id , maximum price and minimum price for each specific product in the table, sort the list by product id in ascending order. \n4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Retrieve the number\u00a0of employees\u00a0in each city in which there are\u00a0at least 2 employees.\n5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Find the product name, maximum price and minimum price of each product having maximum price greater than 20.00 $. Order by maximum price. \n6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Find the number\u00a0of sales representatives\u00a0in each city that\u00a0contains at least\u00a02 sales representatives.\u00a0Order by the number\u00a0of employees.\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