sql - 每个属性的表“f”缺少 FROM 子句条目

Question

我正在尝试运行此代码，但这会返回上述错误。我正在尝试加入同一个表的两个子查询。

select 
      (lead(f.topup_date)  over  (partition by(f.id_user)  order by f.topup_date desc))  as  datepre,
       f.topup_date::timestamp  -  lead(f.topup_date::timestamp) 
       over (partition by(f.id_user) order by  f.topup_date desc),
       case when  f.topup_value>=20  then  'Y' else 'N' end,
       LEAD(temp.dt)  OVER( PARTITION BY  temp.id_user 
       ORDER BY temp.topup_date DESC ROWS BETWEEN 0 PRECEDING AND UNBOUNDED 
       FOLLOWING),
      temp.division
FROM
(
          SELECT  (max(CASE WHEN f.topup_value >= 20 THEN f.topup_date  END) 
          OVER(PARTITION BY f.id_user ORDER BY f.topup_date DESC ROWS BETWEEN 
          0 PRECEDING AND UNBOUNDED FOLLOWING )) AS dt
          , f.topup_value::float / t1.topup_value::float AS division
          , t1.id_user
          , f.topup_date
        FROM topups t1
        JOIN topups as f USING (seq) 
) temp          

标签： sqlpostgresqlwindow-functions