NTILE(5) OVER (ORDER BY recency_days ASC) AS recency_score, NTILE(5) OVER (ORDER BY frequency DESC) AS frequency_score, NTILE(5) OVER (ORDER BY monetary_value DESC) AS monetary_score ...
avg( cast(cs_quantity as decimal(12,6))) agg1, avg( cast(cs_list_price as decimal(12,6))) agg2, avg( cast(cs_coupon_amt as decimal(12,6))) agg3, avg( cast(cs_sales ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results