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
| id | INT |
| product | TEXT |
| unit_cost | NUMERIC |
| unit_price | NUMERIC |
Example input
▸products