I'm returning total sales for a period of time for each country. Sometimes a country will not appear in the results because they haven't had any orders during that time period. For these countries with no sales, I would like to include in the results the countries abbreviated name and sales total with a value of '0'. For example, NL and IS should also be included in the results with Sales\_Total both with a value of '0'. How would I include those dummies rows in the results when the country hasn't had any sales for the period?

```
**QUERY:**

SELECT 
    Country,
    SUM(TOTAL) AS Sales_Total   
FROM Orders
WHERE OrderDate BETWEEN '2014-01-01' AND '2014-12-31'
GROUP BY Country

**RESULTS**

Country   Total_Sales
AU        7646
CA        13773
KR        13976
NZ        1831
US        69421

**Required Results:**

Country   Total_Sales
AU        7646
CA        13773
KR        13976
NZ        1831
US        69421
NL        0
IS        0

```