SELECT
    dbo.z_producenci.producent
,   dbo.z_proformy.data_proformy
,   COUNT(dbo.z_statusy.id_status) AS ile_wierszy_wszystkie
,   COUNT(CASE WHEN dbo.z_zamowienia.id_status = 16 THEN 1 ELSE NULL END) AS ile_wierszy_16
,   COUNT(CASE WHEN dbo.z_zamowienia.id_status =  8 THEN 1 ELSE NULL END) AS ile_wierszy_8
FROM dbo.z_producenci
JOIN dbo.z_proformy
  ON dbo.z_producenci.id_producent = dbo.z_proformy.id_producent
JOIN dbo.z_zamowienia
  ON dbo.z_producenci.id_producent = dbo.z_zamowienia.id_producent
 AND dbo.z_proformy.id_proformy = dbo.z_zamowienia.id_proformy
GROUP BY
    dbo.z_producenci.producent
,   dbo.z_proformy.data_proformy