FULL (OUTER) JOIN Exercises 1. Retrieve a list of customers along with their associated orders. Include...

 

 

Transcribed Image Text:

FULL (OUTER) JOIN Exercises 1. Retrieve a list of customers along with their associated orders. Include customers who have not placed any orders. 2. List all products and their respective categories. Include products that do not belong to any category. 3. Get a list of orders along with their details and product names. Include orders with no associated order details. 4. Retrieve customers and their shipping addresses. Include customers who do not have a shipping address. 5. List all orders and the respective payment information. Include orders that have no payment records. 6. Get a list of customers and their phone numbers. Include customers who do not have phone numbers recorded. 7. Retrieve product reviews and the associated product information. Include products that have no reviews. 8. List products and their prices, sorted by category. Include categories with no products. 9. Retrieve customer addresses along with their city and postal code. Include customers with no recorded addresses. 10. List orders and their shipping addresses. Include orders with no shipping addresses. 11. Get a list of product reviews along with the names of the customers who wrote them. Include reviews with no associated customer information. 12. Retrieve product categories and the total quantity of products sold in each category. Include categories with no sales. 13. List products and their availability in stock. Include products with zero quantity in stock. 14. Get a list of customers who have placed orders. Include customers who have never placed an order. 15. Retrieve customer information and the total amount spent by each customer. Include customers who have not made any purchases. 16. List product names and their average customer ratings. Include products with no reviews. 17. Retrieve a list of customers who have not placed any orders. 18. List orders and their shipping addresses for a specific country. Include orders with no matching shipping addresses. 19. Get a list of products in a specific category and their prices. Include categories with no products. 20. Retrieve customers who have placed orders within a specific date range. Include customers who have not placed orders in that range. FULL (OUTER) JOIN Exercises 1. Retrieve a list of customers along with their associated orders. Include customers who have not placed any orders. 2. List all products and their respective categories. Include products that do not belong to any category. 3. Get a list of orders along with their details and product names. Include orders with no associated order details. 4. Retrieve customers and their shipping addresses. Include customers who do not have a shipping address. 5. List all orders and the respective payment information. Include orders that have no payment records. 6. Get a list of customers and their phone numbers. Include customers who do not have phone numbers recorded. 7. Retrieve product reviews and the associated product information. Include products that have no reviews. 8. List products and their prices, sorted by category. Include categories with no products. 9. Retrieve customer addresses along with their city and postal code. Include customers with no recorded addresses. 10. List orders and their shipping addresses. Include orders with no shipping addresses. 11. Get a list of product reviews along with the names of the customers who wrote them. Include reviews with no associated customer information. 12. Retrieve product categories and the total quantity of products sold in each category. Include categories with no sales. 13. List products and their availability in stock. Include products with zero quantity in stock. 14. Get a list of customers who have placed orders. Include customers who have never placed an order. 15. Retrieve customer information and the total amount spent by each customer. Include customers who have not made any purchases. 16. List product names and their average customer ratings. Include products with no reviews. 17. Retrieve a list of customers who have not placed any orders. 18. List orders and their shipping addresses for a specific country. Include orders with no matching shipping addresses. 19. Get a list of products in a specific category and their prices. Include categories with no products. 20. Retrieve customers who have placed orders within a specific date range. Include customers who have not placed orders in that range.

Answer rating: 100% (QA)

Here are the solutions to the FULL OUTER JOIN exercises 1 Retrieve a list of customers along with their associated orders Include customers who have not placed any orders sql SELECT ccustomerid ccusto... View the full answer