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 Orders ON Customers.CustomerID = Orders.CustomerID; ``` 5. ```sql SELECT Orders.CustomerID, SUM(OrderDetails.Quantity) AS TotalQuantity FROM Orders JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID GROUP BY Orders.CustomerID; ``` 6. ____ ______ ________ ________ __________ ____ ________.
____ _________ _________ ___ ______ _________ _______ _____ _________ ____ _______.
___ ____ _______ _______ ___ _______ _____.
______ _______ _______ __________ __________ ________ ________.
______ ______ __________ __________ ____.
______ _______ _________ _____ __________.
_______ _______ _______ ______ _________ ____ ____ ________.
__________ __________ _________ __________ ___ ______ ________ ________ ________ ________.
__________ _________ ________ _________ ___ __________ _____ ____ ____ _______ ________.
___ _____ __________ __________ ___ _________ ______ __________.
_________ ______ ____ ______ ____ _____ ________.
________ _________ _____ __________ ________ ______ ___ _________ _____ _____.
______ ______ ______ ________ ________ _______.
___ ________ ____ _______ ______ ______ ________ ______ _____ ________.
_________ ______ ________ _______ ____ _______ ______ ______ _______ _____ ____.
_____ ______ _________ ________ _____ ___ ___.
________ ________ _________ _____ ____ ___ ______ _______ ________ ______.
______ _____ ____ ______ ________ _________ ___ ____ ________.
___ _______ ___ _____ ______ _______ ___.
______ ______ ________ ____ ______ ______ ___ _____ ____ ________ ______.
________ __________ ____ ______ __________.
___ ________ __________ __________ __________ ____.
____ ____ ________ ___ ________.
__________ ________ _____ __________ _______ ________ __________ ___.
__________ ______ ______ ______ _______.
______ ____ ___ _______ _________ _____.
________ _______ _____ ___ _______ ______ ______ ______ ________ ___ __________ ____.
_____ _____ _____ ____ ___ _______ __________ ______.
_____ ________ ______ _________ _____ _____ _______.
__________ __________ _________ ________ ___ ___ ______.
__________ _____ ________ _________ ______ _____ __________ __________ __________ ___.
______ _________ ________ __________ ________ __________ _________ _____ _______.
_________ ______ _____ __________ _____ _______ ____ _______.
_______ __________ ___ _______ _____ ________ _____.
____ _____ __________ _______ ___ _________ __________ ____ ______ ___ __________ __________.
___ ____ _______ ___ ____ ___ _________ ______ _______.
______ _________ __________ __________ ______ ____.
__________ _____ ___ _________ ___.
______ ________ _____ _______ _______ _________.
__________ _________ __________ ____ ______.
_________ ________ ________ ______ ________.
______ _________ _______ _______ ______ _________.
_______ ____ ______ _________ _________ ___ _________ _________ _______ ________ ______ ______.
_______ ____ _____ _____ ___ ____ __________ ___ ______ __________ ________.
____ _____ _____ ______ ________ _____ ____ ____ ______ _______.
_____ __________ _________ ____ _____ ____ _______ ________.
_____ __________ _____ _______ _____.
__________ __________ _________ ________ ____.
________ __________ ______ __________ ________ ________ ______.
___ _________.
Get Full Answer on WhatsApp