Что у меня не так с SQL запросом?

Вообще не могу понять как связать подзапросы с JOIN

ERROR:  syntax error at or near "GROUP"
LINE 35: GROUP BY

SELECT 
    authors.id, 
    CONCAT(authors.lastname, ' ', authors.firstname, ' ', authors.middlename) AS name,
    COUNT(ja) + COUNT(jaa) AS journal,
    COUNT(spa) + COUNT(nspa) AS publication
FROM "authors"
    INNER JOIN (SELECT table1.id
        INNER FROM "table1"
        INNER JOIN table2 aal 
            ON aal.author_id = authors.id
        WHERE table1.id = aal.publication_id 
            AND table1.is_hidden_en = false
            AND aal.itemtypes= 1) ja
    INNER JOIN (SELECT table3.id
        FROM "table3"
        INNER JOIN table2 aal 
            ON aal.author_id = authors.id
        WHERE table3.id = aal.publication_id 
            AND table3.is_hidden_en = false
            AND aal.itemtypes= 4) jaa
    INNER JOIN (SELECT table4.id
        FROM "table4"
        INNER JOIN table2 aal 
            ON aal.author_id = authors.id
        WHERE table4.id = aal.publication_id 
            AND table4.is_hidden_en = false
            AND aal.itemtypes= 2) spa
    INNER JOIN (SELECT table5.id
        FROM "table5"
        INNER JOIN table2 aal 
            ON aal.author_id = authors.id
        WHERE table5.id = aal.publication_id 
            AND table5.is_hidden_en = false
            AND aal.itemtypes= 3) nspa
GROUP BY 
    authors.id
ORDER BY 
    ja + jaa + spa + nspa
    DESC
LIMIT 5;