Question

1. Display the average standard_price of all products in product_T that are of ProductFinish Cherry 2. Display the ProductID of all orders that had more than 5 items 3. Display the Product Description of all orders that had more than 10 Items 4. Display the customer name and telephone of all customers living in either Grant, Evergreen 5. display the number of salesperson for each TerritoryID (Tips: group by) 6. Use equi join with DoesBusinessIn_T and customer_T to display: the name and city of customer in Territory 'SouthEast' 7. Use subquery with DoesBusinessIn_T and customer_T to display: the name and city of customer in Territory 'SouthEast' 8. Use Inner join to ffflist the names of all the courses that 'Letersky' took in the past. 9. Display the number of students registered for course 'database'. 10 list all the students not registered for section 2714. 11. How many patients does physician 'Hematology' care for? 12. show the number of employees for each care center (Tips: group by).

          1. Display the average standard_price of all products in product_T that are of ProductFinish Cherry
2. Display the ProductID of all orders that had more than 5 items
3. Display the Product Description of all orders that had more than 10 Items
4. Display the customer name and telephone of all customers living in either Grant, Evergreen
5. display the number of salesperson for each TerritoryID (Tips: group by)
6. Use equi join with DoesBusinessIn_T and customer_T to display: the name and city of customer in Territory 'SouthEast'
7. Use subquery with DoesBusinessIn_T and customer_T to display: the name and city of customer in Territory 'SouthEast'
8. Use Inner join to ffflist the names of all the courses that 'Letersky' took in the past.
9. Display the number of students registered for course 'database'.
10 list all the students not registered for section 2714.
11. How many patients does physician 'Hematology' care for?
12. show the number of employees for each care center (Tips: group by).

1. Display the average standardprice of all products in productT that are of ProductFinish Cherry
2. Display the ProductID of all orders that had more than 5 items
3. Display the Product Description of all orders that had more than 10 Items
4. Display the customer name and telephone of all customers living in either Grant, Evergreen
5. display the number of salesperson for each TerritoryID (Tips: group by)
6. Use equi join with DoesBusinessInT and customerT to display: the name and city of customer in Territory 'SouthEast'
7. Use subquery with DoesBusinessInT and customerT to display: the name and city of customer in Territory 'SouthEast'
8. Use Inner join to ffflist the names of all the courses that 'Letersky' took in the past.
9. Display the number of students registered for course 'database'.
10 list all the students not registered for section 2714.
11. How many patients does physician 'Hematology' care for?
12. show the number of employees for each care center (Tips: group by).

Added by Nicolas P.

Question

Please give Ace some feedback