CREATE TABLE table_name_15 (pick__number VARCHAR2, name VARCHAR2)

Name the pick number for bill atessis
SELECT pick__number FROM table_name_15 WHERE name = "bill atessis"
SELECT "pick__number" FROM "table_name_15" WHERE "bill atessis" = "name"