Review this SQL reporting query that should list every active product with its total units sold (including products that sold zero).