-- 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 ] |
-- -- Find the average number of downloads for Single-Tables released by '2Pac' between 2001 and 2013.

SELECT AVG(totalSnatched) FROM torrents WHERE artist LIKE '2Pac' AND releaseType LIKE 'Single' AND groupYear BETWEEN 2001 AND 2013;