Table: convoy_hx_229_sc
Columns: date
name
flag
tonnage_grt
sunk_by

Question: What is the date for Zouave?
SQL: SELECT "date" FROM convoy_hx_229_sc WHERE "name" = 'zouave'

Question: What is the date for the name of Granville?
SQL: SELECT "date" FROM convoy_hx_229_sc WHERE "name" = 'granville'

Question: What is the name of the ship sunk by U-305 on 17 March 1943?
SQL: SELECT "name" FROM convoy_hx_229_sc WHERE "date" = '17 march 1943' AND "sunk_by" = 'u-305'