-- Database schema
| torrents : groupName [ TEXT ] , totalSnatched [ INTEGER ] , artist [ TEXT ] , groupYear [ INTEGER ] , releaseType [ TEXT ] , groupId [ INTEGER ] , id [ INTEGER ] primary_key | tags : index [ INTEGER ] primary_key , id [ INTEGER ] , tag [ TEXT ] |
-- -- What are the average download times for the a release tagged "1980s"?

SELECT CAST(SUM(T1.totalSnatched) AS REAL) / COUNT(T2.tag) FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T2.tag = '1980s';