CREATE TABLE table_name_51 (weight_of_shot VARCHAR2, designation__bore_ VARCHAR2)

what is the weight of a shot that is xx-inch?
SELECT weight_of_shot FROM table_name_51 WHERE designation__bore_ = "xx-inch"
SELECT "weight_of_shot" FROM "table_name_51" WHERE "designation__bore_" = "xx-inch"