Which albums have been downloaded more than 100 times?
CREATE TABLE torrents (
    groupname text,
    totalsnatched number,
    artist text,
    groupyear number,
    releasetype text,
    groupid number,
    id number
)

CREATE TABLE tags (
    index number,
    id number,
    tag text
)
SELECT DISTINCT groupname FROM torrents WHERE totalsnatched > 100 AND releasetype = "album"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Which albums have been downloaded more than 100 times? ### Input: CREATE TABLE torrents (
    groupname text,
    totalsnatched number,
    artist text,
    groupyear number,
    releasetype text,
    groupid number,
    id number
)

CREATE TABLE tags (
    index number,
    id number,
    tag text
) ### Response: SELECT DISTINCT groupname FROM torrents WHERE totalsnatched > 100 AND releasetype = "album"