SELECT s.settlement_name, AVG(o.total_price) AS average_order_value FROM settlements s INNER JOIN orders o ON s.settlement_id = o.settlement_id GROUP BY s.settlement_name;