How many unique orders in the orderdetails table

computer science


Base on the Sample DB created, please write the SQL query for the Questions below:

1. Show the total employee in the  employees table .

2. Find the employees with multiple records with same email (Hint: using Having)

3. How many unique orders in the orderdetails  table.

4.List the latest ten orders in the orderdetails table.

5. Find the order with largest amount ( Quantity * unit price) in the orderdeatils table.

6. Delete the order with order number 10100 in the orders table.

7. why it will be failed when you run the query 6?

Instruction Files

Related Questions in computer science category