SELECT AFW_STATUS.stat_name, COUNT(ASDK_SERVICE_CALL.serv_id) AS "number_of_appointments"
FROM AFW_STATUS
  LEFT OUTER JOIN ASDK_SERVICE_CALL ON ASDK_SERVICE_CALL.serv_Status_id = AFW_STATUS.stat_id
  WHERE stat_app_category  = 4 and stat_project = 1
GROUP BY AFW_STATUS.stat_name;