Vypis interpretů + jejich počet

SELECT *
FROM (
 
SELECT Contentgroup, Track, COUNT(Album) AS pocet
FROM `zahranicni`
UNION ALL
SELECT Contentgroup, Track, COUNT(Album) AS pocet
FROM `domaci`
)s  WHERE Track = '1'
GROUP BY Contentgroup 

SELECT contentgroup AS interpret,
       Count(album) AS pocet
FROM   (SELECT contentgroup,
               album
        FROM   `zahranicni`
        UNION ALL
        SELECT contentgroup,
               album
        FROM   `domaci`) s
GROUP  BY contentgroup