The total that doubled after adding a join

• A

  The join altered the order of the rows, so the aggregate ended up reading them differently

• B

  An order with several tags now appears several times, so its total is counted once per tag

• C

  The join introduced NULL totals that are being treated as zero

• D

  The second table has its own totals that are being included