Table: battle_stats_2
Columns: unit
commander
complement
killed
wounded
missing

Question: What were the wounded for complement of 46 off 656 men?
SQL: SELECT "wounded" FROM battle_stats_2 WHERE "complement" = '46 off 656 men'

Question: What was the missing for lieutenant general sir thomas picton?
SQL: SELECT "missing" FROM battle_stats_2 WHERE "commander" = 'Lieutenant General Sir Thomas Picton'

Question: Name the number of complement for 4th hanoverian brigade
SQL: SELECT COUNT("complement") FROM battle_stats_2 WHERE "unit" = '4th Hanoverian Brigade'

Question: Name the commander of 167 off 2348 men
SQL: SELECT "commander" FROM battle_stats_2 WHERE "complement" = '167 off 2348 men'