SELECT o.order_id, o.customer_id, c.company_name, o.order_date, o.shipped_date,
  ROUND( SUM( od.unit_price * od.quantity * (1 - od.discount) )::numeric, 2 ) AS total_order_value,
  COUNT(od.product_id) AS total_items, o.freight, o.ship_country
FROM orders o
INNER JOIN order_details od ON o.order_id = od.order_id
LEFT JOIN customers c ON o.customer_id = c.customer_id
GROUP BY o.order_id, o.customer_id, c.company_name, o.order_date, o.shipped_date, o.freight, o.ship_country
ORDER BY total_order_value DESC
LIMIT 10;