SQLize | PHPize | SQLtest

SELECT l.Manager_Fullname, p.Period, COALESCE(COUNT(CASE WHEN l2.LeadStatus = 'квалифицирован' AND TO_CHAR(l2.StatusDate, 'Mon-YYYY') = p.Period THEN 1 END), 0) AS "Количество квалифицированных лидов", CASE WHEN COALESCE(COUNT(CASE WHEN l2.LeadStatus = 'квалифицирован' AND TO_CHAR(l2.StatusDate, 'Mon-YYYY') = p.Period THEN 1 END), 0) >= p.purpose THEN 'Да' ELSE 'Нет' END AS "План выполнен (да/нет)" FROM (SELECT DISTINCT Manager_Fullname FROM Lead) l CROSS JOIN Plan p LEFT JOIN Lead l2 ON l.Manager_Fullname = l2.Manager_Fullname GROUP BY l.Manager_Fullname, p.Period, p.purpose ORDER BY l.Manager_Fullname, p.Period;