Your question is Defect Counts by Component and Release. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Apex Systems QA engineers need a compact defect summary for each product release. Write a PostgreSQL query against Apex defect records to compare how many defects were reported for each component and release.
| Column | Type | Description |
|---|---|---|
| defect_idPK | INT | Unique defect identifier |
| component | VARCHAR(50) | Apex product component containing the defect |
| release_name | VARCHAR(20) | Apex product release associated with the defect |