CREATE TABLE table_204_451 (id DECIMAL, "component" TEXT, "model 01" TEXT, "model 01+" TEXT, "model 02" TEXT, "model e2" TEXT, "model 2+  ( pre-production ) " TEXT, "model 03  ( china copy ) " TEXT)

what is the component before usb ?
SELECT "component" FROM table_204_451 WHERE id = (SELECT id FROM table_204_451 WHERE "component" = 'usb') - 1
SELECT "component" FROM "table_204_451" WHERE "id" = (SELECT "id" FROM "table_204_451" WHERE "component" = 'usb') - 1