SQL err:  SELECT CC.APPLY_ID, CC.CIRCLE_ID, CC.DISPLAY_NAME, CC.ZONE, CC.SEAT_NO, CC.FAX,  COUNT(CCB.APPLY_ID) AS BOOK_AMOUNT  FROM CW_CIRCLE CC  LEFT JOIN CW_CIRCLE_BOOK CCB ON CC.APPLY_ID = CCB.APPLY_ID  WHERE CC.CW_ID = '20' AND STATUS = 'A'  GROUP BY CC.APPLY_ID  ORDER BY CC.ZONE, CC.SEAT_NO, LOWER(CC.DISPLAY_NAME)