How to write this SQL without duplicating the customer?
<p>I have a table that has customers listed every month with and active_indicator.  For each customer, I want to pull the active indicator for just two months (Dec 2014 and Dec 2015), but when I write the below code, I get a table where each customer is listed twice. I know I can do another step to roll up the table to the customer level using max, but is there anyway to do this in one simple SQL query?</p>

<pre><code>select distinct
     customer
    ,case when date='2015-12-01' then active_indicator else 0 end as Dec2015_active_ind
    ,case when date='2014-12-01' then active_indicator else 0 end as Dec2014_active_ind
from monthly_account_cust
where date in ('2015-12-01', '2014-12-01')
order by customer
</code></pre>