Untitled

 avatar
unknown
plain_text
5 months ago
754 B
2
Indexable
with weeks as (
    select strftime('%Y', date_of_view) as year_number, 
           strftime('%W', date_of_view) AS week_number, 
           video_id, 
           youtube_views 
    from youtube_views
), 
x as (
    select distinct content_format, video_id 
    from video_info 
    order by content_format, video_id
) 
select 
    x.content_format, 
    w.year_number, 
    w.week_number, 
    sum(youtube_views) as content_format_views 
from x 
inner join weeks as w using (video_id) 
inner join (select distinct year_number, week_number from weeks order by year_number desc, week_number desc limit 2) as dw using(year_number, week_number)
group by x.content_format, w.year_number, w.week_number
order by x.content_format, w.year_number, w.week_number;
Editor is loading...
Leave a Comment