user: Question: what is the weight of a shot that is XX-inch?
Columns: ['Designation (bore)', 'Length Overall', 'Weight of Gun', 'Weight of Shot', 'Weight of Shell', 'Service Charge', 'Range (yards)']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['32-pdr. of 27 cwt. (6.2inch)', '93.72 in.', '3,200lb.', '32lb.', '26.5lb.', '4lb.', '1637 @ 6° elev.']
SQL:

assistant: SELECT "Weight of Shot" FROM "Table" WHERE "Designation (bore)" = 'XX-inch';