ydb/yt/yql/tests/sql/suites/pg-tpcds/q52.sql

--!syntax_pg
--TPC-DS Q52

-- start query 1 in stream 0 using template ../query_templates/query52.tpl
select  dt.d_year
 	,item.i_brand_id brand_id
 	,item.i_brand brand
 	,sum(ss_ext_sales_price) ext_price
 from plato.date_dim dt
     ,plato.store_sales
     ,plato.item
 where dt.d_date_sk = store_sales.ss_sold_date_sk
    and store_sales.ss_item_sk = item.i_item_sk
    and item.i_manager_id = 1
    and dt.d_moy=12
    and dt.d_year=1998
 group by dt.d_year
 	,item.i_brand
 	,item.i_brand_id
 order by dt.d_year
 	,ext_price desc
 	,brand_id
limit 100 ;

-- end query 1 in stream 0 using template ../query_templates/query52.tpl