Table: draft_2008
Columns: pick
brand_to
employee_real_name
role
brand_from

Question: What role did Pick # 10 have?
SQL: SELECT "role" FROM draft_2008 WHERE "pick" = 10

Question: What is the real name of the male wrestler from Raw with a pick # smaller than 6?
SQL: SELECT "employee_real_name" FROM draft_2008 WHERE "pick" < 6 AND "brand_from" = 'raw' AND "role" = 'male wrestler'

Question: Pick # 3 works for which brand?
SQL: SELECT "brand_from" FROM draft_2008 WHERE "pick" = 3

Question: What is the real name of the Pick # that is greater than 9?
SQL: SELECT "employee_real_name" FROM draft_2008 WHERE "pick" > 9