SELECT Name FROM musical WHERE Nominee  =  "Bob Fosse"
What are the names of musicals with nominee "Bob Fosse"?
PRAGMA foreign_keys = ON;

CREATE TABLE "musical" (
"Musical_ID" int,
"Name" text,
"Year" int,
"Award" text,
"Category" text,
"Nominee" text,
"Result" text,
PRIMARY KEY ("Musical_ID")
);

CREATE TABLE "actor" (
"Actor_ID" int,
"Name" text,
"Musical_ID" int,
"Character" text,
"Duration" text,
"age" int,
PRIMARY KEY ("Actor_ID"),
FOREIGN KEY ("Musical_ID") REFERENCES "actor"("Actor_ID")
);



INSERT INTO  "musical" VALUES (1,"The Phantom of the Opera","1986","Tony Award","Best Book of a Musical","Bob Fosse","Nominated");
INSERT INTO  "actor" VALUES (1,"Ray Meagher",1,"Alf Stewart","1988—","26");
