SELECT
  oi.order_id,
  p.name AS product,
  oi.qty,
  oi.unit_price,
  oi.discount,
  (oi.qty * oi.unit_price * (1 - oi.discount/100)) AS line_total
FROM order_items oi
JOIN products p ON oi.product_id = p.product_id
WHERE oi.order_id = 42
ORDER BY line_total DESC;