tpcds.query21.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of druid Show documentation
Show all versions of druid Show documentation
An JDBC datasource implementation.
select *
from (select w_warehouse_name
, i_item_id
, sum(case
when (cast(d_date as date) < cast('2000-03-11' as date))
then inv_quantity_on_hand
else 0 end) as inv_before
, sum(case
when (cast(d_date as date) >= cast('2000-03-11' as date))
then inv_quantity_on_hand
else 0 end) as inv_after
from inventory
, warehouse
, item
, date_dim
where i_current_price between 0.99 and 1.49
and i_item_sk = inv_item_sk
and inv_warehouse_sk = w_warehouse_sk
and inv_date_sk = d_date_sk
and d_date between date_sub(cast('2000-03-11' as date), 30)
and date_add(cast('2000-03-11' as date), 30)
group by w_warehouse_name, i_item_id) x
where (case
when inv_before > 0
then inv_after / inv_before
else null
end) between 2.0 / 3.0 and 3.0 / 2.0
order by w_warehouse_name
, i_item_id limit 100