Table: battle_stats
Columns: unit
commander
complement
killed
wounded
missing

Question: Which units are commanded by Lieutenant Colonel Francis Hepburn?
SQL: SELECT "unit" FROM battle_stats WHERE "commander" = 'Lieutenant Colonel Francis Hepburn'

Question: What are the complements when the commander is Major William Lloyd?
SQL: SELECT "complement" FROM battle_stats WHERE "commander" = 'Major William Lloyd'

Question: How many were wounded when the complement was 173 off 2059 men?
SQL: SELECT "wounded" FROM battle_stats WHERE "complement" = '173 off 2059 men'

Question: How many where killed under Major-General Jean Victor de Constant Rebecque's command?
SQL: SELECT "killed" FROM battle_stats WHERE "commander" = 'Major-General Jean Victor de Constant Rebecque'

Question: Who were the commanders when 8 off 0 men were wounded?
SQL: SELECT "commander" FROM battle_stats WHERE "wounded" = '8 off 0 men'