For each product in the database,
I want to show sum(order value)
Where Country = "Germany"
BUT I want to show all product rows, also those with no revenue in Germany. How can I accomplish this?
Product1 | 51264
Product2 |
Product3 | 1215
Product4 |
Product5 |