SELECT albumid, COUNT(trackid) FROM tracks GROUP BY albumid;
SELECT albumid, COUNT(trackid) FROM tracks GROUP BY albumid HAVING albumid = 1;
SELECT albumid, COUNT(trackid) FROM tracks GROUP BY albumid HAVING count(albumid) BETWEEN 18 AND 20 ORDER BY albumid;
SELECT tracks.albumid, title, sum(Milliseconds) AS length FROM tracks INNER JOIN albums ON albums.AlbumId = tracks.AlbumId GROUP BY tracks.albumid HAVING length > 60000000;
SELECT * FROM albums;
SELECT * FROM artists;
SELECT * FROM customers;
SELECT * FROM employees;
SELECT * FROM genres;
SELECT * FROM invoice_items;
SELECT * FROM invoices;
SELECT * FROM media_types;
SELECT * FROM playlist_track;
SELECT * FROM playlists;
SELECT * FROM tracks;