select * from (
select locale, current_date::date as d, count(distinct movie_id) from movies_new sn group by locale
union all
select locale, (current_date - interval '1 days')::date as d, count(distinct movie_id) from movies_new sn where created_at < current_date - interval '1 days' group by locale
union all
select locale, (current_date - interval '2 days')::date as d, count(distinct movie_id) from movies_new sn where created_at < current_date - interval '2 days' group by locale
union all
select locale, (current_date - interval '3 days')::date as d, count(distinct movie_id) from movies_new sn where created_at < current_date - interval '3 days' group by locale
union all
select locale, (current_date - interval '4 days')::date as d, count(distinct movie_id) from movies_new sn where created_at < current_date - interval '4 days' group by locale
union all
select locale, (current_date - interval '5 days')::date as d, count(distinct movie_id) from movies_new sn where created_at < current_date - interval '5 days' group by locale
union all
select locale, (current_date - interval '6 days')::date as d, count(distinct movie_id) from movies_new sn where created_at < current_date - interval '6 days' group by locale
) a order by d desc, locale asc