Show the album names, ids and the number of tracks for each album.
CREATE TABLE ALBUM (
    Title VARCHAR,
    AlbumId VARCHAR
)

CREATE TABLE TRACK (
    AlbumID VARCHAR,
    AlbumId VARCHAR
)
SELECT T1.Title, T2.AlbumID, COUNT(*) FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumID = T2.AlbumID GROUP BY T2.AlbumID
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: Show the album names, ids and the number of tracks for each album. ### Input: CREATE TABLE ALBUM (
    Title VARCHAR,
    AlbumId VARCHAR
)

CREATE TABLE TRACK (
    AlbumID VARCHAR,
    AlbumId VARCHAR
) ### Response: SELECT T1.Title, T2.AlbumID, COUNT(*) FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumID = T2.AlbumID GROUP BY T2.AlbumID