Is it live or studio before 1983?
CREATE TABLE "discography" (
  "year" real,
  "title" text,
  "role" text,
  "cast" text,
  "live_studio" text,
  "label" text
);
SELECT "live_studio" FROM "discography" WHERE "year"<1983;