mahir_data
easyPanasonic · math

Profit margin per product

For each product, compute the profit margin as a percentage of the selling price:

(unit_price − unit_cost) / unit_price × 100

Return product and margin_pct, rounded to 1 decimal place.

Schema

products
idINT
productTEXT
unit_costNUMERIC
unit_priceNUMERIC

Example input

products