### Database Schema:
CREATE TABLE tags (
	index	INTEGER	NULL	PRIMARY KEY,
	id	INTEGER	NULL,
	tag	TEXT	NULL,
	foreign key (id) references torrents (id)
);

CREATE TABLE torrents (
	groupName	TEXT	NULL,
	totalSnatched	INTEGER	NULL,
	artist	TEXT	NULL,
	groupYear	INTEGER	NULL,
	releaseType	TEXT	NULL,
	groupId	INTEGER	NULL,
	id	INTEGER	NULL	PRIMARY KEY
);

### User's Query:
Among id from 10 to 50. Which artist tagged as "new.york" has the most downloads?

### Extra Knowledge:
Among id from 10 to 50 refers to id between 10 and 50; tag = 'new.york'; the most downloads refer to MAX(totalSnatched);
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