postgresql-9.3 - 错误：PostgreSQL 中“from”处或附近的语法错误

Question

我正在做一些RFM模型并被困在这里：

select "customer_id" as a, rfm_recency*100 + rfm_frequency*10 as rfm_combined
from
(select a, 
       ntile(4) over (order by recency) as rfm_recency,
       ntile(4) over (order by frequency) as rfm_frequency) x
from
(select a,
       max("purchase_date") as recency,
       count(*) as frequency
from "customer") y

“来自”处或附近的语法错误

标签： postgresql-9.3

Answer 1

我找到了答案：

select "customer_id" as a, rfm_recency*100 + rfm_frequency*10 as rfm_combined
from
(select a, 
       ntile(4) over (order by recency) as rfm_recency,
       ntile(4) over (order by frequency) as rfm_frequency
from
(select a,
       max("purchase_date") as recency,
       count(*) as frequency
from "customer") x)y