title: 00905.0000-"missing statement in oracle"
body: <pre><code>select fpl_experience,
    (trunc(months_between(sysdate,a.FPL_START_DATE))/12)/count(b.id_associate) as   fpl_experience_percentage 
  from tb_associate_fpl_details a 
  join tb_allocation_details b on a.id_associate= b.id_associate 
  (case fpl_experience 
    when fpl_experience_percentage &lt; 0.5 then 'Less than 6 months' 
    when fpl_experience_percentage&gt;0.5 and fpl_experience_percentage&lt;2 then 'Greater than 6M and less than 2Y')
     when fpl_experience_percentage&gt;2 and fpl_experience_percentage&lt;3 then 'between 2 and 3 years') ELSE 
    'greater than 3 years' end) as fpl_experience 
   group by a.fpl_start_date having b.asso_region='ON';
  </code></pre>