title: Trying to fix this -- found ")" (at char 81) expecting a keyword -- error
body: <p>I'm trying to run this but I keep getting, error                                                                                    </p>
  
  <blockquote>
  <pre><code>^ found ")" (at char 81) expecting a keyword
  </code></pre>
  </blockquote>
  
  <p>The char 81 is in the 2nd SELECT portion AS</p>
  
  <p>There is clearly an keyword AS in there</p>
  
  <pre><code>SELECT full_name, clm_id, 
  CASE WHEN OPEN_DAYS BETWEEN 0 AND 30 THEN 1 ELSE 0 END) AS '0TO30' 
       WHEN OPEN_DAYS BETWEEN 31 AND 60 THEN 1 ELSE 0 END) AS '31TO60' 
       WHEN OPEN_DAYS BETWEEN 0 AND 30 THEN 1 ELSE 0 END) AS '61TO90' 
       WHEN OPEN_DAYS BETWEEN 0 AND 30 THEN 1 ELSE 0 END) AS '91TO120' 
       WHEN OPEN_DAYS &gt;= 120 THEN 1 ELSE 0 END) AS 'GreaterThan120' 
       ELSE 'OTHERS' 
  END AS DAYS_RANGE, 
  COUNT(*) as NUMBER_OF_DAYS 
  FROM 
      (
      SELECT DATE(CURRENT_DATE) - DATE(RCVD_DT) AS Open_Days 
          FROM clm_claim_rds_vw 
          WHERE CLM_ID like 'CC%' 
          AND EXTNL_STAT_CD = 'SUBMITTED'
      ) A 
  
  LEFT JOIN mt_employee_current_vw  
      ON clm_claim_rds_vw.examined_by_empl_id = mt_employee_current_vw.employee_number 
  
  GROUP BY full_name
  </code></pre>