human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Pick #, Brand (to), Employee (Real name), Role, Brand (from)
###Question: What role did Pick # 10 have?
gpt
SELECT Role FROM table WHERE Pick # = 10