
CREATE TABLE albums (
	id INTEGER, 
	title VARCHAR(160) NOT NULL, 
	artist_id INTEGER NOT NULL, 
	PRIMARY KEY (id), 
	FOREIGN KEY(artist_id) REFERENCES artists (id)
)


CREATE TABLE artists (
	id INTEGER, 
	name VARCHAR(120), 
	PRIMARY KEY (id)
)


CREATE TABLE customers (
	id INTEGER, 
	first_name VARCHAR(40) NOT NULL, 
	last_name VARCHAR(20) NOT NULL, 
	company VARCHAR(80), 
	address VARCHAR(70), 
	city VARCHAR(40), 
	state VARCHAR(40), 
	country VARCHAR(40), 
	postal_code VARCHAR(10), 
	phone VARCHAR(24), 
	fax VARCHAR(24), 
	email VARCHAR(60) NOT NULL, 
	support_rep_id INTEGER, 
	PRIMARY KEY (id), 
	FOREIGN KEY(support_rep_id) REFERENCES employees (id)
)


CREATE TABLE employees (
	id INTEGER, 
	last_name VARCHAR(20) NOT NULL, 
	first_name VARCHAR(20) NOT NULL, 
	title VARCHAR(30), 
	reports_to INTEGER, 
	birth_date TIMESTAMP, 
	hire_date TIMESTAMP, 
	address VARCHAR(70), 
	city VARCHAR(40), 
	state VARCHAR(40), 
	country VARCHAR(40), 
	postal_code VARCHAR(10), 
	phone VARCHAR(24), 
	fax VARCHAR(24), 
	email VARCHAR(60), 
	PRIMARY KEY (id), 
	FOREIGN KEY(reports_to) REFERENCES employees (id)
)


CREATE TABLE genres (
	id INTEGER, 
	name VARCHAR(120), 
	PRIMARY KEY (id)
)


CREATE TABLE invoice_lines (
	id INTEGER, 
	invoice_id INTEGER NOT NULL, 
	track_id INTEGER NOT NULL, 
	unit_price NUMERIC(10, 2) NOT NULL, 
	quantity INTEGER NOT NULL, 
	PRIMARY KEY (id), 
	FOREIGN KEY(invoice_id) REFERENCES invoices (id), 
	FOREIGN KEY(track_id) REFERENCES tracks (id)
)


CREATE TABLE invoices (
	id INTEGER, 
	customer_id INTEGER NOT NULL, 
	invoice_date TIMESTAMP NOT NULL, 
	billing_address VARCHAR(70), 
	billing_city VARCHAR(40), 
	billing_state VARCHAR(40), 
	billing_country VARCHAR(40), 
	billing_postal_code VARCHAR(10), 
	total NUMERIC(10, 2) NOT NULL, 
	PRIMARY KEY (id), 
	FOREIGN KEY(customer_id) REFERENCES customers (id)
)


CREATE TABLE media_types (
	id INTEGER, 
	name VARCHAR(120), 
	PRIMARY KEY (id)
)


CREATE TABLE playlist_tracks (
	playlist_id INTEGER NOT NULL, 
	track_id INTEGER NOT NULL, 
	CONSTRAINT "PK_PlaylistTrack" PRIMARY KEY (playlist_id, track_id), 
	FOREIGN KEY(playlist_id) REFERENCES playlists (id), 
	FOREIGN KEY(track_id) REFERENCES tracks (id)
)


CREATE TABLE playlists (
	id INTEGER, 
	name VARCHAR(120), 
	PRIMARY KEY (id)
)


CREATE TABLE tracks (
	id INTEGER, 
	name VARCHAR(200) NOT NULL, 
	album_id INTEGER, 
	media_type_id INTEGER NOT NULL, 
	genre_id INTEGER, 
	composer VARCHAR(220), 
	milliseconds INTEGER NOT NULL, 
	bytes INTEGER, 
	unit_price NUMERIC(10, 2) NOT NULL, 
	PRIMARY KEY (id), 
	FOREIGN KEY(album_id) REFERENCES albums (id), 
	FOREIGN KEY(genre_id) REFERENCES genres (id), 
	FOREIGN KEY(media_type_id) REFERENCES media_types (id)
)

