Explain the different types of SQL joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

Sample answer preview

SQL joins combine data from multiple tables based on a matching condition. INNER JOIN returns only rows that have a match in both tables. If I join users and orders on user_id, I only get users who have placed at least one order.