**Course Title:** SQL Mastery: From Fundamentals to Advanced Techniques **Section Title:** Working with Multiple Tables: Joins and Unions **Topic:** Write queries using different types of joins to retrieve related data from multiple tables.(Lab topic) **Introduction:** In the previous topics, you learned about the different types of joins and how they can be used to combine data from multiple tables. In this lab topic, you will practice writing queries using various types of joins to retrieve related data from multiple tables. This will help you solidify your understanding of joins and prepare you for real-world scenarios where you need to work with complex data sets. **Lab Objective:** By the end of this lab, you will be able to: 1. Write queries using INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN to retrieve related data from multiple tables. 2. Identify the correct type of join to use based on the relationship between tables and the desired output. 3. Use joins to combine data from multiple tables and perform filtering, sorting, and aggregating operations. **Lab Exercises:** We will use the following tables for these exercises: * Customers table * Orders table * Products table These tables are part of the sample database provided by MySQL (https://dev.mysql.com/doc/sakila/en/). **Exercise 1: INNER JOIN** Retrieve the customer name, order date, and order total for all customers who have placed an order. ```sql SELECT c.customer_name, o.order_date, o.order_total FROM Customers AS c INNER JOIN Orders AS o ON c.customer_id = o.customer_id; ``` **Exercise 2: LEFT JOIN** Retrieve the customer name, order date, and order total for all customers, including those who have not placed an order. ```sql SELECT c.customer_name, o.order_date, o.order_total FROM Customers AS c LEFT JOIN Orders AS o ON c.customer_id = o.customer_id; ``` **Exercise 3: RIGHT JOIN** Retrieve the customer name, order date, and order total for all orders, including those where the customer is unknown. ```sql SELECT c.customer_name, o.order_date, o.order_total FROM Orders AS o RIGHT JOIN Customers AS c ON c.customer_id = o.customer_id; ``` **Exercise 4: FULL JOIN** Retrieve the customer name, order date, and order total for all customers and orders, including those where the customer is unknown or has not placed an order. ```sql SELECT c.customer_name, o.order_date, o.order_total FROM Customers AS c FULL JOIN Orders AS o ON c.customer_id = o.customer_id; ``` **Tips and Variations:** * Try adding additional conditions to the JOIN clause to filter the results. * Use the JOIN clause to combine multiple tables at once. * Experiment with different types of joins and compare the results. **Common Issues and Troubleshooting:** * Make sure to specify the correct table names and column names in the JOIN clause. * Check the data types of the columns you are joining to ensure they are compatible. * Verify that the relationships between tables are correctly established. **Conclusion:** In this lab topic, you practiced writing queries using different types of joins to retrieve related data from multiple tables. By completing these exercises, you have demonstrated your ability to use joins to combine data from multiple tables and perform filtering, sorting, and aggregating operations. You are now ready to move on to the next topic, where you will learn about inserting new records into a database using the INSERT INTO statement. **Leave a Comment or Ask for Help:** If you have any questions or need help with any of the exercises, please leave a comment below. I'll be happy to assist you. **Next Topic:** Inserting new records into a database (INSERT INTO) from Modifying Data: INSERT, UPDATE, DELETE. Please navigate to the next topic to continue your learning journey.