CREATE TABLE table_203_583 (id DECIMAL, "title" TEXT, "release" DECIMAL, "6th gen" TEXT, "handheld" TEXT, "note" TEXT)

which game was released before gunbird special edition / gunbird 1 & 2 ?
SELECT "title" FROM table_203_583 WHERE id = (SELECT id FROM table_203_583 WHERE "title" = 'gunbird special edition / gunbird 1&2') - 1
SELECT "title" FROM "table_203_583" WHERE "id" = (SELECT "id" FROM "table_203_583" WHERE "title" = 'gunbird special edition / gunbird 1&2') - 1