mediumIntel · aggregationPro
Defect rate per production line
Quality control wants the defect rate for each production line: the percentage of units on that line marked defective.
Return line_id and defect_rate_pct, rounded to 2 decimal places.
Schema
▸production_units
| id | INT |
| line_id | TEXT |
| is_defective | BOOLEAN |
Pro
The example input, expected output, and walkthrough for this question unlock with a Pro plan.
Pro
This is a Pro question
Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.