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 |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime