aboutsummaryrefslogblamecommitdiffstats
path: root/yql/essentials/tests/sql/suites/pg-tpcds/q96.sql
blob: d7b1e2032b4e072160f32487b020964d584caa3f (plain) (tree)

















                                                                          
--!syntax_pg
--TPC-DS Q96

-- start query 1 in stream 0 using template ../query_templates/query96.tpl
select  count(*) 
from plato.store_sales
    ,plato.household_demographics 
    ,plato.time_dim, plato.store
where ss_sold_time_sk = time_dim.t_time_sk   
    and ss_hdemo_sk = household_demographics.hd_demo_sk 
    and ss_store_sk = s_store_sk
    and time_dim.t_hour = 8
    and time_dim.t_minute >= 30
    and household_demographics.hd_dep_count = 5
    and store.s_store_name = 'ese'
order by count(*)
limit 100;

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