Объединение запросов в PosgreSQL

SELECT nom, COUNT (makol_id) AS M FROM muallim
LEFT JOIN makol ON makol.makol_id = muallim.user_id
GROUP BY nom

SELECT nom, COUNT (kitob_id) AS K FROM muallim
LEFT JOIN kitob ON kitob.kitob_id = muallim.user_id
GROUP BY nom

SELECT 
nom, 
(SELECT COUNT (makol_id) AS M FROM makol WHERE makol.makol_id = muallim.user_id) AS M,
(SELECT COUNT (kitob_id) AS K FROM kitob  WHERE kitob.kitob_id = muallim.user_id) AS K,
FROM muallim

SELECT
    nom,
    COUNT (makol_id) AS M,
    COUNT (kitob_id) AS K
FROM
    muallim
        LEFT JOIN
    makol
        ON makol.makol_id = muallim.user_id
        LEFT JOIN
    kitob
        ON kitob.kitob_id = muallim.user_id
GROUP BY
    nom

WHERE facultet='Математика' AND solkit  BETWEEN 2017 AND 2023

SELECT 
nom, 
(SELECT COUNT (makol_id) AS M FROM makol WHERE makol.makol_id = muallim.user_id) AS M,
(SELECT COUNT (kitob_id) AS K FROM kitob  WHERE kitob.kitob_id = muallim.user_id ) AS K
FROM muallim
WHERE facultet='Математика' AND solkit= (BETWEEN 2017 AND 2023)

SELECT 
nom, 
(SELECT COUNT (makol_id) AS M FROM makol WHERE makol.makol_id = muallim.user_id) AS M,
(SELECT COUNT (kitob_id) AS K FROM kitob  WHERE kitob.kitob_id = muallim.user_id AND facultet='Математика' AND solkit BETWEEN 2017 AND 2023 ) AS K
FROM muallim

SELECT
nom,
(SELECT COUNT (makol_id) AS M FROM makol WHERE makol.makol_id = muallim.user_id AND faculta='Биология'),
(SELECT COUNT (kitob_id) AS K FROM kitob  WHERE kitob.kitob_id = muallim.user_id AND faculta='Биология')
FROM muallim

SELECT
nom,
(SELECT COUNT (makol_id) AS M FROM makol WHERE makol.makol_id = muallim.user_id ),
(SELECT COUNT (kitob_id) AS K FROM kitob  WHERE kitob.kitob_id = muallim.user_id)
FROM muallim
WHERE  faculta='Работает'