select LOOKUP(fe.product_id,'dim_prod_manf_desc') as manf_desc,sum(fe.dist_total_revenue) as manf_dist_total_revenue, sales_year,sales_month,sales_quarter from fact_extrapolated_revenue fe where __time >= TIME_PARSE ('2019-01-31T000000.000Z') AND __time < TIME_PARSE ('2022-11-30T000000.000Z') AND fe.product_id IN (select dp.product_id from denorm_dim_product_unspsc dp where dp.taxonomy_id IN ('41151519','41151519','42311502','42311506','42311510','42311513','42311515','42311523','42311527','42311540','42311545','42311546','42311547','42311552','42312005','42312103','42312105','42312313','42312401')) GROUP BY LOOKUP(fe.product_id,'dim_prod_manf_desc'),sales_year,sales_month,sales_quarter order by sales_year,sales_month,sales_quarter