CREATE TABLE albums (
	id INTEGER, 
	title VARCHAR(160) NOT NULL, 
	artist_id INTEGER NOT NULL, 
	PRIMARY KEY (id), 
	FOREIGN KEY(artist_id) REFERENCES artists (id)
)

/*
2 rows from albums table:
id	title	artist_id
1	For Those About To Rock We Salute You	1
2	Balls to the Wall	2
*/


CREATE TABLE artists (
	id INTEGER, 
	name VARCHAR(120), 
	PRIMARY KEY (id)
)

/*
2 rows from artists table:
id	name
1	AC/DC
2	Accept
*/


CREATE TABLE customers (
	id INTEGER, 
	first_name VARCHAR(40) NOT NULL, 
	last_name VARCHAR(20) NOT NULL, 
	company VARCHAR(80), 
	address VARCHAR(70), 
	city VARCHAR(40), 
	state VARCHAR(40), 
	country VARCHAR(40), 
	postal_code VARCHAR(10), 
	phone VARCHAR(24), 
	fax VARCHAR(24), 
	email VARCHAR(60) NOT NULL, 
	support_rep_id INTEGER, 
	PRIMARY KEY (id), 
	FOREIGN KEY(support_rep_id) REFERENCES employees (id)
)

/*
2 rows from customers table:
id	first_name	last_name	company	address	city	state	country	postal_code	phone	fax	email	support_rep_id
1	Luís	Gonçalves	Embraer - Empresa Brasileira de Aeronáutica S.A.	Av. Brigadeiro Faria Lima, 2170	São José dos Campos	SP	Brazil	12227-000	+55 (12) 3923-5555	+55 (12) 3923-5566	luisg@embraer.com.br	3
2	Leonie	Köhler	None	Theodor-Heuss-Straße 34	Stuttgart	None	Germany	70174	+49 0711 2842222	None	leonekohler@surfeu.de	5
*/


CREATE TABLE employees (
	id INTEGER, 
	last_name VARCHAR(20) NOT NULL, 
	first_name VARCHAR(20) NOT NULL, 
	title VARCHAR(30), 
	reports_to INTEGER, 
	birth_date TIMESTAMP, 
	hire_date TIMESTAMP, 
	address VARCHAR(70), 
	city VARCHAR(40), 
	state VARCHAR(40), 
	country VARCHAR(40), 
	postal_code VARCHAR(10), 
	phone VARCHAR(24), 
	fax VARCHAR(24), 
	email VARCHAR(60), 
	PRIMARY KEY (id), 
	FOREIGN KEY(reports_to) REFERENCES employees (id)
)

/*
2 rows from employees table:
id	last_name	first_name	title	reports_to	birth_date	hire_date	address	city	state	country	postal_code	phone	fax	email
1	Adams	Andrew	General Manager	None	1962-02-18 00:00:00	2002-08-14 00:00:00	11120 Jasper Ave NW	Edmonton	AB	Canada	T5K 2N1	+1 (780) 428-9482	+1 (780) 428-3457	andrew@chinookcorp.com
2	Edwards	Nancy	Sales Manager	1	1958-12-08 00:00:00	2002-05-01 00:00:00	825 8 Ave SW	Calgary	AB	Canada	T2P 2T3	+1 (403) 262-3443	+1 (403) 262-3322	nancy@chinookcorp.com
*/


CREATE TABLE genres (
	id INTEGER, 
	name VARCHAR(120), 
	PRIMARY KEY (id)
)

/*
2 rows from genres table:
id	name
1	Rock
2	Jazz
*/


CREATE TABLE invoice_lines (
	id INTEGER, 
	invoice_id INTEGER NOT NULL, 
	track_id INTEGER NOT NULL, 
	unit_price NUMERIC(10, 2) NOT NULL, 
	quantity INTEGER NOT NULL, 
	PRIMARY KEY (id), 
	FOREIGN KEY(invoice_id) REFERENCES invoices (id), 
	FOREIGN KEY(track_id) REFERENCES tracks (id)
)

/*
2 rows from invoice_lines table:
id	invoice_id	track_id	unit_price	quantity
1	1	2	0.99	1
2	1	4	0.99	1
*/


