Table: ucla_draft_95
Columns: year
round
pick
player
nba_team

Question: What was the average pick with Ed O'Bannon and a round smaller than 1?
SQL: SELECT AVG("pick") FROM ucla_draft_95 WHERE "player" = 'ed o''bannon' AND "round" < 1

Question: What player was drafted for the Detroit Pistons?
SQL: SELECT "player" FROM ucla_draft_95 WHERE "nba_team" = 'detroit pistons'