NwX6NDcP

1DROP TABLE IF EXISTS ws_mkt_dst.tb_b2b_cjs_eng_days_btw_prod CASCADE;
2CREATE TABLE ws_mkt_dst.tb_b2b_cjs_eng_days_btw_prod   AS
3 SELECT
4           analytic_acct_id,
5         CASE WHEN vmware IS NOT NULL THEN vmware::date - (LEAD(vmware,1) OVER (PARTITION BY analytic_acct_id ORDER BY vmware DESC))::date END  as days_btw_eng_vmware,
6         CASE WHEN desktop IS NOT NULL THEN desktop::date - (LEAD(desktop,1) OVER (PARTITION BY analytic_acct_id ORDER BY desktop DESC))::date END  as days_btw_eng_desktop,
7         CASE WHEN storage IS NOT NULL THEN storage::date - (LEAD(storage,1) OVER (PARTITION BY analytic_acct_id ORDER BY storage DESC))::date END  as days_btw_eng_storage,
8         CASE WHEN server IS NOT NULL THEN server::date - (LEAD(server,1) OVER (PARTITION BY analytic_acct_id ORDER BY server DESC))::date END  as days_btw_eng_server,
9         CASE WHEN hci IS NOT NULL THEN hci::date - (LEAD(hci,1) OVER (PARTITION BY analytic_acct_id ORDER BY hci DESC))::date END  as days_btw_eng_hci,
10         CASE WHEN dncp IS NOT NULL THEN dncp::date - (LEAD(dncp,1) OVER (PARTITION BY analytic_acct_id ORDER BY dncp DESC))::date END  as days_btw_eng_dncp,
11         CASE WHEN all_in_one IS NOT NULL THEN all_in_one::date - (LEAD(all_in_one,1) OVER (PARTITION BY analytic_acct_id ORDER BY all_in_one DESC))::date END  as days_btw_eng_all_in_one,
12         CASE WHEN workstation IS NOT NULL THEN workstation::date - (LEAD(workstation,1) OVER (PARTITION BY analytic_acct_id ORDER BY workstation DESC))::date END  as days_btw_eng_workstation,
13         CASE WHEN notebook IS NOT NULL THEN notebook::date - (LEAD(notebook,1) OVER (PARTITION BY analytic_acct_id ORDER BY notebook DESC))::date END  as days_btw_eng_notebook,
14         CASE WHEN networking IS NOT NULL THEN networking::date - (LEAD(networking,1) OVER (PARTITION BY analytic_acct_id ORDER BY networking DESC))::date END  as days_btw_eng_networking,
15         CASE WHEN cs IS NOT NULL THEN cs::date - (LEAD(cs,1) OVER (PARTITION BY analytic_acct_id ORDER BY cs DESC))::date END  as days_btw_eng_cs,
16         CASE WHEN iss IS NOT NULL THEN iss::date - (LEAD(iss,1) OVER (PARTITION BY analytic_acct_id ORDER BY iss DESC))::date END  as days_btw_eng_iss
17    FROM ws_mkt_dst.tb_b2b_cjs_eng_days_btw_prod_help e
18    DISTRIBUTED BY (analytic_acct_id);
19GRANT ALL ON ws_mkt_dst.tb_b2b_cjs_eng_days_btw_prod  TO ws_grp_mkt_dst_writers;
20ALTER TABLE ws_mkt_dst.tb_b2b_cjs_eng_days_btw_prod  OWNER TO  ws_grp_mkt_dst_writers;