Table: convoy_hx_229_sc
Columns: date
name
flag
tonnage_grt
sunk_by

Question: What is the flag for Terkoeli?
SQL: SELECT "flag" FROM convoy_hx_229_sc WHERE "name" = 'terkoeli'

Question: What is the date for the flag of Norway?
SQL: SELECT "date" FROM convoy_hx_229_sc WHERE "flag" = 'norway'

Question: Who sunk the ship with the flag of Norway?
SQL: SELECT "sunk_by" FROM convoy_hx_229_sc WHERE "flag" = 'norway'