CREATE TABLE invoices (
	id INTEGER, 
	customer_id INTEGER NOT NULL, 
	invoice_date TIMESTAMP NOT NULL, 
	billing_address VARCHAR(70), 
	billing_city VARCHAR(40), 
	billing_state VARCHAR(40), 
	billing_country VARCHAR(40), 
	billing_postal_code VARCHAR(10), 
	total NUMERIC(10, 2) NOT NULL, 
	PRIMARY KEY (id), 
	FOREIGN KEY(customer_id) REFERENCES customers (id)
)

/*
2 rows from invoices table:
id	customer_id	invoice_date	billing_address	billing_city	billing_state	billing_country	billing_postal_code	total
1	2	2007-01-01 00:00:00	Theodor-Heuss-Straße 34	Stuttgart	None	Germany	70174	1.98
2	4	2007-01-02 00:00:00	Ullevålsveien 14	Oslo	None	Norway	0171	3.96
*/


CREATE TABLE media_types (
	id INTEGER, 
	name VARCHAR(120), 
	PRIMARY KEY (id)
)

/*
2 rows from media_types table:
id	name
1	MPEG audio file
2	Protected AAC audio file
*/


CREATE TABLE playlist_tracks (
	playlist_id INTEGER NOT NULL, 
	track_id INTEGER NOT NULL, 
	CONSTRAINT "PK_PlaylistTrack" PRIMARY KEY (playlist_id, track_id), 
	FOREIGN KEY(playlist_id) REFERENCES playlists (id), 
	FOREIGN KEY(track_id) REFERENCES tracks (id)
)

/*
2 rows from playlist_tracks table:
playlist_id	track_id
1	3402
1	3389
*/


CREATE TABLE playlists (
	id INTEGER, 
	name VARCHAR(120), 
	PRIMARY KEY (id)
)

/*
2 rows from playlists table:
id	name
1	Music
2	Movies
*/


CREATE TABLE tracks (
	id INTEGER, 
	name VARCHAR(200) NOT NULL, 
	album_id INTEGER, 
	media_type_id INTEGER NOT NULL, 
	genre_id INTEGER, 
	composer VARCHAR(220), 
	milliseconds INTEGER NOT NULL, 
	bytes INTEGER, 
	unit_price NUMERIC(10, 2) NOT NULL, 
	PRIMARY KEY (id), 
	FOREIGN KEY(album_id) REFERENCES albums (id), 
	FOREIGN KEY(genre_id) REFERENCES genres (id), 
	FOREIGN KEY(media_type_id) REFERENCES media_types (id)
)

