-- 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 ] |
-- -- How many albums and Single-Tables were released by the artist named '50 cent' between 2010 and 2015?

SELECT COUNT(id), ( SELECT COUNT(id) FROM torrents WHERE groupYear BETWEEN 2010 AND 2015 AND artist LIKE '50 cent' AND releaseType LIKE 'album' ) FROM torrents WHERE groupYear BETWEEN 2010 AND 2015 AND artist LIKE '50 cent' AND releaseType LIKE 'Single';