Table: draft_picks_4
Columns: rd
pick
player
team_league
reg_gp
pl_gp

Question: What is the mean road number when Moe Lemay is the player?
SQL: SELECT AVG("rd") FROM draft_picks_4 WHERE "player" = 'moe lemay'

Question: What is the sum number of Pl GP when the pick number is 178 and the road number is bigger than 9?
SQL: SELECT COUNT("pl_gp") FROM draft_picks_4 WHERE "pick" = 178 AND "rd" > 9

Question: What is the total number of Pl GP when the pick number is 199 and the Reg GP is bigger than 0?
SQL: SELECT SUM("pl_gp") FROM draft_picks_4 WHERE "pick" = 199 AND "reg_gp" > 0