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

Question

1.      How 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)

2.      List only those cities in which more than or equals to 2 employees are living.

3.      From the [Order Details] table, select the Product’s id , maximum price and minimum price for each specific product in the table, sort the list by product id in ascending order.

4.      Retrieve the number of employees in each city in which there are at least 2 employees.

5.      Find the product name, maximum price and minimum price of each product having maximum price greater than 20.00 $. Order by maximum price.

6.      Find the number of sales representatives in each city that contains at least 2 sales representatives. Order by the number of employees.

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