-- Show each order, customer name, salesperson name, and commision earned for the order
SELECT order.id, customer.name, salesperson.name, salesperson.commision * order.amount AS commision_earned
FROM order
INNER JOIN salesperson ON order.salesperson_id = salesperson.id
INNER JOIN customer ON order.customer_id = customer.id