CREATE TABLE album (albumid DECIMAL, title TEXT, artistid DECIMAL)
CREATE TABLE invoiceline (invoicelineid DECIMAL, invoiceid DECIMAL, trackid DECIMAL, unitprice DECIMAL, quantity DECIMAL)
CREATE TABLE invoice (invoiceid DECIMAL, customerid DECIMAL, invoicedate TIME, billingaddress TEXT, billingcity TEXT, billingstate TEXT, billingcountry TEXT, billingpostalcode TEXT, total DECIMAL)
CREATE TABLE employee (employeeid DECIMAL, lastname TEXT, firstname TEXT, title TEXT, reportsto DECIMAL, birthdate TIME, hiredate TIME, address TEXT, city TEXT, state TEXT, country TEXT, postalcode TEXT, phone TEXT, fax TEXT, email TEXT)
CREATE TABLE playlisttrack (playlistid DECIMAL, trackid DECIMAL)
CREATE TABLE genre (genreid DECIMAL, name TEXT)
CREATE TABLE playlist (playlistid DECIMAL, name TEXT)
CREATE TABLE mediatype (mediatypeid DECIMAL, name TEXT)
CREATE TABLE customer (customerid DECIMAL, firstname TEXT, lastname TEXT, company TEXT, address TEXT, city TEXT, state TEXT, country TEXT, postalcode TEXT, phone TEXT, fax TEXT, email TEXT, supportrepid DECIMAL)
CREATE TABLE artist (artistid DECIMAL, name TEXT)
CREATE TABLE track (trackid DECIMAL, name TEXT, albumid DECIMAL, mediatypeid DECIMAL, genreid DECIMAL, composer TEXT, milliseconds DECIMAL, bytes DECIMAL, unitprice DECIMAL)

What are the names and ids of the different albums, and how many tracks are on each?
SELECT T1.title, T2.albumid, COUNT(*) FROM album AS T1 JOIN track AS T2 ON T1.albumid = T2.albumid GROUP BY T2.albumid
SELECT "T1"."title", "T2"."albumid", COUNT(*) FROM "album" AS "T1" JOIN "track" AS "T2" ON "T1"."albumid" = "T2"."albumid" GROUP BY "T2"."albumid"