What player was drafted for the Detroit Pistons?
CREATE TABLE "team_players_drafted_in_the_nba" (
  "year" real,
  "round" real,
  "pick" real,
  "player" text,
  "nba_team" text
);
SELECT "player" FROM "team_players_drafted_in_the_nba" WHERE "nba_team"='detroit pistons';