SQL practice: Joining Three or More Tables

Show order_id, customer_name and branch_name for every order. (Two lookups from orders.)

Add employee_name to 14-1, so you have all four in one row.

Show every order line with the customer name, product name, and line total (quantity × unit_price).

Do 14-3 again, but only for Delivered orders.

Show every stock transfer with the product name and the from branch name.

Show the total revenue per branch region — you'll need to travel order_items → orders → branches.

Count the orders per customer, showing the customer's name and city. Should you use COUNT(*) or COUNT(DISTINCT ...)? Justify it.

How many rows does orders joined to order_items return, and why isn't it 41?

Trace the path on the map: which tables must you join to get from products to branches?

For each branch, show how many orders it took and the total quantity sold. The orders number is too high. Fix it.