text: --  Licensed to the Apache Software Foundation (ASF) under one or more
  --  contributor license agreements. See the NOTICE file distributed with
  --  this work for additional information regarding copyright ownership.
  --  The ASF licenses this file to You under the Apache License, Version 2.0
  --  (the "License"); you may not use this file except in compliance with
  --  the License. You may obtain a copy of the License at
  --
  --    http://www.apache.org/licenses/LICENSE-2.0
  --
  --  Unless required by applicable law or agreed to in writing, software
  --  distributed under the License is distributed on an "AS IS" BASIS,
  --  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  --  See the License for the specific language governing permissions and
  --  limitations under the License.
  
  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 (cast('2000-03-11' AS DATE) - INTERVAL 30 days)
         AND (cast('2000-03-11' AS DATE) + INTERVAL 30 days)
         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
  