SQL practice: INNER JOIN

Show order_id with the branch_name for each order.

Show each employee_name next to their branch_name.

Show product_name and quantity for every row in order_items.

Show order_id, order_date and customer_name, only for Delivered orders.

Show every employee earning over 50000, with their branch name.

Show each order line with the product name and the line total (quantity × unit_price).

Show customer_name and branch_name for every order.

Show all stock transfers with the product name.

List the employees working in the 'North' region, with their branch name.

Count how many rows products joined to order_items returns. Why isn't it 14?

Show each employee with their branch's city and region.

This query fails because 'customer_id' is ambiguous (it exists in both tables). Fix it.