sql multi select example

SELECT a.CAL_YMD,c.ORG_NM,
       (SELECT COUNT (*) FROM HRM_DINNER_APPL d WHERE d.CAL_YMD = a.CAL_YMD AND d.CHECK_YN = 'Y' ) AS cnt
FROM HRM_DINNER_APPL a , HRM_EMP_V c
WHERE c.EMP_ID = a.EMP_ID
  AND a.CAL_YMD >= ?
  AND a.CAL_YMD <= ?
  AND c.ORG_ID LIKE ?
GROUP BY a.CAL_YMD,c.ORG_NM     
ORDER BY a.CAL_YMD,c.ORG_NM