select
	drmn.did,
	sum(case when date = date_sub(current_date, interval 1 day) then drmn.minutes else 0 end) minutes_yesterday,
	sum(case when date = date_sub(current_date, interval 7 day) then drmn.minutes else 0 end) minutes_last_week
from zenoreport.daily_radio_minutes_new drmn
where date = date_sub(current_date, interval 1 day)
	or date = date_sub(current_date, interval 7 day)
group by drmn.did