SELECT avg(i.count)
FROM
(SELECT a.title,
    COUNT(tr.track_id)
FROM album AS a
LEFT OUTER JOIN track AS tr ON a.album_id = tr.album_id
WHERE a.title LIKE '%Rock%'
GROUP BY a.title) as i
WHERE i.count >= 8