Database schema:

CREATE TABLE tags (
	"index" INTEGER -- example: ['0', '1'],
	id INTEGER -- example: ['0', '2'],
	tag TEXT -- example: ['funk', '1970s'],
	PRIMARY KEY ("index"), 
	CONSTRAINT fk_tags_torrents FOREIGN KEY(id) REFERENCES torrents (id)
)


CREATE TABLE torrents (
	"groupName" TEXT -- example: ['spiderap / a corona jam', 'superappin&#39;'],
	"totalSnatched" INTEGER -- example: ['239', '156'],
	artist TEXT -- example: ['grandmaster flash & the furious five', 'ron hunt & ronnie g & the sm crew'],
	"groupYear" INTEGER -- example: ['1979', '1980'],
	"releaseType" TEXT -- example: ['single', 'album'],
	"groupId" INTEGER -- example: ['720949', '728752'],
	id INTEGER -- example: ['0', '1'],
	PRIMARY KEY (id)
)

Question: Among id from 10 to 50. Which artist tagged as "new.york" has the most downloads?
Evidence: Among id from 10 to 50 refers to id between 10 and 50; tag = 'new.york'; the most downloads refer to MAX(totalSnatched);

SQL:
SELECT T1.artist FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.id BETWEEN 10 AND 50 AND T2.tag LIKE 'new.york' ORDER BY T1.totalSnatched DESC LIMIT 1