select LOOKUP(fe.product_id,'dim_desc') as manf_desc ,fe.sales_month,fe.sales_year,fe.sales_quarter,sum(fe.dist_total_revenue) from fact_extrapolated_revenue fe where __time >= TIME_PARSE ('2020-12-31T000000.000Z') AND __time < TIME_PARSE ('2022-11-30T000000.000Z') and fe.product_id IN ( _*<1k product_ids>*_) GROUP BY LOOKUP(fe.product_id,'dim_desc') ,fe.sales_month,fe.sales_year,fe.sales_quarter