SELECT T2.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID WHERE T1.Manager  =  "Sam Allardyce"
Show names of players from the club with manager "Sam Allardyce".
CREATE TABLE "club" (
"Club_ID" int,
"Name" text,
"Manager" text,
"Captain" text,
"Manufacturer" text,
"Sponsor" text,
PRIMARY KEY ("Club_ID")
);
CREATE TABLE "player" (
"Player_ID" real,
"Name" text,
"Country" text,
"Earnings" real,
"Events_number" int,
"Wins_count" int,
"Club_ID" int,
PRIMARY KEY ("Player_ID"),
FOREIGN KEY ("Club_ID") REFERENCES "club"("Club_ID")
);
INSERT INTO  "club" VALUES (1,"Arsenal","Arsène Wenger","Cesc Fàbregas","Nike","Fly Emirates");
INSERT INTO  "player" VALUES ("1","Nick Price","Zimbabwe","1478557","18","4",1);