Table: quatre_bras_order_of
Columns: unit
complement
killed
wounded
missing

Question: What was the number of Personal Staff Units Killed?
SQL: SELECT "killed" FROM quatre_bras_order_of WHERE "unit" = 'personal staff'

Question: What was the Complement of Artillery Corps Units that had 0 off 0 men Killed or Wounded?
SQL: SELECT "complement" FROM quatre_bras_order_of WHERE "killed" = '0 off 0 men' AND "wounded" = '0 off 0 men' AND "unit" = 'artillery corps'

Question: How many were Wounded while in a Unit with a Complement of 83 off 9 Men?
SQL: SELECT "wounded" FROM quatre_bras_order_of WHERE "complement" = '83 off 9 men'

Question: How many of the Royal Waggon Train Unit were Missing while having a Killed of 0 off 0 men and a Wounded of 0 off 0 men?
SQL: SELECT "missing" FROM quatre_bras_order_of WHERE "killed" = '0 off 0 men' AND "wounded" = '0 off 0 men' AND "unit" = 'royal waggon train'

Question: How many were Wounded in the Artillery Corps unit while having 0 off 0 men Killed?
SQL: SELECT "wounded" FROM quatre_bras_order_of WHERE "killed" = '0 off 0 men' AND "unit" = 'artillery corps'