SELECT Districts.name, COUNT(DISTINCT Interview_Schedule.app_id) AS [APP] , (COUNT(Interview_Schedule.value)FROM Districts INNER JOIN
Interview_Schedule ON Districts.id = Interview_Schedule.interview_district WHERE Interview_Schedule.value=1)AS [ONES],
(COUNT(Interview_Schedule.value)FROM Districts INNER JOIN
Interview_Schedule ON Districts.id = Interview_Schedule.interview_district WHERE Interview_Schedule.value=0)AS [ZEROS],
(COUNT(Interview_Schedule.value)FROM Districts INNER JOIN
Interview_Schedule ON Districts.id = Interview_Schedule.interview_district WHERE Interview_Schedule.value IS NULL)AS [NULLS]
FROM Districts INNER JOIN
Interview_Schedule ON Districts.id = Interview_Schedule.interview_district
WHERE (Interview_Schedule.work_flow_id = 2)
GROUP BY Districts.name