【Oracle】年度積分+資料統計+SQL?

擷取前200條資料？？？

SELECT * FROM ( 
  SELECT a.id,a.name,a.tel,TO_CHAR(f.tj,'fm9999990.9999') tj 
  FROM LF_USER a 
  LEFT JOIN ( 
    SELECT yonghuid,SUM(jifen) tj  
    FROM LF_INFO b
    WHERE TO_CHAR(b.time,'YYYY-MM-DD HH24:MI:SS') 
    BETWEEN '2018-01-01 00:00:00' 
    AND '2019-01-01 00:00:00'
    GROUP BY uid
  ) f ON a.id = f.uid
  WHERE nvl(f.tj,0) > 0 
  ORDER BY nvl(f.tj,0) DESC ) 
  WHERE ROWNUM <= 200;