CREATE TABLE table_47904 ("Round" FLOAT, "Pick" FLOAT, "Overall" FLOAT, "Name" TEXT, "Position" TEXT, "College" TEXT)

what is the pick when the overall is less than 297 and the college is alabama?
SELECT "Pick" FROM table_47904 WHERE "Overall" < '297' AND "College" = 'alabama'
SELECT "Pick" FROM "table_47904" WHERE "College" = 'alabama' AND "Overall" < '297'