SQLize Online / PHPize Online  /  SQLtest Online

create table sales (monthid int, rtn int, sales_rub float); create table plans (monthid int, rtn int, plan_rub float); select right(s.monthid::text,2) mnth , s.rtn , s.sales_rub , coalesce(p.plan_rub,0) , date_part('quarter', make_date(left(s.monthid::text,4)::int, right(s.monthid::text, 2)::int, 1)) quarter , avg(s.sales_rub) over (partition by date_part('quarter', make_date(left(s.monthid::text,4)::int, right(s.monthid::text, 2)::int, 1))) from sales s left join plans p on p.rtn=s.rtn and p.monthid = s.monthid where left(s.monthid::text,4) = '2021' -- group by right(s.monthid::text,2), s.rtn -- , date_part('quarter', make_date(left(s.monthid::text,4)::int, right(s.monthid::text, 2)::int, 1))