+-----------------+-----------------+----------+-----------+
| manufacturer_id | name            | mfg_code | prodcount |
+-----------------+-----------------+----------+-----------+
| 41              | MICKEY THOMPSON | MKY      | 761       |
| 73              | NA              | NA       | 92        |
| 76              | SOLAR           | SLR      | 23        |
+-----------------+-----------------+----------+-----------+