Top Server Components by Failures

Supermicro's operations team wants to identify the best-performing server components for each month. Write a PostgreSQL query that calculates monthly failure rates while accounting for shipment volume, then returns the top three components per month.

Requirements

1. Aggregate shipped units and failed units by component and calendar month.
2. Include components with shipments but no recorded failures, treating their failed-unit count as zero.
3. Exclude months where total shipment volume is zero and rank components by the lowest failure rate, then highest shipment volume.
4. Return the top three ranked components for January and February 2025.

Output details

• Return columns in this order: month, component_name, shipment_volume, failed_units, failure_rate_pct, performance_rank.
• Format month as YYYY-MM.
• Calculate failure_rate_pct as a percentage rounded to two decimal places.
• Break equal failure-rate and shipment-volume ties by component_name ascending.
• Include shipment and failure dates from 2025-01-01 inclusive through 2025-03-01 exclusive.
• Sort results by month ascending, then performance_rank ascending.