Posted by Yuanyuan, March 2, 2022, 11:03 a.m.
#168 Why my code can not return 0
SELECT date, count(stream_id)num_streams
FROM dates D
left join video_stream VS
on D.date = VS.stream_dt
where date <= '2021-08-07' and date >= '2021-08-01'
and customer_country = 'US'
group by date
FROM dates D
left join video_stream VS
on D.date = VS.stream_dt
where date <= '2021-08-07' and date >= '2021-08-01'
and customer_country = 'US'
group by date
