Ошибка SQL запроса, как исправить
SELECT AVG(SELECT Count(track.name)
FROM album, track
WHERE (((track.name)="Rock") AND ((album.album_id)=[track].[album_id]))
GROUP BY album.album_id
HAVING (((Count(track.name))>1))) AS Выражение1
FROM track, album
WHERE (((track.album_id)=[album].[album_id]));