Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- date_sub(current_date, interval 1 day) yesterday,
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
