Table: submarine_data
Columns: date
name
nationality
tonnage_grt
fate

Question: How much tonnage was damaged?
SQL: SELECT SUM("tonnage_grt") FROM submarine_data WHERE "fate" = 'damaged'

Question: Which Nationality has a Fate of sunk, and a Name of alderamin?
SQL: SELECT "nationality" FROM submarine_data WHERE "fate" = 'sunk' AND "name" = 'alderamin'

Question: Which Tonnage (GRT) has a Nationality of united kingdom, and a Name of king gruffydd?
SQL: SELECT MIN("tonnage_grt") FROM submarine_data WHERE "nationality" = 'united kingdom' AND "name" = 'king gruffydd'