text: CREATE TABLE ARTIST (ArtistId VARCHAR, Name VARCHAR); CREATE TABLE ALBUM (ArtistId VARCHAR) -- Hom many albums does the artist "Metallica" have? SELECT COUNT(*) FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId = T2.ArtistId WHERE T2.Name = "Metallica" CREATE TABLE ALBUM (ArtistId VARCHAR, Title VARCHAR); CREATE TABLE ARTIST (Name VARCHAR, ArtistId VARCHAR) -- Which artist does the album "Balls to the Wall" belong to? SELECT T2.Name FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId = T2.ArtistId WHERE T1.Title = "Balls to the Wall" CREATE TABLE ALBUM (ArtistId VARCHAR); CREATE TABLE ARTIST (Name VARCHAR, ArtistId VARCHAR) -- Which artist has the most albums? SELECT T2.Name FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId = T2.ArtistId GROUP BY T2.Name ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE TRACK (Name VARCHAR) -- Find the names of all the tracks that contain the word "you". SELECT Name FROM TRACK WHERE Name LIKE '%you%' CREATE TABLE TRACK (UnitPrice INTEGER) -- What is the average unit price of all the tracks? SELECT AVG(UnitPrice) FROM TRACK CREATE TABLE TRACK (Milliseconds INTEGER) -- What are the durations of the longest and the shortest tracks in milliseconds? SELECT MAX(Milliseconds), MIN(Milliseconds) FROM TRACK CREATE TABLE ALBUM (Title VARCHAR, AlbumId VARCHAR); CREATE TABLE TRACK (AlbumID VARCHAR, AlbumId VARCHAR) -- Show the album names, ids and the number of tracks for each album. SELECT T1.Title, T2.AlbumID, COUNT(*) FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumId = T2.AlbumId GROUP BY T2.AlbumID