-- 4. Display the total price before discount and after discount. (quantity * unit_price) AS total_price_before_discount, ((quantity * unit_price) - COALESCE(discount ...
Learn about the supported aggregate functions in TiDB. /docs/dev/functions-and-operators/aggregate-group-by-functions/ /docs/dev/reference/sql/functions-and-operators ...