CREATE TABLE table_47768 ("Name" CLOB, "Location" CLOB, "Elevation + Height" CLOB, "Delivery" CLOB, "Purpose" CLOB, "Yield" CLOB)

What is the purpose of Long Shot?
SELECT "Purpose" FROM table_47768 WHERE "Name" = 'long shot'
SELECT "Purpose" FROM "table_47768" WHERE "Name" = 'long shot'