Write a query to identify parts with the highest turnover rate over the last six months at Hyundai MOBIS Alabama.
Assume the reporting period is January 1 through June 30, 2025. Calculate turnover as issued quantity divided by average recorded inventory, exclude parts without positive average inventory, and return all parts tied for the highest rate.
part_id, part_name, issued_quantity, average_inventory, turnover_rateturnover_rate descending, then part_id ascending| Column | Type | Description |
|---|---|---|
| part_idPK | VARCHAR(20) | Unique Hyundai MOBIS Alabama part identifier |
| part_name | VARCHAR(100) | Part description |
| part_category | VARCHAR(50) | Part category |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique inventory transaction identifier |
| part_id | VARCHAR(20) | Part affected by the transaction |
| transaction_date | DATE | Date the inventory movement occurred |
| transaction_type | VARCHAR(20) | Inventory movement type, such as ISSUE or RECEIPT |
| quantity | NUMERIC(12,2) | Quantity moved |
| Column | Type | Description |
|---|---|---|
| snapshot_idPK | INT | Unique inventory snapshot identifier |
| part_id | VARCHAR(20) | Part represented by the snapshot |
| snapshot_date | DATE | Date inventory was recorded |
| snapshot_quantity | NUMERIC(12,2) | On-hand quantity at the snapshot date |