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
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.