Untitled
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