SQL
Retrieving Related Data with INNER JOIN
Understand how to combine rows from two or more tables based on a related column using the SQL INNER JOIN clause to retrieve comprehensive data.
SELECT u.id AS user_id, u.username, o.order_date, o.total_amount
FROM users u
INNER JOIN orders o ON u.id = o.user_id
WHERE o.total_amount > 100
ORDER BY o.order_date DESC;
How it works: This query uses an INNER JOIN to combine data from the 'users' and 'orders' tables. It links rows where the 'id' in the 'users' table matches the 'user_id' in the 'orders' table. The query then filters for orders with a 'total_amount' greater than 100 and orders the results by the order date, providing a consolidated view of related data.