CREATE TABLE table_6585 ("Designation  ( bore ) " CLOB, "Length Overall" CLOB, "Weight of Gun" CLOB, "Weight of Shot" CLOB, "Weight of Shell" CLOB, "Service Charge" CLOB, "Range  ( yards ) " CLOB)

what is the weight of a shot that is xx-inch?
SELECT "Weight of Shot" FROM table_6585 WHERE "Designation (bore)" = 'xx-inch'
SELECT "Weight of Shot" FROM "table_6585" WHERE "Designation (bore)" = 'xx-inch'