Table: convoys_ons
Columns: date
number
type
captain
casualties

Question: What is the average number of casualties for the convoy with a number of U-844?
SQL: SELECT AVG("casualties") FROM convoys_ons WHERE "number" = 'u-844'