oracle错误-from keyword not found where expected

在该程序的时候遇到了这个错误，在网上查找时发现时申请了语法错误，所以出现这个错误的时候要检查下自己的sql语法。

from keyword not found where expected，sql语法错误，多了一些无用的符号或是字符影响到sql

 

举列：select e.juniorname,
       substr(e.furnacenumber,6,2) as fur,
       sum(e.one) one,
       round(sum(e.DLtime),3) DLtime,
       round(sum(e.LFtime),3) LFtime,
       round(sum(e.DLtime) / sum(e.one),3) as oneDLtime,
       round(sum(e.LFtime) / sum(e.one),3) as  oneLFtime,
       round(sum(e.dayendweight),3) dayendweight,
       round(sum(e.daydl),3) daydl,
       round(sum(e.daylf),3) daylf,
       round(sum(e.endweight),3) endweight,
       round(sum(e.dl),3) dl,
       round(sum(e.lf),3) lf,
       round(sum(e.dl)/sum(e.endweight),3)  end as yldanhao
  from aaaa e

   where  e.plantid='01'
group by e.juniorname,substr(e.furnacenumber,6,2);

此语多中多了end。