Table schema:
CREATE TABLE table_name_51 (weight_of_shot VARCHAR, designation__bore_ VARCHAR)

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