/*
2 rows from tracks table:
id	name	album_id	media_type_id	genre_id	composer	milliseconds	bytes	unit_price
1	For Those About To Rock (We Salute You)	1	1	1	Angus Young, Malcolm Young, Brian Johnson	343719	11170334	0.99
2	Balls to the Wall	2	2	1	None	342562	5510424	0.99
*/
List every album's title.
SELECT title FROM albums;
[{'title': 'For Those About To Rock We Salute You'}, {'title': 'Balls to the Wall'}, {'title': 'Restless and Wild'}, {'title': 'Let There Be Rock'}, {'title': 'Big Ones'}, {'title': 'Jagged Little Pill'}, {'title': 'Facelift'}, {'title': 'Warner 25 Anos'}, {'title': 'Plays Metallica By Four Cellos'}, {'title': 'Audioslave'}, {'title': 'Out Of Exile'}, {'title': 'BackBeat Soundtrack'}, {'title': 'The Best Of Billy Cobham'}, {'title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}, {'title': 'Alcohol Fueled Brewtality Live! [Disc 2]'}, {'title': 'Black Sabbath'}, {'title': 'Black Sabbath Vol. 4 (Remaster)'}, {'title': 'Body Count'}, {'title': 'Chemical Wedding'}, {'title': 'The Best Of Buddy Guy - The Millenium Collection'}, {'title': 'Prenda Minha'}, {'title': 'Sozinho Remix Ao Vivo'}, {'title': 'Minha Historia'}, {'title': 'Afrociberdelia'}, {'title': 'Da Lama Ao Caos'}, {'title': 'Acústico MTV live'}, {'title': 'Cidade Negra - Hits'}, {'title': 'Na Pista'}, {'title': 'Axé Bahia 2001'}, {'title': 'BBC Sessions [Disc 1] live'}, {'title': 'Bongo Fury'}, {'title': 'Carnaval 2001'}, {'title': 'Chill: Brazil (Disc 1)'}, {'title': 'Chill: Brazil (Disc 2)'}, {'title': 'Garage Inc. (Disc 1)'}, {'title': 'Greatest Hits II'}, {'title': 'Greatest Kiss'}, {'title': 'Heart of the Night'}, {'title': 'International Superhits'}, {'title': 'Into The Light'}, {'title': 'Meus Momentos'}, {'title': 'Minha História'}, {'title': 'MK III The Final Concerts [Disc 1]'}, {'title': 'Physical Graffiti [Disc 1]'}, {'title': 'Sambas De Enredo 2001'}, {'title': 'Supernatural'}, {'title': 'The Best of Ed Motta'}, {'title': 'The Essential Miles Davis [Disc 1]'}, {'title': 'The Essential Miles Davis [Disc 2]'}, {'title': 'The Final Concerts (Disc 2)'}, {'title': "Up An' Atom"}, {'title': 'Vinícius De Moraes - Sem Limite'}, {'title': 'Vozes do MPB'}, {'title': 'Chronicle, Vol. 1'}, {'title': 'Chronicle, Vol. 2'}, {'title': 'Cássia Eller - Coleção Sem Limite [Disc 2]'}, {'title': 'Cássia Eller - Sem Limite [Disc 1]'}, {'title': 'Come Taste The Band'}, {'title': 'Deep Purple In Rock'}, {'title': 'Fireball'}, {'title': "Knocking at Your Back Door: The Best Of Deep Purple in the 80's"}, {'title': 'Machine Head'}, {'title': 'Purpendicular'}, {'title': 'Slaves And Masters'}, {'title': 'Stormbringer'}, {'title': 'The Battle Rages On'}, {'title': "Vault: Def Leppard's Greatest Hits"}, {'title': 'Outbreak'}, {'title': 'Djavan Ao Vivo - Vol. 02'}, {'title': 'Djavan Ao Vivo - Vol. 1'}, {'title': 'Elis Regina-Minha História'}, {'title': 'The Cream Of Clapton'}, {'title': 'Unplugged'}, {'title': 'Album Of The Year'}, {'title': 'Angel Dust'}, {'title': 'King For A Day Fool For A Lifetime'}, {'title': 'The Real Thing'}, {'title': 'Deixa Entrar'}, {'title': 'In Your Honor [Disc 1]'}, {'title': 'In Your Honor [Disc 2]'}, {'title': 'One By One'}, {'title': 'The Colour And The Shape'}, {'title': 'My Way: The Best Of Frank Sinatra [Disc 1]'}, {'title': 'Roda De Funk'}, {'title': 'As Canções de Eu Tu Eles'}, {'title': 'Quanta Gente Veio Ver (Live)'}, {'title': 'Quanta Gente Veio ver--Bônus De Carnaval'}, {'title': 'Faceless'}, {'title': 'American Idiot'}, {'title': 'Appetite for Destruction'}, {'title': 'Use Your Illusion I'}, {'title': 'Use Your Illusion II'}, {'title': 'Blue Moods'}, {'title': 'A Matter of Life and Death'}, {'title': 'A Real Dead One'}, {'title': 'A Real Live One'}, {'title': 'Brave New World'}, {'title': 'Dance Of Death'}, {'title': 'Fear Of The Dark'}, {'title': 'Iron Maiden'}, {'title': 'Killers'}, {'title': 'Live After Death'}, {'title': 'Live At Donington 1992 (Disc 1)'}, {'title': 'Live At Donington 1992 (Disc 2)'}, {'title': 'No Prayer For The Dying'}, {'title': 'Piece Of Mind'}, {'title': 'Powerslave'}, {'title': 'Rock In Rio CD1'}, {'title': 'Rock In Rio CD2'}, {'title': 'Seventh Son of a Seventh Son'}, {'title': 'Somewhere in Time'}, {'title': 'The Number of The Beast'}, {'title': 'The X Factor'}, {'title': 'Virtual XI'}, {'title': 'Sex Machine'}, {'title': 'Emergency On Planet Earth'}, {'title': 'Synkronized'}, {'title': 'The Return Of The Space Cowboy'}, {'title': 'Get Born'}, {'title': 'Are You Experienced?'}, {'title': 'Surfing with the Alien (Remastered)'}, {'title': 'Jorge Ben Jor 25 Anos'}, {'title': 'Jota Quest-1995'}, {'title': 'Cafezinho'}, {'title': 'Living After Midnight'}, {'title': 'Unplugged live'}, {'title': 'BBC Sessions [Disc 2] live'}, {'title': 'Coda'}, {'title': 'Houses Of The Holy'}, {'title': 'In Through The Out Door'}, {'title': 'IV'}, {'title': 'Led Zeppelin I'}, {'title': 'Led Zeppelin II'}, {'title': 'Led Zeppelin III'}, {'title': 'Physical Graffiti [Disc 2]'}, {'title': 'Presence'}, {'title': 'The Song Remains The Same (Disc 1)'}, {'title': 'The Song Remains The Same (Disc 2)'}, {'title': 'A TempestadeTempestade Ou O Livro Dos Dias'}, {'title': 'Mais Do Mesmo'}, {'title': 'Greatest Hits'}, {'title': 'Lulu Santos - RCA 100 Anos De Música - Álbum 01'}, {'title': 'Lulu Santos - RCA 100 Anos De Música - Álbum 02'}, {'title': 'Misplaced Childhood'}, {'title': 'Barulhinho Bom'}, {'title': 'Seek And Shall Find: More Of The Best (1963-1981)'}, {'title': 'The Best Of Men At Work'}, {'title': 'Black Album'}, {'title': 'Garage Inc. (Disc 2)'}, {'title': "Kill 'Em All"}, {'title': 'Load'}, {'title': 'Master Of Puppets'}, {'title': 'ReLoad'}, {'title': 'Ride The Lightning'}, {'title': 'St. Anger'}, {'title': '...And Justice For All'}, {'title': 'Miles Ahead'}, {'title': 'Milton Nascimento Ao Vivo'}, {'title': 'Minas'}, {'title': 'Ace Of Spades'}, {'title': 'Demorou...'}, {'title': 'Motley Crue Greatest Hits'}, {'title': 'From The Muddy Banks Of The Wishkah live'}, {'title': 'Nevermind'}, {'title': 'Compositores'}, {'title': 'Olodum'}, {'title': 'Acústico MTV'}, {'title': 'Arquivo II'}, {'title': 'Arquivo Os Paralamas Do Sucesso'}, {'title': 'Bark at the Moon (Remastered)'}, {'title': 'Blizzard of Ozz'}, {'title': 'Diary of a Madman (Remastered)'}, {'title': 'No More Tears (Remastered)'}, {'title': 'Tribute'}, {'title': 'Walking Into Clarksdale'}, {'title': 'Original Soundtracks 1'}, {'title': 'The Beast Live'}, {'title': 'Live On Two Legs live'}, {'title': 'Pearl Jam'}, {'title': 'Riot Act'}, {'title': 'Ten'}, {'title': 'Vs.'}, {'title': 'Dark Side Of The Moon'}, {'title': 'Os Cães Ladram Mas A Caravana Não Pára'}, {'title': 'Greatest Hits I'}, {'title': 'News Of The World'}, {'title': 'Out Of Time'}, {'title': 'Green'}, {'title': 'New Adventures In Hi-Fi'}, {'title': 'The Best Of R.E.M.: The IRS Years'}, {'title': 'Cesta Básica'}, {'title': 'Raul Seixas'}, {'title': 'Blood Sugar Sex Magik'}, {'title': 'By The Way'}, {'title': 'Californication'}, {'title': 'Retrospective I (1974-1980)'}, {'title': 'Santana - As Years Go By'}, {'title': 'Santana Live'}, {'title': 'Maquinarama'}, {'title': 'O Samba Poconé'}, {'title': 'Judas 0: B-Sides and Rarities'}, {'title': 'Rotten Apples: Greatest Hits'}, {'title': 'A-Sides'}, {'title': 'Morning Dance'}, {'title': 'In Step'}, {'title': 'Core'}, {'title': 'Mezmerize'}, {'title': '1997 Black Light Syndrome'}, {'title': 'Live [Disc 1]'}, {'title': 'Live [Disc 2]'}, {'title': 'The Singles'}, {'title': 'Beyond Good And Evil'}, {'title': 'Pure Cult: The Best Of The Cult (For Rockers, Ravers, Lovers & Sinners) UK'}, {'title': 'The Doors'}, {'title': 'The Police Greatest Hits'}, {'title': 'Hot Rocks, 1964-1971 (Disc 1)'}, {'title': 'No Security'}, {'title': 'Voodoo Lounge'}, {'title': 'Tangents'}, {'title': 'Transmission'}, {'title': 'My Generation - The Very Best Of The Who'}, {'title': 'Serie Sem Limite (Disc 1)'}, {'title': 'Serie Sem Limite (Disc 2)'}, {'title': 'Acústico'}, {'title': 'Volume Dois'}, {'title': 'Battlestar Galactica: The Story So Far'}, {'title': 'Battlestar Galactica, Season 3'}, {'title': 'Heroes, Season 1'}, {'title': 'Lost, Season 3'}, {'title': 'Lost, Season 1'}, {'title': 'Lost, Season 2'}, {'title': 'Achtung Baby'}, {'title': "All That You Can't Leave Behind"}, {'title': 'B-Sides 1980-1990'}, {'title': 'How To Dismantle An Atomic Bomb'}, {'title': 'Pop'}, {'title': 'Rattle And Hum'}, {'title': 'The Best Of 1980-1990'}, {'title': 'War'}, {'title': 'Zooropa'}, {'title': 'UB40 The Best Of - Volume Two UK'}, {'title': 'Diver Down'}, {'title': 'The Best Of Van Halen, Vol. I'}, {'title': 'Van Halen'}, {'title': 'Van Halen III'}, {'title': 'Contraband'}, {'title': 'Vinicius De Moraes'}, {'title': 'Ao Vivo IMPORT'}, {'title': 'The Office, Season 1'}, {'title': 'The Office, Season 2'}, {'title': 'The Office, Season 3'}, {'title': 'Un-Led-Ed'}, {'title': 'Battlestar Galactica (Classic), Season 1'}, {'title': 'Aquaman'}, {'title': 'Instant Karma: The Amnesty International Campaign to Save Darfur'}, {'title': 'Speak of the Devil'}, {'title': '20th Century Masters - The Millennium Collection: The Best of Scorpions'}, {'title': 'House of Pain'}, {'title': 'Radio Brasil (O Som da Jovem Vanguarda) - Seleccao de Henrique Amaro'}, {'title': 'Cake: B-Sides and Rarities'}, {'title': 'LOST, Season 4'}, {'title': 'Quiet Songs'}, {'title': 'Muso Ko'}, {'title': 'Realize'}, {'title': 'Every Kind of Light'}, {'title': 'Duos II'}, {'title': 'Worlds'}, {'title': 'The Best of Beethoven'}, {'title': 'Temple of the Dog'}, {'title': 'Carry On'}, {'title': 'Revelations'}, {'title': 'Adorate Deum: Gregorian Chant from the Proper of the Mass'}, {'title': 'Allegri: Miserere'}, {'title': 'Pachelbel: Canon & Gigue'}, {'title': 'Vivaldi: The Four Seasons'}, {'title': 'Bach: Violin Concertos'}, {'title': 'Bach: Goldberg Variations'}, {'title': 'Bach: The Cello Suites'}, {'title': 'Handel: The Messiah (Highlights)'}, {'title': 'The World of Classical Favourites'}, {'title': 'Sir Neville Marriner: A Celebration'}, {'title': 'Mozart: Wind Concertos'}, {'title': 'Haydn: Symphonies 99 - 104'}, {'title': 'Beethoven: Symhonies Nos. 5 & 6'}, {'title': 'A Soprano Inspired'}, {'title': 'Great Opera Choruses'}, {'title': 'Wagner: Favourite Overtures'}, {'title': 'Fauré: Requiem, Ravel: Pavane & Others'}, {'title': 'Tchaikovsky: The Nutcracker'}, {'title': 'The Last Night of the Proms'}, {'title': 'Puccini: Madama Butterfly - Highlights'}, {'title': 'Holst: The Planets, Op. 32 & Vaughan Williams: Fantasies'}, {'title': "Pavarotti's Opera Made Easy"}, {'title': "Great Performances - Barber's Adagio and Other Romantic Favorites for Strings"}, {'title': 'Carmina Burana'}, {'title': 'A Copland Celebration, Vol. I'}, {'title': 'Bach: Toccata & Fugue in D Minor'}, {'title': 'Prokofiev: Symphony No.1'}, {'title': 'Scheherazade'}, {'title': 'Bach: The Brandenburg Concertos'}, {'title': 'Chopin: Piano Concertos Nos. 1 & 2'}, {'title': 'Mascagni: Cavalleria Rusticana'}, {'title': 'Sibelius: Finlandia'}, {'title': 'Beethoven Piano Sonatas: Moonlight & Pastorale'}, {'title': 'Great Recordings of the Century - Mahler: Das Lied von der Erde'}, {'title': 'Elgar: Cello Concerto & Vaughan Williams: Fantasias'}, {'title': 'Adams, John: The Chairman Dances'}, {'title': "Tchaikovsky: 1812 Festival Overture, Op.49, Capriccio Italien & Beethoven: Wellington's Victory"}, {'title': 'Palestrina: Missa Papae Marcelli & Allegri: Miserere'}, {'title': 'Prokofiev: Romeo & Juliet'}, {'title': 'Strauss: Waltzes'}, {'title': 'Berlioz: Symphonie Fantastique'}, {'title': 'Bizet: Carmen Highlights'}, {'title': 'English Renaissance'}, {'title': 'Handel: Music for the Royal Fireworks (Original Version 1749)'}, {'title': 'Grieg: Peer Gynt Suites & Sibelius: Pelléas et Mélisande'}, {'title': 'Mozart Gala: Famous Arias'}, {'title': 'SCRIABIN: Vers la flamme'}, {'title': 'Armada: Music from the Courts of England and Spain'}, {'title': 'Mozart: Symphonies Nos. 40 & 41'}, {'title': 'Back to Black'}, {'title': 'Frank'}, {'title': 'Carried to Dust (Bonus Track Version)'}, {'title': "Beethoven: Symphony No. 6 'Pastoral' Etc."}, {'title': 'Bartok: Violin & Viola Concertos'}, {'title': "Mendelssohn: A Midsummer Night's Dream"}, {'title': 'Bach: Orchestral Suites Nos. 1 - 4'}, {'title': 'Charpentier: Divertissements, Airs & Concerts'}, {'title': 'South American Getaway'}, {'title': 'Górecki: Symphony No. 3'}, {'title': 'Purcell: The Fairy Queen'}, {'title': 'The Ultimate Relexation Album'}, {'title': 'Purcell: Music for the Queen Mary'}, {'title': 'Weill: The Seven Deadly Sins'}, {'title': 'J.S. Bach: Chaconne, Suite in E Minor, Partita in E Major & Prelude, Fugue and Allegro'}, {'title': 'Prokofiev: Symphony No.5 & Stravinksy: Le Sacre Du Printemps'}, {'title': 'Szymanowski: Piano Works, Vol. 1'}, {'title': 'Nielsen: The Six Symphonies'}, {'title': "Great Recordings of the Century: Paganini's 24 Caprices"}, {'title': "Liszt - 12 Études D'Execution Transcendante"}, {'title': 'Great Recordings of the Century - Shubert: Schwanengesang, 4 Lieder'}, {'title': 'Locatelli: Concertos for Violin, Strings and Continuo, Vol. 3'}, {'title': 'Respighi:Pines of Rome'}, {'title': "Schubert: The Late String Quartets & String Quintet (3 CD's)"}, {'title': "Monteverdi: L'Orfeo"}, {'title': 'Mozart: Chamber Music'}, {'title': 'Koyaanisqatsi (Soundtrack from the Motion Picture)'}]