IV. Write and execute the following SQL Queries:
1.Retrieve all orders along with the customer details who placed the order.
2. Find all products that have been ordered by a specific customer.
3. Retrieve the total sales for each product.
4. Find all customers who have placed at least one order.
5. Retrieve the total quantity of products ordered by each customer.
6. Find all orders and their order details for a specific customer.
7. Retrieve all products along with the total quantity ordered.
8. Find the total revenue generated from orders placed within a specific date range.
9. Retrieve all customers who have ordered a specific product.
10. Find the most frequently ordered product.
11. Retrieve the average order value for each customer.
12. Find all products that have never been ordered.
13. Retrieve the total number of orders placed each month.
14. Retrieve the total number of products ordered in each order.
15. Find the top 5 customers based on total spending.
16. Retrieve all orders placed on a specific date.
17. Find the total number of unique products ordered by each customer.
18. Retrieve the order details for the order with the highest total price.
19. Find the top 3 products based on the total quantity ordered.
20. Retrieve the total sales for each month.
21. Find the customer who has placed the most orders.
22. Retrieve the total number of orders for each status.
23. Find the order with the highest quantity of a single product.
24. Retrieve the customer details for the order with the highest total price.
25. Find the average quantity of products ordered per order.
Assuming the following relational schema in the DBMS Lab context: * `Customers(CustomerID, Name, Email, ...)` * `Orders(OrderID, CustomerID, OrderDate, TotalAmount, Status, ...)` * `OrderDetails(OrderDetailID, OrderID, ProductID, Quantity, UnitPrice)` * `Products(ProductID, ProductName, Price, ...)` Here are the SQL queries for the tasks: 1. ```sql SELECT Orders.*, Customers.* FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID; ``` 2. ```sql SELECT DISTINCT Products.* FROM Products JOIN OrderDetails ON Products.ProductID = OrderDetails.ProductID JOIN Orders ON OrderDetails.OrderID = Orders.OrderID WHERE Orders.CustomerID = 'specific_customer_id'; ``` 3. ```sql SELECT ProductID, SUM(Quantity * UnitPrice) AS TotalSales FROM OrderDetails GROUP BY ProductID; ``` 4. ```sql SELECT DISTINCT Customers.* FROM Customers JOIN __________ ____ ______ __________ ______ ___ _______ __________.
__________ __________ ______ ______ _____ _____.
____ ____ ___ ___ ___ _____.
_______ ____ __________ ____ ________ _______.
________ _________ _________ ___ _________.
___ ____ ___ __________ ______ __________ _________.
_______ _____ ___ ______ ___ _____ _________ ________ ______.
______ _____ ______ _________ _______ __________ _____ ______ __________ _____.
________ ____ ____ _________ _______ ______ _________ ________.
_________ ______ ____ _______ _______ ________ ____.
_________ ___ _____ ____ ______ _____ ____ ______ __________ ____ ________ ______.
___ _____ _____ __________ ____ _____ ________.
___ ____ _____ ________ ______ _____ _______ __________ ____ ____ ____.
________ ______ ______ _________ _______ ____ ________ _____ ______ ___.
______ __________ ___ ___ ___ ____ ____ ______.
___ ____ ______ _______ _______ ____.
_______ _________ _______ ___ _____ _________ _______ ______ _________ ______.
___ _______ _________ ___ _______ ______.
______ __________ _______ ____ __________.
___ _____ ______ _______ ___ __________.
______ __________ _________ __________ ____.
________ ______ _____ ________ ___ ___ ____ _________ ________ _____.
__________ __________ _____ _____ ________ ______ __________ _______ _________ ______ _______ ______.
____ ______ ___ _______ ______ _____ ___.
________ ___ ______ _____ ______ _____ _____ ______ ________ ______.
____ ____ ____ ______ __________ ___ _________.
_______ ________ __________ __________ ________ _____ __________ _______ ____.
________ ____ __________ _______ ______.
_______ ______ ____ ______ ______ ___ _______ ___ ____.
_________ __________ ______ _________ ________ _________.
____ _____ ____ _________ _________ ________ ___ ____.
_______ ______ _______ ___ ____.
__________ ____ ___ ____ _________ _________ _________ _________ _______.
__________ ________ ___ ________ ______ ________ _______ _____ ________ _____ _________.
_______ ______ _______ _________ ____ _________ ___.
_____ __________ _________ ____ ______ _______ ________ _____.
___ _______ __________ ______ __________.
______ ___ __________ _____ ___ ____ _________ ____.
_________ _____ ___ ________ ________.
________ _________ __________ __________ _________.
_______ __________ ____ ____ ___ __________ ______ ___ ______ ________.
________ _________ ________ ______ ____ _________ _______ ___.
__________ _______ _____ _______ ______ ____ _______ _________ _______ _________ _______ _____.
____ _____ _________ ________ _________ _____ _________ ________ ______ ________.
______ _______ ____ _____ ______ _____ ____ _____ ____ _________ ____ ______.
_____ ______ ________ ____ _________ ________ ________.
_______ _____ ___ ______ _____ _____ ____.
_____ _______ _______ _________ _______ ________ ____ _______.
__________ _______ ______ _______ ___ ____ ____.
_____ _____ ________ ___ _________ ______ _____ ___ ____ _________.
_____ ___ ____ ____ ___ ____ ______ ____ ______ _______ _______ _______.
__________ ________ ______.
Get Full Answer on WhatsApp