CREATE TABLE table_203_710 (id DECIMAL, "genre" TEXT, "year" DECIMAL, "title" TEXT, "episode" TEXT, "role" TEXT, "notes" TEXT)

the year previos to normandy : the great crusade
SELECT "year" FROM table_203_710 WHERE id = (SELECT id FROM table_203_710 WHERE "title" = 'normandy: the great crusade') - 1
SELECT "year" FROM "table_203_710" WHERE "id" = (SELECT "id" FROM "table_203_710" WHERE "title" = 'normandy: the great crusade') - 1