How many unique orders in the orderdetails table
computer science
Description
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
Updatedmy_sampledatabase3.sql
197.2 KB
