1SELECT 2 substr(w_warehouse_name, 1, 20), 3 sm_type, 4 cc_name, 5 sum(CASE WHEN (cs_ship_date_sk - cs_sold_date_sk <= 30) 6 THEN 1 7 ELSE 0 END) AS `30 days `, 8 sum(CASE WHEN (cs_ship_date_sk - cs_sold_date_sk > 30) AND 9 (cs_ship_date_sk - cs_sold_date_sk <= 60) 10 THEN 1 11 ELSE 0 END) AS `31 - 60 days `, 12 sum(CASE WHEN (cs_ship_date_sk - cs_sold_date_sk > 60) AND 13 (cs_ship_date_sk - cs_sold_date_sk <= 90) 14 THEN 1 15 ELSE 0 END) AS `61 - 90 days `, 16 sum(CASE WHEN (cs_ship_date_sk - cs_sold_date_sk > 90) AND 17 (cs_ship_date_sk - cs_sold_date_sk <= 120) 18 THEN 1 19 ELSE 0 END) AS `91 - 120 days `, 20 sum(CASE WHEN (cs_ship_date_sk - cs_sold_date_sk > 120) 21 THEN 1 22 ELSE 0 END) AS `>120 days ` 23FROM 24 catalog_sales, warehouse, ship_mode, call_center, date_dim 25WHERE 26 d_month_seq BETWEEN 1200 AND 1200 + 11 27 AND cs_ship_date_sk = d_date_sk 28 AND cs_warehouse_sk = w_warehouse_sk 29 AND cs_ship_mode_sk = sm_ship_mode_sk 30 AND cs_call_center_sk = cc_call_center_sk 31GROUP BY 32 substr(w_warehouse_name, 1, 20), sm_type, cc_name 33ORDER BY substr(w_warehouse_name, 1, 20), sm_type, cc_name 34LIMIT 100 35