Tutorial: Exploring a database with Preql

Preface

This is a practical tutorial on how to use Preql to explore an existing database, using the Jupyter environment.

It shows how to take a database with many tables, explore them, and join them into new tables.

This tutorial assumes basic knowledge of the language. If you're unsure, consider first reading the tutorial: https://preql.readthedocs.io/en/latest/tutorial.html

Learn Preql interactively

Use the help() function to get information about functions and types:

In [1]:
help()
To see the list of functions and objects available in the namespace, type 'names()'
To see the next page of a table preview, type '.' and then enter

To get help for a specific function, type 'help(an_object)'

For example:
    >> help(help)

Use tab to autocomplete your code.

How to use this tutorial

Follow the code examples, and make sure to add your own cells and play around with the code.

1) Connect to the database

We tell Preql which database to use, by calling the connect() function with a URI.

Since we are connecting for exploration, we will also tell it to load all the tables in the database into the global namespace.

In [1]:
uri = "sqlite:///tracks.db"
connect(uri, load_all_tables: true)

If there was no error, it means everything went well.

We can confirm by listing the tables in the database:

In [2]:
tables()
table , =13
name type
albums table[AlbumId: int, Title: string?, ArtistId: int]
sqlite_sequence table[name: string?, seq: string?]
artists table[ArtistId: int, Name: string?]
customers table[CustomerId: int, FirstName: string?, LastName: string?, Company: string?, Address: string?, City: string?, State: string?, Country: string?, PostalCode: string?, Phone: string?, Fax: string?, Email: string?, SupportRepId: int?]
employees table[EmployeeId: int, LastName: string?, FirstName: string?, Title: string?, ReportsTo: int?, BirthDate: string?, HireDate: string?, Address: string?, City: string?, State: string?, Country: string?, PostalCode: string?, Phone: string?, Fax: string?, Email: string?]
genres table[GenreId: int, Name: string?]
invoices table[InvoiceId: int, CustomerId: int, InvoiceDate: string?, BillingAddress: string?, BillingCity: string?, BillingState: string?, BillingCountry: string?, BillingPostalCode: string?, Total: string?]
invoice_items table[InvoiceLineId: int, InvoiceId: int, TrackId: int, UnitPrice: string?, Quantity: int]
media_types table[MediaTypeId: int, Name: string?]
playlists table[PlaylistId: int, Name: string?]
playlist_track table[PlaylistId: int, TrackId: int]
tracks table[TrackId: int, Name: string?, AlbumId: int?, MediaTypeId: int, GenreId: int?, Composer: string?, Milliseconds: int, Bytes: int?, UnitPrice: string?]
sqlite_stat1 table[tbl: string?, idx: string?, stat: string?]

2) Connecting Foreign Keys

Join two tables

For a start, let's focus on the tracks table. We can see in the preview below that it contains foreign keys (AlbumId and GenreId, and common-sense suggests that they relate to the tables albums and genres.

In [5]:
tracks
table tracks, =3503
AlbumId GenreId TrackId Name MediaTypeId Composer Milliseconds Bytes UnitPrice
1 1 1 For Those About To Rock (We Salute You) 1 Angus Young, Malcolm Young, Brian Johnson 343719 11170334 0.99
2 1 2 Balls to the Wall 2 None 342562 5510424 0.99
3 1 3 Fast As a Shark 2 F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman 230619 3990994 0.99
3 1 4 Restless and Wild 2 F. Baltes, R.A. Smith-Diesel, S. Kaufman, U. Dirkscneider & W. Hoffman 252051 4331779 0.99
3 1 5 Princess of the Dawn 2 Deaffy & R.A. Smith-Diesel 375418 6290521 0.99
1 1 6 Put The Finger On You 1 Angus Young, Malcolm Young, Brian Johnson 205662 6713451 0.99
1 1 7 Let's Get It Up 1 Angus Young, Malcolm Young, Brian Johnson 233926 7636561 0.99
1 1 8 Inject The Venom 1 Angus Young, Malcolm Young, Brian Johnson 210834 6852860 0.99
1 1 9 Snowballed 1 Angus Young, Malcolm Young, Brian Johnson 203102 6599424 0.99
1 1 10 Evil Walks 1 Angus Young, Malcolm Young, Brian Johnson 263497 8611245 0.99
1 1 11 C.O.D. 1 Angus Young, Malcolm Young, Brian Johnson 199836 6566314 0.99
1 1 12 Breaking The Rules 1 Angus Young, Malcolm Young, Brian Johnson 263288 8596840 0.99
1 1 13 Night Of The Long Knives 1 Angus Young, Malcolm Young, Brian Johnson 205688 6706347 0.99
1 1 14 Spellbound 1 Angus Young, Malcolm Young, Brian Johnson 270863 8817038 0.99
4 1 15 Go Down 1 AC/DC 331180 10847611 0.99
4 1 16 Dog Eat Dog 1 AC/DC 215196 7032162 0.99
4 1 17 Let There Be Rock 1 AC/DC 366654 12021261 0.99
4 1 18 Bad Boy Boogie 1 AC/DC 267728 8776140 0.99
4 1 19 Problem Child 1 AC/DC 325041 10617116 0.99
4 1 20 Overdose 1 AC/DC 369319 12066294 0.99
4 1 21 Hell Ain't A Bad Place To Be 1 AC/DC 254380 8331286 0.99
4 1 22 Whole Lotta Rosie 1 AC/DC 323761 10547154 0.99
5 1 23 Walk On Water 1 Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw 295680 9719579 0.99
5 1 24 Love In An Elevator 1 Steven Tyler, Joe Perry 321828 10552051 0.99
5 1 25 Rag Doll 1 Steven Tyler, Joe Perry, Jim Vallance, Holly Knight 264698 8675345 0.99
5 1 26 What It Takes 1 Steven Tyler, Joe Perry, Desmond Child 310622 10144730 0.99
5 1 27 Dude (Looks Like A Lady) 1 Steven Tyler, Joe Perry, Desmond Child 264855 8679940 0.99
5 1 28 Janie's Got A Gun 1 Steven Tyler, Tom Hamilton 330736 10869391 0.99
5 1 29 Cryin' 1 Steven Tyler, Joe Perry, Taylor Rhodes 309263 10056995 0.99
5 1 30 Amazing 1 Steven Tyler, Richie Supa 356519 11616195 0.99
5 1 31 Blind Man 1 Steven Tyler, Joe Perry, Taylor Rhodes 240718 7877453 0.99
5 1 32 Deuces Are Wild 1 Steven Tyler, Jim Vallance 215875 7074167 0.99
5 1 33 The Other Side 1 Steven Tyler, Jim Vallance 244375 7983270 0.99
5 1 34 Crazy 1 Steven Tyler, Joe Perry, Desmond Child 316656 10402398 0.99
5 1 35 Eat The Rich 1 Steven Tyler, Joe Perry, Jim Vallance 251036 8262039 0.99
5 1 36 Angel 1 Steven Tyler, Desmond Child 307617 9989331 0.99
5 1 37 Livin' On The Edge 1 Steven Tyler, Joe Perry, Mark Hudson 381231 12374569 0.99
6 1 38 All I Really Want 1 Alanis Morissette & Glenn Ballard 284891 9375567 0.99
6 1 39 You Oughta Know 1 Alanis Morissette & Glenn Ballard 249234 8196916 0.99
6 1 40 Perfect 1 Alanis Morissette & Glenn Ballard 188133 6145404 0.99
6 1 41 Hand In My Pocket 1 Alanis Morissette & Glenn Ballard 221570 7224246 0.99
6 1 42 Right Through You 1 Alanis Morissette & Glenn Ballard 176117 5793082 0.99
6 1 43 Forgiven 1 Alanis Morissette & Glenn Ballard 300355 9753256 0.99
6 1 44 You Learn 1 Alanis Morissette & Glenn Ballard 239699 7824837 0.99
6 1 45 Head Over Feet 1 Alanis Morissette & Glenn Ballard 267493 8758008 0.99
6 1 46 Mary Jane 1 Alanis Morissette & Glenn Ballard 280607 9163588 0.99
6 1 47 Ironic 1 Alanis Morissette & Glenn Ballard 229825 7598866 0.99
6 1 48 Not The Doctor 1 Alanis Morissette & Glenn Ballard 227631 7604601 0.99
6 1 49 Wake Up 1 Alanis Morissette & Glenn Ballard 293485 9703359 0.99
6 1 50 You Oughta Know (Alternate) 1 Alanis Morissette & Glenn Ballard 491885 16008629 0.99
7 1 51 We Die Young 1 Jerry Cantrell 152084 4925362 0.99
7 1 52 Man In The Box 1 Jerry Cantrell, Layne Staley 286641 9310272 0.99
7 1 53 Sea Of Sorrow 1 Jerry Cantrell 349831 11316328 0.99
7 1 54 Bleed The Freak 1 Jerry Cantrell 241946 7847716 0.99
7 1 55 I Can't Remember 1 Jerry Cantrell, Layne Staley 222955 7302550 0.99
7 1 56 Love, Hate, Love 1 Jerry Cantrell, Layne Staley 387134 12575396 0.99
7 1 57 It Ain't Like That 1 Jerry Cantrell, Michael Starr, Sean Kinney 277577 8993793 0.99
7 1 58 Sunshine 1 Jerry Cantrell 284969 9216057 0.99
7 1 59 Put You Down 1 Jerry Cantrell 196231 6420530 0.99
7 1 60 Confusion 1 Jerry Cantrell, Michael Starr, Layne Staley 344163 11183647 0.99
7 1 61 I Know Somethin (Bout You) 1 Jerry Cantrell 261955 8497788 0.99
7 1 62 Real Thing 1 Jerry Cantrell, Layne Staley 243879 7937731 0.99
8 2 63 Desafinado 1 None 185338 5990473 0.99
8 2 64 Garota De Ipanema 1 None 285048 9348428 0.99
8 2 65 Samba De Uma Nota Só (One Note Samba) 1 None 137273 4535401 0.99
8 2 66 Por Causa De Você 1 None 169900 5536496 0.99
8 2 67 Ligia 1 None 251977 8226934 0.99
8 2 68 Fotografia 1 None 129227 4198774 0.99
8 2 69 Dindi (Dindi) 1 None 253178 8149148 0.99
8 2 70 Se Todos Fossem Iguais A Você (Instrumental) 1 None 134948 4393377 0.99
8 2 71 Falando De Amor 1 None 219663 7121735 0.99
8 2 72 Angela 1 None 169508 5574957 0.99
8 2 73 Corcovado (Quiet Nights Of Quiet Stars) 1 None 205662 6687994 0.99
8 2 74 Outra Vez 1 None 126511 4110053 0.99
8 2 75 O Boto (Bôto) 1 None 366837 12089673 0.99
8 2 76 Canta, Canta Mais 1 None 271856 8719426 0.99
9 3 77 Enter Sandman 1 Apocalyptica 221701 7286305 0.99
9 3 78 Master Of Puppets 1 Apocalyptica 436453 14375310 0.99
9 3 79 Harvester Of Sorrow 1 Apocalyptica 374543 12372536 0.99
9 3 80 The Unforgiven 1 Apocalyptica 322925 10422447 0.99
9 3 81 Sad But True 1 Apocalyptica 288208 9405526 0.99
9 3 82 Creeping Death 1 Apocalyptica 308035 10110980 0.99
9 3 83 Wherever I May Roam 1 Apocalyptica 369345 12033110 0.99
9 3 84 Welcome Home (Sanitarium) 1 Apocalyptica 350197 11406431 0.99
10 1 85 Cochise 1 Audioslave/Chris Cornell 222380 5339931 0.99
10 1 86 Show Me How to Live 1 Audioslave/Chris Cornell 277890 6672176 0.99
10 1 87 Gasoline 1 Audioslave/Chris Cornell 279457 6709793 0.99
10 1 88 What You Are 1 Audioslave/Chris Cornell 249391 5988186 0.99
10 1 89 Like a Stone 1 Audioslave/Chris Cornell 294034 7059624 0.99
10 1 90 Set It Off 1 Audioslave/Chris Cornell 263262 6321091 0.99
10 1 91 Shadow on the Sun 1 Audioslave/Chris Cornell 343457 8245793 0.99
10 1 92 I am the Highway 1 Audioslave/Chris Cornell 334942 8041411 0.99
10 1 93 Exploder 1 Audioslave/Chris Cornell 206053 4948095 0.99
10 1 94 Hypnotize 1 Audioslave/Chris Cornell 206628 4961887 0.99
10 1 95 Bring'em Back Alive 1 Audioslave/Chris Cornell 329534 7911634 0.99
10 1 96 Light My Way 1 Audioslave/Chris Cornell 303595 7289084 0.99
10 1 97 Getaway Car 1 Audioslave/Chris Cornell 299598 7193162 0.99
10 1 98 The Last Remaining Light 1 Audioslave/Chris Cornell 317492 7622615 0.99
11 4 99 Your Time Has Come 1 Cornell, Commerford, Morello, Wilk 255529 8273592 0.99
11 4 100 Out Of Exile 1 Cornell, Commerford, Morello, Wilk 291291 9506571 0.99
11 4 101 Be Yourself 1 Cornell, Commerford, Morello, Wilk 279484 9106160 0.99
11 4 102 Doesn't Remind Me 1 Cornell, Commerford, Morello, Wilk 255869 8357387 0.99
11 4 103 Drown Me Slowly 1 Cornell, Commerford, Morello, Wilk 233691 7609178 0.99
11 4 104 Heaven's Dead 1 Cornell, Commerford, Morello, Wilk 276688 9006158 0.99
11 4 105 The Worm 1 Cornell, Commerford, Morello, Wilk 237714 7710800 0.99
11 4 106 Man Or Animal 1 Cornell, Commerford, Morello, Wilk 233195 7542942 0.99
11 4 107 Yesterday To Tomorrow 1 Cornell, Commerford, Morello, Wilk 273763 8944205 0.99
11 4 108 Dandelion 1 Cornell, Commerford, Morello, Wilk 278125 9003592 0.99
11 4 109 #1 Zero 1 Cornell, Commerford, Morello, Wilk 299102 9731988 0.99
11 4 110 The Curse 1 Cornell, Commerford, Morello, Wilk 309786 10029406 0.99
12 5 111 Money 1 Berry Gordy, Jr./Janie Bradford 147591 2365897 0.99
12 5 112 Long Tall Sally 1 Enotris Johnson/Little Richard/Robert "Bumps" Blackwell 106396 1707084 0.99
12 5 113 Bad Boy 1 Larry Williams 116088 1862126 0.99
12 5 114 Twist And Shout 1 Bert Russell/Phil Medley 161123 2582553 0.99
12 5 115 Please Mr. Postman 1 Brian Holland/Freddie Gorman/Georgia Dobbins/Robert Bateman/William Garrett 137639 2206986 0.99
12 5 116 C'Mon Everybody 1 Eddie Cochran/Jerry Capehart 140199 2247846 0.99
12 5 117 Rock 'N' Roll Music 1 Chuck Berry 141923 2276788 0.99
12 5 118 Slow Down 1 Larry Williams 163265 2616981 0.99
12 5 119 Roadrunner 1 Bo Diddley 143595 2301989 0.99
12 5 120 Carol 1 Chuck Berry 143830 2306019 0.99
12 5 121 Good Golly Miss Molly 1 Little Richard 106266 1704918 0.99
12 5 122 20 Flight Rock 1 Ned Fairchild 107807 1299960 0.99
13 2 123 Quadrant 1 Billy Cobham 261851 8538199 0.99
13 2 124 Snoopy's search-Red baron 1 Billy Cobham 456071 15075616 0.99
13 2 125 Spanish moss-"A sound portrait"-Spanish moss 1 Billy Cobham 248084 8217867 0.99
13 2 126 Moon germs 1 Billy Cobham 294060 9714812 0.99
13 2 127 Stratus 1 Billy Cobham 582086 19115680 0.99
13 2 128 The pleasant pheasant 1 Billy Cobham 318066 10630578 0.99
13 2 129 Solo-Panhandler 1 Billy Cobham 246151 8230661 0.99
13 2 130 Do what cha wanna 1 George Duke 274155 9018565 0.99
14 3 131 Intro/ Low Down 1 None 323683 10642901 0.99
14 3 132 13 Years Of Grief 1 None 246987 8137421 0.99
14 3 133 Stronger Than Death 1 None 300747 9869647 0.99
14 3 134 All For You 1 None 235833 7726948 0.99
14 3 135 Super Terrorizer 1 None 319373 10513905 0.99
14 3 136 Phoney Smile Fake Hellos 1 None 273606 9011701 0.99
14 3 137 Lost My Better Half 1 None 284081 9355309 0.99
14 3 138 Bored To Tears 1 None 247327 8130090 0.99
14 3 139 A.N.D.R.O.T.A.Z. 1 None 266266 8574746 0.99
14 3 140 Born To Booze 1 None 282122 9257358 0.99
14 3 141 World Of Trouble 1 None 359157 11820932 0.99
14 3 142 No More Tears 1 None 555075 18041629 0.99
14 3 143 The Begining... At Last 1 None 365662 11965109 0.99
15 3 144 Heart Of Gold 1 None 194873 6417460 0.99
15 3 145 Snowblind 1 None 420022 13842549 0.99
15 3 146 Like A Bird 1 None 276532 9115657 0.99
15 3 147 Blood In The Wall 1 None 284368 9359475 0.99
15 3 148 The Beginning...At Last 1 None 271960 8975814 0.99
16 3 149 Black Sabbath 1 None 382066 12440200 0.99
16 3 150 The Wizard 1 None 264829 8646737 0.99
16 3 151 Behind The Wall Of Sleep 1 None 217573 7169049 0.99
16 3 152 N.I.B. 1 None 368770 12029390 0.99
16 3 153 Evil Woman 1 None 204930 6655170 0.99
16 3 154 Sleeping Village 1 None 644571 21128525 0.99
16 3 155 Warning 1 None 212062 6893363 0.99
17 3 156 Wheels Of Confusion / The Straightener 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 494524 16065830 0.99
17 3 157 Tomorrow's Dream 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 192496 6252071 0.99
17 3 158 Changes 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 286275 9175517 0.99
17 3 159 FX 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 103157 3331776 0.99
17 3 160 Supernaut 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 285779 9245971 0.99
...

We can join tracks and albums using their mutual column:

In [6]:
join(t: tracks.AlbumId, a: albums.AlbumId)
table join8, =3503
t a
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 1, 'Name': 'For Those About To Rock (We Salute You)', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 343719, 'Bytes': 11170334, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 6, 'Name': 'Put The Finger On You', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 205662, 'Bytes': 6713451, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 7, 'Name': "Let's Get It Up", 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 233926, 'Bytes': 7636561, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 8, 'Name': 'Inject The Venom', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 210834, 'Bytes': 6852860, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 9, 'Name': 'Snowballed', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 203102, 'Bytes': 6599424, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 10, 'Name': 'Evil Walks', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 263497, 'Bytes': 8611245, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 11, 'Name': 'C.O.D.', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 199836, 'Bytes': 6566314, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 12, 'Name': 'Breaking The Rules', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 263288, 'Bytes': 8596840, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 13, 'Name': 'Night Of The Long Knives', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 205688, 'Bytes': 6706347, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 14, 'Name': 'Spellbound', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 270863, 'Bytes': 8817038, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'}
{'AlbumId': 2, 'GenreId': 1, 'TrackId': 2, 'Name': 'Balls to the Wall', 'MediaTypeId': 2, 'Composer': None, 'Milliseconds': 342562, 'Bytes': 5510424, 'UnitPrice': 0.99} {'ArtistId': 2, 'AlbumId': 2, 'Title': 'Balls to the Wall'}
{'AlbumId': 3, 'GenreId': 1, 'TrackId': 3, 'Name': 'Fast As a Shark', 'MediaTypeId': 2, 'Composer': 'F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman', 'Milliseconds': 230619, 'Bytes': 3990994, 'UnitPrice': 0.99} {'ArtistId': 2, 'AlbumId': 3, 'Title': 'Restless and Wild'}
{'AlbumId': 3, 'GenreId': 1, 'TrackId': 4, 'Name': 'Restless and Wild', 'MediaTypeId': 2, 'Composer': 'F. Baltes, R.A. Smith-Diesel, S. Kaufman, U. Dirkscneider & W. Hoffman', 'Milliseconds': 252051, 'Bytes': 4331779, 'UnitPrice': 0.99} {'ArtistId': 2, 'AlbumId': 3, 'Title': 'Restless and Wild'}
{'AlbumId': 3, 'GenreId': 1, 'TrackId': 5, 'Name': 'Princess of the Dawn', 'MediaTypeId': 2, 'Composer': 'Deaffy & R.A. Smith-Diesel', 'Milliseconds': 375418, 'Bytes': 6290521, 'UnitPrice': 0.99} {'ArtistId': 2, 'AlbumId': 3, 'Title': 'Restless and Wild'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 15, 'Name': 'Go Down', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 331180, 'Bytes': 10847611, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 16, 'Name': 'Dog Eat Dog', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 215196, 'Bytes': 7032162, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 17, 'Name': 'Let There Be Rock', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 366654, 'Bytes': 12021261, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 18, 'Name': 'Bad Boy Boogie', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 267728, 'Bytes': 8776140, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 19, 'Name': 'Problem Child', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 325041, 'Bytes': 10617116, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 20, 'Name': 'Overdose', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 369319, 'Bytes': 12066294, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 21, 'Name': "Hell Ain't A Bad Place To Be", 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 254380, 'Bytes': 8331286, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 22, 'Name': 'Whole Lotta Rosie', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 323761, 'Bytes': 10547154, 'UnitPrice': 0.99} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 23, 'Name': 'Walk On Water', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw', 'Milliseconds': 295680, 'Bytes': 9719579, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 24, 'Name': 'Love In An Elevator', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry', 'Milliseconds': 321828, 'Bytes': 10552051, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 25, 'Name': 'Rag Doll', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Jim Vallance, Holly Knight', 'Milliseconds': 264698, 'Bytes': 8675345, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 26, 'Name': 'What It Takes', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Desmond Child', 'Milliseconds': 310622, 'Bytes': 10144730, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 27, 'Name': 'Dude (Looks Like A Lady)', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Desmond Child', 'Milliseconds': 264855, 'Bytes': 8679940, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 28, 'Name': "Janie's Got A Gun", 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Tom Hamilton', 'Milliseconds': 330736, 'Bytes': 10869391, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 29, 'Name': "Cryin'", 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Taylor Rhodes', 'Milliseconds': 309263, 'Bytes': 10056995, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 30, 'Name': 'Amazing', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Richie Supa', 'Milliseconds': 356519, 'Bytes': 11616195, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 31, 'Name': 'Blind Man', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Taylor Rhodes', 'Milliseconds': 240718, 'Bytes': 7877453, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 32, 'Name': 'Deuces Are Wild', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Jim Vallance', 'Milliseconds': 215875, 'Bytes': 7074167, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 33, 'Name': 'The Other Side', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Jim Vallance', 'Milliseconds': 244375, 'Bytes': 7983270, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 34, 'Name': 'Crazy', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Desmond Child', 'Milliseconds': 316656, 'Bytes': 10402398, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 35, 'Name': 'Eat The Rich', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Jim Vallance', 'Milliseconds': 251036, 'Bytes': 8262039, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 36, 'Name': 'Angel', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Desmond Child', 'Milliseconds': 307617, 'Bytes': 9989331, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 37, 'Name': "Livin' On The Edge", 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Mark Hudson', 'Milliseconds': 381231, 'Bytes': 12374569, 'UnitPrice': 0.99} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 38, 'Name': 'All I Really Want', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 284891, 'Bytes': 9375567, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 39, 'Name': 'You Oughta Know', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 249234, 'Bytes': 8196916, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 40, 'Name': 'Perfect', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 188133, 'Bytes': 6145404, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 41, 'Name': 'Hand In My Pocket', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 221570, 'Bytes': 7224246, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 42, 'Name': 'Right Through You', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 176117, 'Bytes': 5793082, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 43, 'Name': 'Forgiven', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 300355, 'Bytes': 9753256, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 44, 'Name': 'You Learn', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 239699, 'Bytes': 7824837, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 45, 'Name': 'Head Over Feet', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 267493, 'Bytes': 8758008, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 46, 'Name': 'Mary Jane', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 280607, 'Bytes': 9163588, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 47, 'Name': 'Ironic', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 229825, 'Bytes': 7598866, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 48, 'Name': 'Not The Doctor', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 227631, 'Bytes': 7604601, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 49, 'Name': 'Wake Up', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 293485, 'Bytes': 9703359, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 50, 'Name': 'You Oughta Know (Alternate)', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 491885, 'Bytes': 16008629, 'UnitPrice': 0.99} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 51, 'Name': 'We Die Young', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 152084, 'Bytes': 4925362, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 52, 'Name': 'Man In The Box', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Layne Staley', 'Milliseconds': 286641, 'Bytes': 9310272, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 53, 'Name': 'Sea Of Sorrow', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 349831, 'Bytes': 11316328, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 54, 'Name': 'Bleed The Freak', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 241946, 'Bytes': 7847716, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 55, 'Name': "I Can't Remember", 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Layne Staley', 'Milliseconds': 222955, 'Bytes': 7302550, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 56, 'Name': 'Love, Hate, Love', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Layne Staley', 'Milliseconds': 387134, 'Bytes': 12575396, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 57, 'Name': "It Ain't Like That", 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Michael Starr, Sean Kinney', 'Milliseconds': 277577, 'Bytes': 8993793, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 58, 'Name': 'Sunshine', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 284969, 'Bytes': 9216057, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 59, 'Name': 'Put You Down', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 196231, 'Bytes': 6420530, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 60, 'Name': 'Confusion', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Michael Starr, Layne Staley', 'Milliseconds': 344163, 'Bytes': 11183647, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 61, 'Name': 'I Know Somethin (Bout You)', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 261955, 'Bytes': 8497788, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 62, 'Name': 'Real Thing', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Layne Staley', 'Milliseconds': 243879, 'Bytes': 7937731, 'UnitPrice': 0.99} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 63, 'Name': 'Desafinado', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 185338, 'Bytes': 5990473, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 64, 'Name': 'Garota De Ipanema', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 285048, 'Bytes': 9348428, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 65, 'Name': 'Samba De Uma Nota Só (One Note Samba)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 137273, 'Bytes': 4535401, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 66, 'Name': 'Por Causa De Você', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 169900, 'Bytes': 5536496, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 67, 'Name': 'Ligia', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 251977, 'Bytes': 8226934, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 68, 'Name': 'Fotografia', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 129227, 'Bytes': 4198774, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 69, 'Name': 'Dindi (Dindi)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 253178, 'Bytes': 8149148, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 70, 'Name': 'Se Todos Fossem Iguais A Você (Instrumental)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 134948, 'Bytes': 4393377, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 71, 'Name': 'Falando De Amor', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 219663, 'Bytes': 7121735, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 72, 'Name': 'Angela', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 169508, 'Bytes': 5574957, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 73, 'Name': 'Corcovado (Quiet Nights Of Quiet Stars)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 205662, 'Bytes': 6687994, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 74, 'Name': 'Outra Vez', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 126511, 'Bytes': 4110053, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 75, 'Name': 'O Boto (Bôto)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 366837, 'Bytes': 12089673, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 76, 'Name': 'Canta, Canta Mais', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 271856, 'Bytes': 8719426, 'UnitPrice': 0.99} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 77, 'Name': 'Enter Sandman', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 221701, 'Bytes': 7286305, 'UnitPrice': 0.99} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 78, 'Name': 'Master Of Puppets', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 436453, 'Bytes': 14375310, 'UnitPrice': 0.99} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 79, 'Name': 'Harvester Of Sorrow', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 374543, 'Bytes': 12372536, 'UnitPrice': 0.99} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 80, 'Name': 'The Unforgiven', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 322925, 'Bytes': 10422447, 'UnitPrice': 0.99} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 81, 'Name': 'Sad But True', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 288208, 'Bytes': 9405526, 'UnitPrice': 0.99} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 82, 'Name': 'Creeping Death', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 308035, 'Bytes': 10110980, 'UnitPrice': 0.99} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 83, 'Name': 'Wherever I May Roam', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 369345, 'Bytes': 12033110, 'UnitPrice': 0.99} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 84, 'Name': 'Welcome Home (Sanitarium)', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 350197, 'Bytes': 11406431, 'UnitPrice': 0.99} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 85, 'Name': 'Cochise', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 222380, 'Bytes': 5339931, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 86, 'Name': 'Show Me How to Live', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 277890, 'Bytes': 6672176, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 87, 'Name': 'Gasoline', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 279457, 'Bytes': 6709793, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 88, 'Name': 'What You Are', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 249391, 'Bytes': 5988186, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 89, 'Name': 'Like a Stone', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 294034, 'Bytes': 7059624, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 90, 'Name': 'Set It Off', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 263262, 'Bytes': 6321091, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 91, 'Name': 'Shadow on the Sun', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 343457, 'Bytes': 8245793, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 92, 'Name': 'I am the Highway', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 334942, 'Bytes': 8041411, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 93, 'Name': 'Exploder', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 206053, 'Bytes': 4948095, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 94, 'Name': 'Hypnotize', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 206628, 'Bytes': 4961887, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 95, 'Name': "Bring'em Back Alive", 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 329534, 'Bytes': 7911634, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 96, 'Name': 'Light My Way', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 303595, 'Bytes': 7289084, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 97, 'Name': 'Getaway Car', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 299598, 'Bytes': 7193162, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 98, 'Name': 'The Last Remaining Light', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 317492, 'Bytes': 7622615, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 99, 'Name': 'Your Time Has Come', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 255529, 'Bytes': 8273592, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 100, 'Name': 'Out Of Exile', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 291291, 'Bytes': 9506571, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 101, 'Name': 'Be Yourself', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 279484, 'Bytes': 9106160, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 102, 'Name': "Doesn't Remind Me", 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 255869, 'Bytes': 8357387, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 103, 'Name': 'Drown Me Slowly', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 233691, 'Bytes': 7609178, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 104, 'Name': "Heaven's Dead", 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 276688, 'Bytes': 9006158, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 105, 'Name': 'The Worm', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 237714, 'Bytes': 7710800, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 106, 'Name': 'Man Or Animal', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 233195, 'Bytes': 7542942, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 107, 'Name': 'Yesterday To Tomorrow', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 273763, 'Bytes': 8944205, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 108, 'Name': 'Dandelion', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 278125, 'Bytes': 9003592, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 109, 'Name': '#1 Zero', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 299102, 'Bytes': 9731988, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 110, 'Name': 'The Curse', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 309786, 'Bytes': 10029406, 'UnitPrice': 0.99} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 111, 'Name': 'Money', 'MediaTypeId': 1, 'Composer': 'Berry Gordy, Jr./Janie Bradford', 'Milliseconds': 147591, 'Bytes': 2365897, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 112, 'Name': 'Long Tall Sally', 'MediaTypeId': 1, 'Composer': 'Enotris Johnson/Little Richard/Robert "Bumps" Blackwell', 'Milliseconds': 106396, 'Bytes': 1707084, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 113, 'Name': 'Bad Boy', 'MediaTypeId': 1, 'Composer': 'Larry Williams', 'Milliseconds': 116088, 'Bytes': 1862126, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 114, 'Name': 'Twist And Shout', 'MediaTypeId': 1, 'Composer': 'Bert Russell/Phil Medley', 'Milliseconds': 161123, 'Bytes': 2582553, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 115, 'Name': 'Please Mr. Postman', 'MediaTypeId': 1, 'Composer': 'Brian Holland/Freddie Gorman/Georgia Dobbins/Robert Bateman/William Garrett', 'Milliseconds': 137639, 'Bytes': 2206986, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 116, 'Name': "C'Mon Everybody", 'MediaTypeId': 1, 'Composer': 'Eddie Cochran/Jerry Capehart', 'Milliseconds': 140199, 'Bytes': 2247846, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 117, 'Name': "Rock 'N' Roll Music", 'MediaTypeId': 1, 'Composer': 'Chuck Berry', 'Milliseconds': 141923, 'Bytes': 2276788, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 118, 'Name': 'Slow Down', 'MediaTypeId': 1, 'Composer': 'Larry Williams', 'Milliseconds': 163265, 'Bytes': 2616981, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 119, 'Name': 'Roadrunner', 'MediaTypeId': 1, 'Composer': 'Bo Diddley', 'Milliseconds': 143595, 'Bytes': 2301989, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 120, 'Name': 'Carol', 'MediaTypeId': 1, 'Composer': 'Chuck Berry', 'Milliseconds': 143830, 'Bytes': 2306019, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 121, 'Name': 'Good Golly Miss Molly', 'MediaTypeId': 1, 'Composer': 'Little Richard', 'Milliseconds': 106266, 'Bytes': 1704918, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 122, 'Name': '20 Flight Rock', 'MediaTypeId': 1, 'Composer': 'Ned Fairchild', 'Milliseconds': 107807, 'Bytes': 1299960, 'UnitPrice': 0.99} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 123, 'Name': 'Quadrant', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 261851, 'Bytes': 8538199, 'UnitPrice': 0.99} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 124, 'Name': "Snoopy's search-Red baron", 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 456071, 'Bytes': 15075616, 'UnitPrice': 0.99} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 125, 'Name': 'Spanish moss-"A sound portrait"-Spanish moss', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 248084, 'Bytes': 8217867, 'UnitPrice': 0.99} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 126, 'Name': 'Moon germs', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 294060, 'Bytes': 9714812, 'UnitPrice': 0.99} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 127, 'Name': 'Stratus', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 582086, 'Bytes': 19115680, 'UnitPrice': 0.99} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 128, 'Name': 'The pleasant pheasant', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 318066, 'Bytes': 10630578, 'UnitPrice': 0.99} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 129, 'Name': 'Solo-Panhandler', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 246151, 'Bytes': 8230661, 'UnitPrice': 0.99} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 130, 'Name': 'Do what cha wanna', 'MediaTypeId': 1, 'Composer': 'George Duke', 'Milliseconds': 274155, 'Bytes': 9018565, 'UnitPrice': 0.99} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 131, 'Name': 'Intro/ Low Down', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 323683, 'Bytes': 10642901, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 132, 'Name': '13 Years Of Grief', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 246987, 'Bytes': 8137421, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 133, 'Name': 'Stronger Than Death', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 300747, 'Bytes': 9869647, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 134, 'Name': 'All For You', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 235833, 'Bytes': 7726948, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 135, 'Name': 'Super Terrorizer', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 319373, 'Bytes': 10513905, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 136, 'Name': 'Phoney Smile Fake Hellos', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 273606, 'Bytes': 9011701, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 137, 'Name': 'Lost My Better Half', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 284081, 'Bytes': 9355309, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 138, 'Name': 'Bored To Tears', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 247327, 'Bytes': 8130090, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 139, 'Name': 'A.N.D.R.O.T.A.Z.', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 266266, 'Bytes': 8574746, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 140, 'Name': 'Born To Booze', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 282122, 'Bytes': 9257358, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 141, 'Name': 'World Of Trouble', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 359157, 'Bytes': 11820932, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 142, 'Name': 'No More Tears', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 555075, 'Bytes': 18041629, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 143, 'Name': 'The Begining... At Last', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 365662, 'Bytes': 11965109, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 144, 'Name': 'Heart Of Gold', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 194873, 'Bytes': 6417460, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 145, 'Name': 'Snowblind', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 420022, 'Bytes': 13842549, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 146, 'Name': 'Like A Bird', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 276532, 'Bytes': 9115657, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 147, 'Name': 'Blood In The Wall', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 284368, 'Bytes': 9359475, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 148, 'Name': 'The Beginning...At Last', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 271960, 'Bytes': 8975814, 'UnitPrice': 0.99} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 149, 'Name': 'Black Sabbath', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 382066, 'Bytes': 12440200, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 150, 'Name': 'The Wizard', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 264829, 'Bytes': 8646737, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 151, 'Name': 'Behind The Wall Of Sleep', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 217573, 'Bytes': 7169049, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 152, 'Name': 'N.I.B.', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 368770, 'Bytes': 12029390, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 153, 'Name': 'Evil Woman', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 204930, 'Bytes': 6655170, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 154, 'Name': 'Sleeping Village', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 644571, 'Bytes': 21128525, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 155, 'Name': 'Warning', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 212062, 'Bytes': 6893363, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 156, 'Name': 'Wheels Of Confusion / The Straightener', 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 494524, 'Bytes': 16065830, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 157, 'Name': "Tomorrow's Dream", 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 192496, 'Bytes': 6252071, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 158, 'Name': 'Changes', 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 286275, 'Bytes': 9175517, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 159, 'Name': 'FX', 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 103157, 'Bytes': 3331776, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 160, 'Name': 'Supernaut', 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 285779, 'Bytes': 9245971, 'UnitPrice': 0.99} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'}
...

The above table contains two columns, each one a struct. The structs are the rows of the two source tables, put side by side.

Implicit Join on multiple tables

We can make joining shorter and more convenient, by declaring the tables with foreign keys.

We'll manually declare the relevant columns, and use ... to auto-declare the rest.

In [8]:
table albums {
	ArtistId: artists.ArtistId
	...
}

table tracks {
	AlbumId: albums.AlbumId,
	GenreId: genres.GenreId
	...
}

Now, we can easily join the tables without having to specify their shared columns.

(Don't worry, if there was any ambiguity, Preql would throw an error rather than guess.)

This call to join() below, creates four columns of structs, one for each table:

In [5]:
join(t: tracks, art: artists, alb: albums, g: genres)
table join6, =3503
t art alb g
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 1, 'Name': 'For Those About To Rock (We Salute You)', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 343719, 'Bytes': 11170334, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 6, 'Name': 'Put The Finger On You', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 205662, 'Bytes': 6713451, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 7, 'Name': "Let's Get It Up", 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 233926, 'Bytes': 7636561, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 8, 'Name': 'Inject The Venom', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 210834, 'Bytes': 6852860, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 9, 'Name': 'Snowballed', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 203102, 'Bytes': 6599424, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 10, 'Name': 'Evil Walks', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 263497, 'Bytes': 8611245, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 11, 'Name': 'C.O.D.', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 199836, 'Bytes': 6566314, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 12, 'Name': 'Breaking The Rules', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 263288, 'Bytes': 8596840, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 13, 'Name': 'Night Of The Long Knives', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 205688, 'Bytes': 6706347, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 1, 'GenreId': 1, 'TrackId': 14, 'Name': 'Spellbound', 'MediaTypeId': 1, 'Composer': 'Angus Young, Malcolm Young, Brian Johnson', 'Milliseconds': 270863, 'Bytes': 8817038, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 1, 'Title': 'For Those About To Rock We Salute You'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 2, 'GenreId': 1, 'TrackId': 2, 'Name': 'Balls to the Wall', 'MediaTypeId': 2, 'Composer': None, 'Milliseconds': 342562, 'Bytes': 5510424, 'UnitPrice': 0.99} {'ArtistId': 2, 'Name': 'Accept'} {'ArtistId': 2, 'AlbumId': 2, 'Title': 'Balls to the Wall'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 3, 'GenreId': 1, 'TrackId': 3, 'Name': 'Fast As a Shark', 'MediaTypeId': 2, 'Composer': 'F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman', 'Milliseconds': 230619, 'Bytes': 3990994, 'UnitPrice': 0.99} {'ArtistId': 2, 'Name': 'Accept'} {'ArtistId': 2, 'AlbumId': 3, 'Title': 'Restless and Wild'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 3, 'GenreId': 1, 'TrackId': 4, 'Name': 'Restless and Wild', 'MediaTypeId': 2, 'Composer': 'F. Baltes, R.A. Smith-Diesel, S. Kaufman, U. Dirkscneider & W. Hoffman', 'Milliseconds': 252051, 'Bytes': 4331779, 'UnitPrice': 0.99} {'ArtistId': 2, 'Name': 'Accept'} {'ArtistId': 2, 'AlbumId': 3, 'Title': 'Restless and Wild'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 3, 'GenreId': 1, 'TrackId': 5, 'Name': 'Princess of the Dawn', 'MediaTypeId': 2, 'Composer': 'Deaffy & R.A. Smith-Diesel', 'Milliseconds': 375418, 'Bytes': 6290521, 'UnitPrice': 0.99} {'ArtistId': 2, 'Name': 'Accept'} {'ArtistId': 2, 'AlbumId': 3, 'Title': 'Restless and Wild'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 15, 'Name': 'Go Down', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 331180, 'Bytes': 10847611, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 16, 'Name': 'Dog Eat Dog', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 215196, 'Bytes': 7032162, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 17, 'Name': 'Let There Be Rock', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 366654, 'Bytes': 12021261, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 18, 'Name': 'Bad Boy Boogie', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 267728, 'Bytes': 8776140, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 19, 'Name': 'Problem Child', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 325041, 'Bytes': 10617116, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 20, 'Name': 'Overdose', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 369319, 'Bytes': 12066294, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 21, 'Name': "Hell Ain't A Bad Place To Be", 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 254380, 'Bytes': 8331286, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 4, 'GenreId': 1, 'TrackId': 22, 'Name': 'Whole Lotta Rosie', 'MediaTypeId': 1, 'Composer': 'AC/DC', 'Milliseconds': 323761, 'Bytes': 10547154, 'UnitPrice': 0.99} {'ArtistId': 1, 'Name': 'AC/DC'} {'ArtistId': 1, 'AlbumId': 4, 'Title': 'Let There Be Rock'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 23, 'Name': 'Walk On Water', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw', 'Milliseconds': 295680, 'Bytes': 9719579, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 24, 'Name': 'Love In An Elevator', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry', 'Milliseconds': 321828, 'Bytes': 10552051, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 25, 'Name': 'Rag Doll', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Jim Vallance, Holly Knight', 'Milliseconds': 264698, 'Bytes': 8675345, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 26, 'Name': 'What It Takes', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Desmond Child', 'Milliseconds': 310622, 'Bytes': 10144730, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 27, 'Name': 'Dude (Looks Like A Lady)', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Desmond Child', 'Milliseconds': 264855, 'Bytes': 8679940, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 28, 'Name': "Janie's Got A Gun", 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Tom Hamilton', 'Milliseconds': 330736, 'Bytes': 10869391, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 29, 'Name': "Cryin'", 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Taylor Rhodes', 'Milliseconds': 309263, 'Bytes': 10056995, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 30, 'Name': 'Amazing', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Richie Supa', 'Milliseconds': 356519, 'Bytes': 11616195, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 31, 'Name': 'Blind Man', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Taylor Rhodes', 'Milliseconds': 240718, 'Bytes': 7877453, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 32, 'Name': 'Deuces Are Wild', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Jim Vallance', 'Milliseconds': 215875, 'Bytes': 7074167, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 33, 'Name': 'The Other Side', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Jim Vallance', 'Milliseconds': 244375, 'Bytes': 7983270, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 34, 'Name': 'Crazy', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Desmond Child', 'Milliseconds': 316656, 'Bytes': 10402398, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 35, 'Name': 'Eat The Rich', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Jim Vallance', 'Milliseconds': 251036, 'Bytes': 8262039, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 36, 'Name': 'Angel', 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Desmond Child', 'Milliseconds': 307617, 'Bytes': 9989331, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 5, 'GenreId': 1, 'TrackId': 37, 'Name': "Livin' On The Edge", 'MediaTypeId': 1, 'Composer': 'Steven Tyler, Joe Perry, Mark Hudson', 'Milliseconds': 381231, 'Bytes': 12374569, 'UnitPrice': 0.99} {'ArtistId': 3, 'Name': 'Aerosmith'} {'ArtistId': 3, 'AlbumId': 5, 'Title': 'Big Ones'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 38, 'Name': 'All I Really Want', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 284891, 'Bytes': 9375567, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 39, 'Name': 'You Oughta Know', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 249234, 'Bytes': 8196916, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 40, 'Name': 'Perfect', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 188133, 'Bytes': 6145404, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 41, 'Name': 'Hand In My Pocket', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 221570, 'Bytes': 7224246, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 42, 'Name': 'Right Through You', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 176117, 'Bytes': 5793082, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 43, 'Name': 'Forgiven', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 300355, 'Bytes': 9753256, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 44, 'Name': 'You Learn', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 239699, 'Bytes': 7824837, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 45, 'Name': 'Head Over Feet', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 267493, 'Bytes': 8758008, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 46, 'Name': 'Mary Jane', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 280607, 'Bytes': 9163588, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 47, 'Name': 'Ironic', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 229825, 'Bytes': 7598866, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 48, 'Name': 'Not The Doctor', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 227631, 'Bytes': 7604601, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 49, 'Name': 'Wake Up', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 293485, 'Bytes': 9703359, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 6, 'GenreId': 1, 'TrackId': 50, 'Name': 'You Oughta Know (Alternate)', 'MediaTypeId': 1, 'Composer': 'Alanis Morissette & Glenn Ballard', 'Milliseconds': 491885, 'Bytes': 16008629, 'UnitPrice': 0.99} {'ArtistId': 4, 'Name': 'Alanis Morissette'} {'ArtistId': 4, 'AlbumId': 6, 'Title': 'Jagged Little Pill'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 51, 'Name': 'We Die Young', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 152084, 'Bytes': 4925362, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 52, 'Name': 'Man In The Box', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Layne Staley', 'Milliseconds': 286641, 'Bytes': 9310272, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 53, 'Name': 'Sea Of Sorrow', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 349831, 'Bytes': 11316328, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 54, 'Name': 'Bleed The Freak', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 241946, 'Bytes': 7847716, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 55, 'Name': "I Can't Remember", 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Layne Staley', 'Milliseconds': 222955, 'Bytes': 7302550, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 56, 'Name': 'Love, Hate, Love', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Layne Staley', 'Milliseconds': 387134, 'Bytes': 12575396, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 57, 'Name': "It Ain't Like That", 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Michael Starr, Sean Kinney', 'Milliseconds': 277577, 'Bytes': 8993793, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 58, 'Name': 'Sunshine', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 284969, 'Bytes': 9216057, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 59, 'Name': 'Put You Down', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 196231, 'Bytes': 6420530, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 60, 'Name': 'Confusion', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Michael Starr, Layne Staley', 'Milliseconds': 344163, 'Bytes': 11183647, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 61, 'Name': 'I Know Somethin (Bout You)', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell', 'Milliseconds': 261955, 'Bytes': 8497788, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 7, 'GenreId': 1, 'TrackId': 62, 'Name': 'Real Thing', 'MediaTypeId': 1, 'Composer': 'Jerry Cantrell, Layne Staley', 'Milliseconds': 243879, 'Bytes': 7937731, 'UnitPrice': 0.99} {'ArtistId': 5, 'Name': 'Alice In Chains'} {'ArtistId': 5, 'AlbumId': 7, 'Title': 'Facelift'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 63, 'Name': 'Desafinado', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 185338, 'Bytes': 5990473, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 64, 'Name': 'Garota De Ipanema', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 285048, 'Bytes': 9348428, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 65, 'Name': 'Samba De Uma Nota Só (One Note Samba)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 137273, 'Bytes': 4535401, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 66, 'Name': 'Por Causa De Você', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 169900, 'Bytes': 5536496, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 67, 'Name': 'Ligia', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 251977, 'Bytes': 8226934, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 68, 'Name': 'Fotografia', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 129227, 'Bytes': 4198774, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 69, 'Name': 'Dindi (Dindi)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 253178, 'Bytes': 8149148, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 70, 'Name': 'Se Todos Fossem Iguais A Você (Instrumental)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 134948, 'Bytes': 4393377, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 71, 'Name': 'Falando De Amor', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 219663, 'Bytes': 7121735, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 72, 'Name': 'Angela', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 169508, 'Bytes': 5574957, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 73, 'Name': 'Corcovado (Quiet Nights Of Quiet Stars)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 205662, 'Bytes': 6687994, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 74, 'Name': 'Outra Vez', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 126511, 'Bytes': 4110053, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 75, 'Name': 'O Boto (Bôto)', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 366837, 'Bytes': 12089673, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 8, 'GenreId': 2, 'TrackId': 76, 'Name': 'Canta, Canta Mais', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 271856, 'Bytes': 8719426, 'UnitPrice': 0.99} {'ArtistId': 6, 'Name': 'Antônio Carlos Jobim'} {'ArtistId': 6, 'AlbumId': 8, 'Title': 'Warner 25 Anos'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 77, 'Name': 'Enter Sandman', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 221701, 'Bytes': 7286305, 'UnitPrice': 0.99} {'ArtistId': 7, 'Name': 'Apocalyptica'} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 78, 'Name': 'Master Of Puppets', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 436453, 'Bytes': 14375310, 'UnitPrice': 0.99} {'ArtistId': 7, 'Name': 'Apocalyptica'} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 79, 'Name': 'Harvester Of Sorrow', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 374543, 'Bytes': 12372536, 'UnitPrice': 0.99} {'ArtistId': 7, 'Name': 'Apocalyptica'} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 80, 'Name': 'The Unforgiven', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 322925, 'Bytes': 10422447, 'UnitPrice': 0.99} {'ArtistId': 7, 'Name': 'Apocalyptica'} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 81, 'Name': 'Sad But True', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 288208, 'Bytes': 9405526, 'UnitPrice': 0.99} {'ArtistId': 7, 'Name': 'Apocalyptica'} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 82, 'Name': 'Creeping Death', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 308035, 'Bytes': 10110980, 'UnitPrice': 0.99} {'ArtistId': 7, 'Name': 'Apocalyptica'} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 83, 'Name': 'Wherever I May Roam', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 369345, 'Bytes': 12033110, 'UnitPrice': 0.99} {'ArtistId': 7, 'Name': 'Apocalyptica'} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 9, 'GenreId': 3, 'TrackId': 84, 'Name': 'Welcome Home (Sanitarium)', 'MediaTypeId': 1, 'Composer': 'Apocalyptica', 'Milliseconds': 350197, 'Bytes': 11406431, 'UnitPrice': 0.99} {'ArtistId': 7, 'Name': 'Apocalyptica'} {'ArtistId': 7, 'AlbumId': 9, 'Title': 'Plays Metallica By Four Cellos'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 85, 'Name': 'Cochise', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 222380, 'Bytes': 5339931, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 86, 'Name': 'Show Me How to Live', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 277890, 'Bytes': 6672176, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 87, 'Name': 'Gasoline', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 279457, 'Bytes': 6709793, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 88, 'Name': 'What You Are', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 249391, 'Bytes': 5988186, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 89, 'Name': 'Like a Stone', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 294034, 'Bytes': 7059624, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 90, 'Name': 'Set It Off', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 263262, 'Bytes': 6321091, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 91, 'Name': 'Shadow on the Sun', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 343457, 'Bytes': 8245793, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 92, 'Name': 'I am the Highway', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 334942, 'Bytes': 8041411, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 93, 'Name': 'Exploder', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 206053, 'Bytes': 4948095, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 94, 'Name': 'Hypnotize', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 206628, 'Bytes': 4961887, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 95, 'Name': "Bring'em Back Alive", 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 329534, 'Bytes': 7911634, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 96, 'Name': 'Light My Way', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 303595, 'Bytes': 7289084, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 97, 'Name': 'Getaway Car', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 299598, 'Bytes': 7193162, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 10, 'GenreId': 1, 'TrackId': 98, 'Name': 'The Last Remaining Light', 'MediaTypeId': 1, 'Composer': 'Audioslave/Chris Cornell', 'Milliseconds': 317492, 'Bytes': 7622615, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 10, 'Title': 'Audioslave'} {'GenreId': 1, 'Name': 'Rock'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 99, 'Name': 'Your Time Has Come', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 255529, 'Bytes': 8273592, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 100, 'Name': 'Out Of Exile', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 291291, 'Bytes': 9506571, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 101, 'Name': 'Be Yourself', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 279484, 'Bytes': 9106160, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 102, 'Name': "Doesn't Remind Me", 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 255869, 'Bytes': 8357387, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 103, 'Name': 'Drown Me Slowly', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 233691, 'Bytes': 7609178, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 104, 'Name': "Heaven's Dead", 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 276688, 'Bytes': 9006158, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 105, 'Name': 'The Worm', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 237714, 'Bytes': 7710800, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 106, 'Name': 'Man Or Animal', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 233195, 'Bytes': 7542942, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 107, 'Name': 'Yesterday To Tomorrow', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 273763, 'Bytes': 8944205, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 108, 'Name': 'Dandelion', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 278125, 'Bytes': 9003592, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 109, 'Name': '#1 Zero', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 299102, 'Bytes': 9731988, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 11, 'GenreId': 4, 'TrackId': 110, 'Name': 'The Curse', 'MediaTypeId': 1, 'Composer': 'Cornell, Commerford, Morello, Wilk', 'Milliseconds': 309786, 'Bytes': 10029406, 'UnitPrice': 0.99} {'ArtistId': 8, 'Name': 'Audioslave'} {'ArtistId': 8, 'AlbumId': 11, 'Title': 'Out Of Exile'} {'GenreId': 4, 'Name': 'Alternative & Punk'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 111, 'Name': 'Money', 'MediaTypeId': 1, 'Composer': 'Berry Gordy, Jr./Janie Bradford', 'Milliseconds': 147591, 'Bytes': 2365897, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 112, 'Name': 'Long Tall Sally', 'MediaTypeId': 1, 'Composer': 'Enotris Johnson/Little Richard/Robert "Bumps" Blackwell', 'Milliseconds': 106396, 'Bytes': 1707084, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 113, 'Name': 'Bad Boy', 'MediaTypeId': 1, 'Composer': 'Larry Williams', 'Milliseconds': 116088, 'Bytes': 1862126, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 114, 'Name': 'Twist And Shout', 'MediaTypeId': 1, 'Composer': 'Bert Russell/Phil Medley', 'Milliseconds': 161123, 'Bytes': 2582553, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 115, 'Name': 'Please Mr. Postman', 'MediaTypeId': 1, 'Composer': 'Brian Holland/Freddie Gorman/Georgia Dobbins/Robert Bateman/William Garrett', 'Milliseconds': 137639, 'Bytes': 2206986, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 116, 'Name': "C'Mon Everybody", 'MediaTypeId': 1, 'Composer': 'Eddie Cochran/Jerry Capehart', 'Milliseconds': 140199, 'Bytes': 2247846, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 117, 'Name': "Rock 'N' Roll Music", 'MediaTypeId': 1, 'Composer': 'Chuck Berry', 'Milliseconds': 141923, 'Bytes': 2276788, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 118, 'Name': 'Slow Down', 'MediaTypeId': 1, 'Composer': 'Larry Williams', 'Milliseconds': 163265, 'Bytes': 2616981, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 119, 'Name': 'Roadrunner', 'MediaTypeId': 1, 'Composer': 'Bo Diddley', 'Milliseconds': 143595, 'Bytes': 2301989, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 120, 'Name': 'Carol', 'MediaTypeId': 1, 'Composer': 'Chuck Berry', 'Milliseconds': 143830, 'Bytes': 2306019, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 121, 'Name': 'Good Golly Miss Molly', 'MediaTypeId': 1, 'Composer': 'Little Richard', 'Milliseconds': 106266, 'Bytes': 1704918, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 12, 'GenreId': 5, 'TrackId': 122, 'Name': '20 Flight Rock', 'MediaTypeId': 1, 'Composer': 'Ned Fairchild', 'Milliseconds': 107807, 'Bytes': 1299960, 'UnitPrice': 0.99} {'ArtistId': 9, 'Name': 'BackBeat'} {'ArtistId': 9, 'AlbumId': 12, 'Title': 'BackBeat Soundtrack'} {'GenreId': 5, 'Name': 'Rock And Roll'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 123, 'Name': 'Quadrant', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 261851, 'Bytes': 8538199, 'UnitPrice': 0.99} {'ArtistId': 10, 'Name': 'Billy Cobham'} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 124, 'Name': "Snoopy's search-Red baron", 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 456071, 'Bytes': 15075616, 'UnitPrice': 0.99} {'ArtistId': 10, 'Name': 'Billy Cobham'} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 125, 'Name': 'Spanish moss-"A sound portrait"-Spanish moss', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 248084, 'Bytes': 8217867, 'UnitPrice': 0.99} {'ArtistId': 10, 'Name': 'Billy Cobham'} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 126, 'Name': 'Moon germs', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 294060, 'Bytes': 9714812, 'UnitPrice': 0.99} {'ArtistId': 10, 'Name': 'Billy Cobham'} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 127, 'Name': 'Stratus', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 582086, 'Bytes': 19115680, 'UnitPrice': 0.99} {'ArtistId': 10, 'Name': 'Billy Cobham'} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 128, 'Name': 'The pleasant pheasant', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 318066, 'Bytes': 10630578, 'UnitPrice': 0.99} {'ArtistId': 10, 'Name': 'Billy Cobham'} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 129, 'Name': 'Solo-Panhandler', 'MediaTypeId': 1, 'Composer': 'Billy Cobham', 'Milliseconds': 246151, 'Bytes': 8230661, 'UnitPrice': 0.99} {'ArtistId': 10, 'Name': 'Billy Cobham'} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 13, 'GenreId': 2, 'TrackId': 130, 'Name': 'Do what cha wanna', 'MediaTypeId': 1, 'Composer': 'George Duke', 'Milliseconds': 274155, 'Bytes': 9018565, 'UnitPrice': 0.99} {'ArtistId': 10, 'Name': 'Billy Cobham'} {'ArtistId': 10, 'AlbumId': 13, 'Title': 'The Best Of Billy Cobham'} {'GenreId': 2, 'Name': 'Jazz'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 131, 'Name': 'Intro/ Low Down', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 323683, 'Bytes': 10642901, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 132, 'Name': '13 Years Of Grief', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 246987, 'Bytes': 8137421, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 133, 'Name': 'Stronger Than Death', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 300747, 'Bytes': 9869647, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 134, 'Name': 'All For You', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 235833, 'Bytes': 7726948, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 135, 'Name': 'Super Terrorizer', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 319373, 'Bytes': 10513905, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 136, 'Name': 'Phoney Smile Fake Hellos', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 273606, 'Bytes': 9011701, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 137, 'Name': 'Lost My Better Half', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 284081, 'Bytes': 9355309, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 138, 'Name': 'Bored To Tears', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 247327, 'Bytes': 8130090, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 139, 'Name': 'A.N.D.R.O.T.A.Z.', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 266266, 'Bytes': 8574746, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 140, 'Name': 'Born To Booze', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 282122, 'Bytes': 9257358, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 141, 'Name': 'World Of Trouble', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 359157, 'Bytes': 11820932, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 142, 'Name': 'No More Tears', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 555075, 'Bytes': 18041629, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 14, 'GenreId': 3, 'TrackId': 143, 'Name': 'The Begining... At Last', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 365662, 'Bytes': 11965109, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 14, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 1]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 144, 'Name': 'Heart Of Gold', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 194873, 'Bytes': 6417460, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 145, 'Name': 'Snowblind', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 420022, 'Bytes': 13842549, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 146, 'Name': 'Like A Bird', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 276532, 'Bytes': 9115657, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 147, 'Name': 'Blood In The Wall', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 284368, 'Bytes': 9359475, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 15, 'GenreId': 3, 'TrackId': 148, 'Name': 'The Beginning...At Last', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 271960, 'Bytes': 8975814, 'UnitPrice': 0.99} {'ArtistId': 11, 'Name': 'Black Label Society'} {'ArtistId': 11, 'AlbumId': 15, 'Title': 'Alcohol Fueled Brewtality Live! [Disc 2]'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 149, 'Name': 'Black Sabbath', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 382066, 'Bytes': 12440200, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 150, 'Name': 'The Wizard', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 264829, 'Bytes': 8646737, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 151, 'Name': 'Behind The Wall Of Sleep', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 217573, 'Bytes': 7169049, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 152, 'Name': 'N.I.B.', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 368770, 'Bytes': 12029390, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 153, 'Name': 'Evil Woman', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 204930, 'Bytes': 6655170, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 154, 'Name': 'Sleeping Village', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 644571, 'Bytes': 21128525, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 16, 'GenreId': 3, 'TrackId': 155, 'Name': 'Warning', 'MediaTypeId': 1, 'Composer': None, 'Milliseconds': 212062, 'Bytes': 6893363, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 16, 'Title': 'Black Sabbath'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 156, 'Name': 'Wheels Of Confusion / The Straightener', 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 494524, 'Bytes': 16065830, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 157, 'Name': "Tomorrow's Dream", 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 192496, 'Bytes': 6252071, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 158, 'Name': 'Changes', 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 286275, 'Bytes': 9175517, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 159, 'Name': 'FX', 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 103157, 'Bytes': 3331776, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'} {'GenreId': 3, 'Name': 'Metal'}
{'AlbumId': 17, 'GenreId': 3, 'TrackId': 160, 'Name': 'Supernaut', 'MediaTypeId': 1, 'Composer': 'Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne', 'Milliseconds': 285779, 'Bytes': 9245971, 'UnitPrice': 0.99} {'ArtistId': 12, 'Name': 'Black Sabbath'} {'ArtistId': 12, 'AlbumId': 17, 'Title': 'Black Sabbath Vol. 4 (Remaster)'} {'GenreId': 3, 'Name': 'Metal'}
...

Selecting columns

For convenience, we might like to flatten those structs into a single table, and give it a name:

In [9]:
tracks_joined = join(art: artists, alb: albums, t: tracks, g: genres) {
	...t !GenreId !AlbumId !TrackId        // Take everything from `t` except the ids
	Artist: art.Name
	Album: alb.Title
	Genre: g.Name
}
table , =3503
Name MediaTypeId Composer Milliseconds Bytes UnitPrice Artist Album Genre
For Those About To Rock (We Salute You) 1 Angus Young, Malcolm Young, Brian Johnson 343719 11170334 0.99 AC/DC For Those About To Rock We Salute You Rock
Put The Finger On You 1 Angus Young, Malcolm Young, Brian Johnson 205662 6713451 0.99 AC/DC For Those About To Rock We Salute You Rock
Let's Get It Up 1 Angus Young, Malcolm Young, Brian Johnson 233926 7636561 0.99 AC/DC For Those About To Rock We Salute You Rock
Inject The Venom 1 Angus Young, Malcolm Young, Brian Johnson 210834 6852860 0.99 AC/DC For Those About To Rock We Salute You Rock
Snowballed 1 Angus Young, Malcolm Young, Brian Johnson 203102 6599424 0.99 AC/DC For Those About To Rock We Salute You Rock
Evil Walks 1 Angus Young, Malcolm Young, Brian Johnson 263497 8611245 0.99 AC/DC For Those About To Rock We Salute You Rock
C.O.D. 1 Angus Young, Malcolm Young, Brian Johnson 199836 6566314 0.99 AC/DC For Those About To Rock We Salute You Rock
Breaking The Rules 1 Angus Young, Malcolm Young, Brian Johnson 263288 8596840 0.99 AC/DC For Those About To Rock We Salute You Rock
Night Of The Long Knives 1 Angus Young, Malcolm Young, Brian Johnson 205688 6706347 0.99 AC/DC For Those About To Rock We Salute You Rock
Spellbound 1 Angus Young, Malcolm Young, Brian Johnson 270863 8817038 0.99 AC/DC For Those About To Rock We Salute You Rock
Balls to the Wall 2 None 342562 5510424 0.99 Accept Balls to the Wall Rock
Fast As a Shark 2 F. Baltes, S. Kaufman, U. Dirkscneider & W. Hoffman 230619 3990994 0.99 Accept Restless and Wild Rock
Restless and Wild 2 F. Baltes, R.A. Smith-Diesel, S. Kaufman, U. Dirkscneider & W. Hoffman 252051 4331779 0.99 Accept Restless and Wild Rock
Princess of the Dawn 2 Deaffy & R.A. Smith-Diesel 375418 6290521 0.99 Accept Restless and Wild Rock
Go Down 1 AC/DC 331180 10847611 0.99 AC/DC Let There Be Rock Rock
Dog Eat Dog 1 AC/DC 215196 7032162 0.99 AC/DC Let There Be Rock Rock
Let There Be Rock 1 AC/DC 366654 12021261 0.99 AC/DC Let There Be Rock Rock
Bad Boy Boogie 1 AC/DC 267728 8776140 0.99 AC/DC Let There Be Rock Rock
Problem Child 1 AC/DC 325041 10617116 0.99 AC/DC Let There Be Rock Rock
Overdose 1 AC/DC 369319 12066294 0.99 AC/DC Let There Be Rock Rock
Hell Ain't A Bad Place To Be 1 AC/DC 254380 8331286 0.99 AC/DC Let There Be Rock Rock
Whole Lotta Rosie 1 AC/DC 323761 10547154 0.99 AC/DC Let There Be Rock Rock
Walk On Water 1 Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw 295680 9719579 0.99 Aerosmith Big Ones Rock
Love In An Elevator 1 Steven Tyler, Joe Perry 321828 10552051 0.99 Aerosmith Big Ones Rock
Rag Doll 1 Steven Tyler, Joe Perry, Jim Vallance, Holly Knight 264698 8675345 0.99 Aerosmith Big Ones Rock
What It Takes 1 Steven Tyler, Joe Perry, Desmond Child 310622 10144730 0.99 Aerosmith Big Ones Rock
Dude (Looks Like A Lady) 1 Steven Tyler, Joe Perry, Desmond Child 264855 8679940 0.99 Aerosmith Big Ones Rock
Janie's Got A Gun 1 Steven Tyler, Tom Hamilton 330736 10869391 0.99 Aerosmith Big Ones Rock
Cryin' 1 Steven Tyler, Joe Perry, Taylor Rhodes 309263 10056995 0.99 Aerosmith Big Ones Rock
Amazing 1 Steven Tyler, Richie Supa 356519 11616195 0.99 Aerosmith Big Ones Rock
Blind Man 1 Steven Tyler, Joe Perry, Taylor Rhodes 240718 7877453 0.99 Aerosmith Big Ones Rock
Deuces Are Wild 1 Steven Tyler, Jim Vallance 215875 7074167 0.99 Aerosmith Big Ones Rock
The Other Side 1 Steven Tyler, Jim Vallance 244375 7983270 0.99 Aerosmith Big Ones Rock
Crazy 1 Steven Tyler, Joe Perry, Desmond Child 316656 10402398 0.99 Aerosmith Big Ones Rock
Eat The Rich 1 Steven Tyler, Joe Perry, Jim Vallance 251036 8262039 0.99 Aerosmith Big Ones Rock
Angel 1 Steven Tyler, Desmond Child 307617 9989331 0.99 Aerosmith Big Ones Rock
Livin' On The Edge 1 Steven Tyler, Joe Perry, Mark Hudson 381231 12374569 0.99 Aerosmith Big Ones Rock
All I Really Want 1 Alanis Morissette & Glenn Ballard 284891 9375567 0.99 Alanis Morissette Jagged Little Pill Rock
You Oughta Know 1 Alanis Morissette & Glenn Ballard 249234 8196916 0.99 Alanis Morissette Jagged Little Pill Rock
Perfect 1 Alanis Morissette & Glenn Ballard 188133 6145404 0.99 Alanis Morissette Jagged Little Pill Rock
Hand In My Pocket 1 Alanis Morissette & Glenn Ballard 221570 7224246 0.99 Alanis Morissette Jagged Little Pill Rock
Right Through You 1 Alanis Morissette & Glenn Ballard 176117 5793082 0.99 Alanis Morissette Jagged Little Pill Rock
Forgiven 1 Alanis Morissette & Glenn Ballard 300355 9753256 0.99 Alanis Morissette Jagged Little Pill Rock
You Learn 1 Alanis Morissette & Glenn Ballard 239699 7824837 0.99 Alanis Morissette Jagged Little Pill Rock
Head Over Feet 1 Alanis Morissette & Glenn Ballard 267493 8758008 0.99 Alanis Morissette Jagged Little Pill Rock
Mary Jane 1 Alanis Morissette & Glenn Ballard 280607 9163588 0.99 Alanis Morissette Jagged Little Pill Rock
Ironic 1 Alanis Morissette & Glenn Ballard 229825 7598866 0.99 Alanis Morissette Jagged Little Pill Rock
Not The Doctor 1 Alanis Morissette & Glenn Ballard 227631 7604601 0.99 Alanis Morissette Jagged Little Pill Rock
Wake Up 1 Alanis Morissette & Glenn Ballard 293485 9703359 0.99 Alanis Morissette Jagged Little Pill Rock
You Oughta Know (Alternate) 1 Alanis Morissette & Glenn Ballard 491885 16008629 0.99 Alanis Morissette Jagged Little Pill Rock
We Die Young 1 Jerry Cantrell 152084 4925362 0.99 Alice In Chains Facelift Rock
Man In The Box 1 Jerry Cantrell, Layne Staley 286641 9310272 0.99 Alice In Chains Facelift Rock
Sea Of Sorrow 1 Jerry Cantrell 349831 11316328 0.99 Alice In Chains Facelift Rock
Bleed The Freak 1 Jerry Cantrell 241946 7847716 0.99 Alice In Chains Facelift Rock
I Can't Remember 1 Jerry Cantrell, Layne Staley 222955 7302550 0.99 Alice In Chains Facelift Rock
Love, Hate, Love 1 Jerry Cantrell, Layne Staley 387134 12575396 0.99 Alice In Chains Facelift Rock
It Ain't Like That 1 Jerry Cantrell, Michael Starr, Sean Kinney 277577 8993793 0.99 Alice In Chains Facelift Rock
Sunshine 1 Jerry Cantrell 284969 9216057 0.99 Alice In Chains Facelift Rock
Put You Down 1 Jerry Cantrell 196231 6420530 0.99 Alice In Chains Facelift Rock
Confusion 1 Jerry Cantrell, Michael Starr, Layne Staley 344163 11183647 0.99 Alice In Chains Facelift Rock
I Know Somethin (Bout You) 1 Jerry Cantrell 261955 8497788 0.99 Alice In Chains Facelift Rock
Real Thing 1 Jerry Cantrell, Layne Staley 243879 7937731 0.99 Alice In Chains Facelift Rock
Desafinado 1 None 185338 5990473 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Garota De Ipanema 1 None 285048 9348428 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Samba De Uma Nota Só (One Note Samba) 1 None 137273 4535401 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Por Causa De Você 1 None 169900 5536496 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Ligia 1 None 251977 8226934 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Fotografia 1 None 129227 4198774 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Dindi (Dindi) 1 None 253178 8149148 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Se Todos Fossem Iguais A Você (Instrumental) 1 None 134948 4393377 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Falando De Amor 1 None 219663 7121735 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Angela 1 None 169508 5574957 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Corcovado (Quiet Nights Of Quiet Stars) 1 None 205662 6687994 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Outra Vez 1 None 126511 4110053 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
O Boto (Bôto) 1 None 366837 12089673 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Canta, Canta Mais 1 None 271856 8719426 0.99 Antônio Carlos Jobim Warner 25 Anos Jazz
Enter Sandman 1 Apocalyptica 221701 7286305 0.99 Apocalyptica Plays Metallica By Four Cellos Metal
Master Of Puppets 1 Apocalyptica 436453 14375310 0.99 Apocalyptica Plays Metallica By Four Cellos Metal
Harvester Of Sorrow 1 Apocalyptica 374543 12372536 0.99 Apocalyptica Plays Metallica By Four Cellos Metal
The Unforgiven 1 Apocalyptica 322925 10422447 0.99 Apocalyptica Plays Metallica By Four Cellos Metal
Sad But True 1 Apocalyptica 288208 9405526 0.99 Apocalyptica Plays Metallica By Four Cellos Metal
Creeping Death 1 Apocalyptica 308035 10110980 0.99 Apocalyptica Plays Metallica By Four Cellos Metal
Wherever I May Roam 1 Apocalyptica 369345 12033110 0.99 Apocalyptica Plays Metallica By Four Cellos Metal
Welcome Home (Sanitarium) 1 Apocalyptica 350197 11406431 0.99 Apocalyptica Plays Metallica By Four Cellos Metal
Cochise 1 Audioslave/Chris Cornell 222380 5339931 0.99 Audioslave Audioslave Rock
Show Me How to Live 1 Audioslave/Chris Cornell 277890 6672176 0.99 Audioslave Audioslave Rock
Gasoline 1 Audioslave/Chris Cornell 279457 6709793 0.99 Audioslave Audioslave Rock
What You Are 1 Audioslave/Chris Cornell 249391 5988186 0.99 Audioslave Audioslave Rock
Like a Stone 1 Audioslave/Chris Cornell 294034 7059624 0.99 Audioslave Audioslave Rock
Set It Off 1 Audioslave/Chris Cornell 263262 6321091 0.99 Audioslave Audioslave Rock
Shadow on the Sun 1 Audioslave/Chris Cornell 343457 8245793 0.99 Audioslave Audioslave Rock
I am the Highway 1 Audioslave/Chris Cornell 334942 8041411 0.99 Audioslave Audioslave Rock
Exploder 1 Audioslave/Chris Cornell 206053 4948095 0.99 Audioslave Audioslave Rock
Hypnotize 1 Audioslave/Chris Cornell 206628 4961887 0.99 Audioslave Audioslave Rock
Bring'em Back Alive 1 Audioslave/Chris Cornell 329534 7911634 0.99 Audioslave Audioslave Rock
Light My Way 1 Audioslave/Chris Cornell 303595 7289084 0.99 Audioslave Audioslave Rock
Getaway Car 1 Audioslave/Chris Cornell 299598 7193162 0.99 Audioslave Audioslave Rock
The Last Remaining Light 1 Audioslave/Chris Cornell 317492 7622615 0.99 Audioslave Audioslave Rock
Your Time Has Come 1 Cornell, Commerford, Morello, Wilk 255529 8273592 0.99 Audioslave Out Of Exile Alternative & Punk
Out Of Exile 1 Cornell, Commerford, Morello, Wilk 291291 9506571 0.99 Audioslave Out Of Exile Alternative & Punk
Be Yourself 1 Cornell, Commerford, Morello, Wilk 279484 9106160 0.99 Audioslave Out Of Exile Alternative & Punk
Doesn't Remind Me 1 Cornell, Commerford, Morello, Wilk 255869 8357387 0.99 Audioslave Out Of Exile Alternative & Punk
Drown Me Slowly 1 Cornell, Commerford, Morello, Wilk 233691 7609178 0.99 Audioslave Out Of Exile Alternative & Punk
Heaven's Dead 1 Cornell, Commerford, Morello, Wilk 276688 9006158 0.99 Audioslave Out Of Exile Alternative & Punk
The Worm 1 Cornell, Commerford, Morello, Wilk 237714 7710800 0.99 Audioslave Out Of Exile Alternative & Punk
Man Or Animal 1 Cornell, Commerford, Morello, Wilk 233195 7542942 0.99 Audioslave Out Of Exile Alternative & Punk
Yesterday To Tomorrow 1 Cornell, Commerford, Morello, Wilk 273763 8944205 0.99 Audioslave Out Of Exile Alternative & Punk
Dandelion 1 Cornell, Commerford, Morello, Wilk 278125 9003592 0.99 Audioslave Out Of Exile Alternative & Punk
#1 Zero 1 Cornell, Commerford, Morello, Wilk 299102 9731988 0.99 Audioslave Out Of Exile Alternative & Punk
The Curse 1 Cornell, Commerford, Morello, Wilk 309786 10029406 0.99 Audioslave Out Of Exile Alternative & Punk
Money 1 Berry Gordy, Jr./Janie Bradford 147591 2365897 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Long Tall Sally 1 Enotris Johnson/Little Richard/Robert "Bumps" Blackwell 106396 1707084 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Bad Boy 1 Larry Williams 116088 1862126 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Twist And Shout 1 Bert Russell/Phil Medley 161123 2582553 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Please Mr. Postman 1 Brian Holland/Freddie Gorman/Georgia Dobbins/Robert Bateman/William Garrett 137639 2206986 0.99 BackBeat BackBeat Soundtrack Rock And Roll
C'Mon Everybody 1 Eddie Cochran/Jerry Capehart 140199 2247846 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Rock 'N' Roll Music 1 Chuck Berry 141923 2276788 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Slow Down 1 Larry Williams 163265 2616981 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Roadrunner 1 Bo Diddley 143595 2301989 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Carol 1 Chuck Berry 143830 2306019 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Good Golly Miss Molly 1 Little Richard 106266 1704918 0.99 BackBeat BackBeat Soundtrack Rock And Roll
20 Flight Rock 1 Ned Fairchild 107807 1299960 0.99 BackBeat BackBeat Soundtrack Rock And Roll
Quadrant 1 Billy Cobham 261851 8538199 0.99 Billy Cobham The Best Of Billy Cobham Jazz
Snoopy's search-Red baron 1 Billy Cobham 456071 15075616 0.99 Billy Cobham The Best Of Billy Cobham Jazz
Spanish moss-"A sound portrait"-Spanish moss 1 Billy Cobham 248084 8217867 0.99 Billy Cobham The Best Of Billy Cobham Jazz
Moon germs 1 Billy Cobham 294060 9714812 0.99 Billy Cobham The Best Of Billy Cobham Jazz
Stratus 1 Billy Cobham 582086 19115680 0.99 Billy Cobham The Best Of Billy Cobham Jazz
The pleasant pheasant 1 Billy Cobham 318066 10630578 0.99 Billy Cobham The Best Of Billy Cobham Jazz
Solo-Panhandler 1 Billy Cobham 246151 8230661 0.99 Billy Cobham The Best Of Billy Cobham Jazz
Do what cha wanna 1 George Duke 274155 9018565 0.99 Billy Cobham The Best Of Billy Cobham Jazz
Intro/ Low Down 1 None 323683 10642901 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
13 Years Of Grief 1 None 246987 8137421 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
Stronger Than Death 1 None 300747 9869647 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
All For You 1 None 235833 7726948 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
Super Terrorizer 1 None 319373 10513905 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
Phoney Smile Fake Hellos 1 None 273606 9011701 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
Lost My Better Half 1 None 284081 9355309 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
Bored To Tears 1 None 247327 8130090 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
A.N.D.R.O.T.A.Z. 1 None 266266 8574746 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
Born To Booze 1 None 282122 9257358 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
World Of Trouble 1 None 359157 11820932 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
No More Tears 1 None 555075 18041629 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
The Begining... At Last 1 None 365662 11965109 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 1] Metal
Heart Of Gold 1 None 194873 6417460 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 2] Metal
Snowblind 1 None 420022 13842549 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 2] Metal
Like A Bird 1 None 276532 9115657 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 2] Metal
Blood In The Wall 1 None 284368 9359475 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 2] Metal
The Beginning...At Last 1 None 271960 8975814 0.99 Black Label Society Alcohol Fueled Brewtality Live! [Disc 2] Metal
Black Sabbath 1 None 382066 12440200 0.99 Black Sabbath Black Sabbath Metal
The Wizard 1 None 264829 8646737 0.99 Black Sabbath Black Sabbath Metal
Behind The Wall Of Sleep 1 None 217573 7169049 0.99 Black Sabbath Black Sabbath Metal
N.I.B. 1 None 368770 12029390 0.99 Black Sabbath Black Sabbath Metal
Evil Woman 1 None 204930 6655170 0.99 Black Sabbath Black Sabbath Metal
Sleeping Village 1 None 644571 21128525 0.99 Black Sabbath Black Sabbath Metal
Warning 1 None 212062 6893363 0.99 Black Sabbath Black Sabbath Metal
Wheels Of Confusion / The Straightener 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 494524 16065830 0.99 Black Sabbath Black Sabbath Vol. 4 (Remaster) Metal
Tomorrow's Dream 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 192496 6252071 0.99 Black Sabbath Black Sabbath Vol. 4 (Remaster) Metal
Changes 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 286275 9175517 0.99 Black Sabbath Black Sabbath Vol. 4 (Remaster) Metal
FX 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 103157 3331776 0.99 Black Sabbath Black Sabbath Vol. 4 (Remaster) Metal
Supernaut 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 285779 9245971 0.99 Black Sabbath Black Sabbath Vol. 4 (Remaster) Metal
...

3) Many-to-many

Let's turn out attention to another table, called playlist_track.

It serves as a way to connect the tracks table with the playlists table, which contains the name of the playlist.

In [7]:
playlist_track
table playlist_track, =8715
PlaylistId TrackId
1 3402
1 3389
1 3390
1 3391
1 3392
1 3393
1 3394
1 3395
1 3396
1 3397
1 3398
1 3399
1 3400
1 3401
1 3336
1 3478
1 3375
1 3376
1 3377
1 3378
1 3379
1 3380
1 3381
1 3382
1 3383
1 3384
1 3385
1 3386
1 3387
1 3388
1 3365
1 3366
1 3367
1 3368
1 3369
1 3370
1 3371
1 3372
1 3373
1 3374
1 99
1 100
1 101
1 102
1 103
1 104
1 105
1 106
1 107
1 108
1 109
1 110
1 166
1 167
1 168
1 169
1 170
1 171
1 172
1 173
1 174
1 175
1 176
1 177
1 178
1 179
1 180
1 181
1 182
1 2591
1 2592
1 2593
1 2594
1 2595
1 2596
1 2597
1 2598
1 2599
1 2600
1 2601
1 2602
1 2603
1 2604
1 2605
1 2606
1 2607
1 2608
1 923
1 924
1 925
1 926
1 927
1 928
1 929
1 930
1 931
1 932
1 933
1 934
1 935
1 936
1 937
1 938
1 939
1 940
1 941
1 942
1 943
1 944
1 945
1 946
1 947
1 948
1 964
1 965
1 966
1 967
1 968
1 969
1 970
1 971
1 972
1 973
1 974
1 1009
1 1010
1 1011
1 1012
1 1013
1 1014
1 1015
1 1016
1 1017
1 1018
1 1019
1 1133
1 1134
1 1135
1 1136
1 1137
1 1138
1 1139
1 1140
1 1141
1 1142
1 1143
1 1144
1 1145
1 468
1 469
1 470
1 471
1 472
1 473
1 474
1 475
1 476
1 477
1 478
1 479
...

Let's write another declaration, to make our future joins simpler:

In [11]:
table playlist_track {
	PlaylistId: playlists.PlaylistId
	TrackId: tracks.TrackId
}

Just for exploration's sake, let's see how many tracks each playlist has.

In [20]:
join(pt: playlist_track, p: playlists) {p.PlaylistId, p.Name => count()}
table , =14
PlaylistId Name count
1 Music 3290
3 TV Shows 213
5 90’s Music 1477
8 Music 3290
9 Music Videos 1
10 TV Shows 213
11 Brazilian Music 39
12 Classical 75
13 Classical 101 - Deep Cuts 25
14 Classical 101 - Next Steps 25
15 Classical 101 - The Basics 25
16 Grunge 15
17 Heavy Metal Classic 26
18 On-The-Go 1 1

Group-by into list

And let's create a new table of tracks, but this time we'll use the group-by operator (=>) to add a list of categories to each track:

In [21]:
tracks_with_categories = join(t: tracks, pt: playlist_track, p: playlists) {
    ...t => Categories: p.Name
}
table , =3503
AlbumId GenreId TrackId Name MediaTypeId Composer Milliseconds Bytes UnitPrice Categories
1 1 1 For Those About To Rock (We Salute You) 1 Angus Young, Malcolm Young, Brian Johnson 343719 11170334 0.99 ['Music', 'Music', 'Heavy Metal Classic']
1 1 6 Put The Finger On You 1 Angus Young, Malcolm Young, Brian Johnson 205662 6713451 0.99 ['Music', 'Music']
1 1 7 Let's Get It Up 1 Angus Young, Malcolm Young, Brian Johnson 233926 7636561 0.99 ['Music', 'Music']
1 1 8 Inject The Venom 1 Angus Young, Malcolm Young, Brian Johnson 210834 6852860 0.99 ['Music', 'Music']
1 1 9 Snowballed 1 Angus Young, Malcolm Young, Brian Johnson 203102 6599424 0.99 ['Music', 'Music']
1 1 10 Evil Walks 1 Angus Young, Malcolm Young, Brian Johnson 263497 8611245 0.99 ['Music', 'Music']
1 1 11 C.O.D. 1 Angus Young, Malcolm Young, Brian Johnson 199836 6566314 0.99 ['Music', 'Music']
1 1 12 Breaking The Rules 1 Angus Young, Malcolm Young, Brian Johnson 263288 8596840 0.99 ['Music', 'Music']
1 1 13 Night Of The Long Knives 1 Angus Young, Malcolm Young, Brian Johnson 205688 6706347 0.99 ['Music', 'Music']
1 1 14 Spellbound 1 Angus Young, Malcolm Young, Brian Johnson 270863 8817038 0.99 ['Music', 'Music']
4 1 15 Go Down 1 AC/DC 331180 10847611 0.99 ['Music', 'Music']
4 1 16 Dog Eat Dog 1 AC/DC 215196 7032162 0.99 ['Music', 'Music']
4 1 17 Let There Be Rock 1 AC/DC 366654 12021261 0.99 ['Music', 'Music']
4 1 18 Bad Boy Boogie 1 AC/DC 267728 8776140 0.99 ['Music', 'Music']
4 1 19 Problem Child 1 AC/DC 325041 10617116 0.99 ['Music', 'Music']
4 1 20 Overdose 1 AC/DC 369319 12066294 0.99 ['Music', 'Music']
4 1 21 Hell Ain't A Bad Place To Be 1 AC/DC 254380 8331286 0.99 ['Music', 'Music']
4 1 22 Whole Lotta Rosie 1 AC/DC 323761 10547154 0.99 ['Music', 'Music']
5 1 23 Walk On Water 1 Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw 295680 9719579 0.99 ['Music', '90’s Music', 'Music']
5 1 24 Love In An Elevator 1 Steven Tyler, Joe Perry 321828 10552051 0.99 ['Music', '90’s Music', 'Music']
5 1 25 Rag Doll 1 Steven Tyler, Joe Perry, Jim Vallance, Holly Knight 264698 8675345 0.99 ['Music', '90’s Music', 'Music']
5 1 26 What It Takes 1 Steven Tyler, Joe Perry, Desmond Child 310622 10144730 0.99 ['Music', '90’s Music', 'Music']
5 1 27 Dude (Looks Like A Lady) 1 Steven Tyler, Joe Perry, Desmond Child 264855 8679940 0.99 ['Music', '90’s Music', 'Music']
5 1 28 Janie's Got A Gun 1 Steven Tyler, Tom Hamilton 330736 10869391 0.99 ['Music', '90’s Music', 'Music']
5 1 29 Cryin' 1 Steven Tyler, Joe Perry, Taylor Rhodes 309263 10056995 0.99 ['Music', '90’s Music', 'Music']
5 1 30 Amazing 1 Steven Tyler, Richie Supa 356519 11616195 0.99 ['Music', '90’s Music', 'Music']
5 1 31 Blind Man 1 Steven Tyler, Joe Perry, Taylor Rhodes 240718 7877453 0.99 ['Music', '90’s Music', 'Music']
5 1 32 Deuces Are Wild 1 Steven Tyler, Jim Vallance 215875 7074167 0.99 ['Music', '90’s Music', 'Music']
5 1 33 The Other Side 1 Steven Tyler, Jim Vallance 244375 7983270 0.99 ['Music', '90’s Music', 'Music']
5 1 34 Crazy 1 Steven Tyler, Joe Perry, Desmond Child 316656 10402398 0.99 ['Music', '90’s Music', 'Music']
5 1 35 Eat The Rich 1 Steven Tyler, Joe Perry, Jim Vallance 251036 8262039 0.99 ['Music', '90’s Music', 'Music']
5 1 36 Angel 1 Steven Tyler, Desmond Child 307617 9989331 0.99 ['Music', '90’s Music', 'Music']
5 1 37 Livin' On The Edge 1 Steven Tyler, Joe Perry, Mark Hudson 381231 12374569 0.99 ['Music', '90’s Music', 'Music']
6 1 38 All I Really Want 1 Alanis Morissette & Glenn Ballard 284891 9375567 0.99 ['Music', '90’s Music', 'Music']
6 1 39 You Oughta Know 1 Alanis Morissette & Glenn Ballard 249234 8196916 0.99 ['Music', '90’s Music', 'Music']
6 1 40 Perfect 1 Alanis Morissette & Glenn Ballard 188133 6145404 0.99 ['Music', '90’s Music', 'Music']
6 1 41 Hand In My Pocket 1 Alanis Morissette & Glenn Ballard 221570 7224246 0.99 ['Music', '90’s Music', 'Music']
6 1 42 Right Through You 1 Alanis Morissette & Glenn Ballard 176117 5793082 0.99 ['Music', '90’s Music', 'Music']
6 1 43 Forgiven 1 Alanis Morissette & Glenn Ballard 300355 9753256 0.99 ['Music', '90’s Music', 'Music']
6 1 44 You Learn 1 Alanis Morissette & Glenn Ballard 239699 7824837 0.99 ['Music', '90’s Music', 'Music']
6 1 45 Head Over Feet 1 Alanis Morissette & Glenn Ballard 267493 8758008 0.99 ['Music', '90’s Music', 'Music']
6 1 46 Mary Jane 1 Alanis Morissette & Glenn Ballard 280607 9163588 0.99 ['Music', '90’s Music', 'Music']
6 1 47 Ironic 1 Alanis Morissette & Glenn Ballard 229825 7598866 0.99 ['Music', '90’s Music', 'Music']
6 1 48 Not The Doctor 1 Alanis Morissette & Glenn Ballard 227631 7604601 0.99 ['Music', '90’s Music', 'Music']
6 1 49 Wake Up 1 Alanis Morissette & Glenn Ballard 293485 9703359 0.99 ['Music', '90’s Music', 'Music']
6 1 50 You Oughta Know (Alternate) 1 Alanis Morissette & Glenn Ballard 491885 16008629 0.99 ['Music', '90’s Music', 'Music']
7 1 51 We Die Young 1 Jerry Cantrell 152084 4925362 0.99 ['Music', '90’s Music', 'Music']
7 1 52 Man In The Box 1 Jerry Cantrell, Layne Staley 286641 9310272 0.99 ['Music', '90’s Music', 'Music', 'Grunge']
7 1 53 Sea Of Sorrow 1 Jerry Cantrell 349831 11316328 0.99 ['Music', '90’s Music', 'Music']
7 1 54 Bleed The Freak 1 Jerry Cantrell 241946 7847716 0.99 ['Music', '90’s Music', 'Music']
7 1 55 I Can't Remember 1 Jerry Cantrell, Layne Staley 222955 7302550 0.99 ['Music', '90’s Music', 'Music']
7 1 56 Love, Hate, Love 1 Jerry Cantrell, Layne Staley 387134 12575396 0.99 ['Music', '90’s Music', 'Music']
7 1 57 It Ain't Like That 1 Jerry Cantrell, Michael Starr, Sean Kinney 277577 8993793 0.99 ['Music', '90’s Music', 'Music']
7 1 58 Sunshine 1 Jerry Cantrell 284969 9216057 0.99 ['Music', '90’s Music', 'Music']
7 1 59 Put You Down 1 Jerry Cantrell 196231 6420530 0.99 ['Music', '90’s Music', 'Music']
7 1 60 Confusion 1 Jerry Cantrell, Michael Starr, Layne Staley 344163 11183647 0.99 ['Music', '90’s Music', 'Music']
7 1 61 I Know Somethin (Bout You) 1 Jerry Cantrell 261955 8497788 0.99 ['Music', '90’s Music', 'Music']
7 1 62 Real Thing 1 Jerry Cantrell, Layne Staley 243879 7937731 0.99 ['Music', '90’s Music', 'Music']
8 2 63 Desafinado 1 None 185338 5990473 0.99 ['Music', 'Music']
8 2 64 Garota De Ipanema 1 None 285048 9348428 0.99 ['Music', 'Music']
8 2 65 Samba De Uma Nota Só (One Note Samba) 1 None 137273 4535401 0.99 ['Music', 'Music']
8 2 66 Por Causa De Você 1 None 169900 5536496 0.99 ['Music', 'Music']
8 2 67 Ligia 1 None 251977 8226934 0.99 ['Music', 'Music']
8 2 68 Fotografia 1 None 129227 4198774 0.99 ['Music', 'Music']
8 2 69 Dindi (Dindi) 1 None 253178 8149148 0.99 ['Music', 'Music']
8 2 70 Se Todos Fossem Iguais A Você (Instrumental) 1 None 134948 4393377 0.99 ['Music', 'Music']
8 2 71 Falando De Amor 1 None 219663 7121735 0.99 ['Music', 'Music']
8 2 72 Angela 1 None 169508 5574957 0.99 ['Music', 'Music']
8 2 73 Corcovado (Quiet Nights Of Quiet Stars) 1 None 205662 6687994 0.99 ['Music', 'Music']
8 2 74 Outra Vez 1 None 126511 4110053 0.99 ['Music', 'Music']
8 2 75 O Boto (Bôto) 1 None 366837 12089673 0.99 ['Music', 'Music']
8 2 76 Canta, Canta Mais 1 None 271856 8719426 0.99 ['Music', 'Music']
9 3 77 Enter Sandman 1 Apocalyptica 221701 7286305 0.99 ['Music', '90’s Music', 'Music']
9 3 78 Master Of Puppets 1 Apocalyptica 436453 14375310 0.99 ['Music', '90’s Music', 'Music']
9 3 79 Harvester Of Sorrow 1 Apocalyptica 374543 12372536 0.99 ['Music', '90’s Music', 'Music']
9 3 80 The Unforgiven 1 Apocalyptica 322925 10422447 0.99 ['Music', '90’s Music', 'Music']
9 3 81 Sad But True 1 Apocalyptica 288208 9405526 0.99 ['Music', '90’s Music', 'Music']
9 3 82 Creeping Death 1 Apocalyptica 308035 10110980 0.99 ['Music', '90’s Music', 'Music']
9 3 83 Wherever I May Roam 1 Apocalyptica 369345 12033110 0.99 ['Music', '90’s Music', 'Music']
9 3 84 Welcome Home (Sanitarium) 1 Apocalyptica 350197 11406431 0.99 ['Music', '90’s Music', 'Music']
10 1 85 Cochise 1 Audioslave/Chris Cornell 222380 5339931 0.99 ['Music', 'Music']
10 1 86 Show Me How to Live 1 Audioslave/Chris Cornell 277890 6672176 0.99 ['Music', 'Music']
10 1 87 Gasoline 1 Audioslave/Chris Cornell 279457 6709793 0.99 ['Music', 'Music']
10 1 88 What You Are 1 Audioslave/Chris Cornell 249391 5988186 0.99 ['Music', 'Music']
10 1 89 Like a Stone 1 Audioslave/Chris Cornell 294034 7059624 0.99 ['Music', 'Music']
10 1 90 Set It Off 1 Audioslave/Chris Cornell 263262 6321091 0.99 ['Music', 'Music']
10 1 91 Shadow on the Sun 1 Audioslave/Chris Cornell 343457 8245793 0.99 ['Music', 'Music']
10 1 92 I am the Highway 1 Audioslave/Chris Cornell 334942 8041411 0.99 ['Music', 'Music']
10 1 93 Exploder 1 Audioslave/Chris Cornell 206053 4948095 0.99 ['Music', 'Music']
10 1 94 Hypnotize 1 Audioslave/Chris Cornell 206628 4961887 0.99 ['Music', 'Music']
10 1 95 Bring'em Back Alive 1 Audioslave/Chris Cornell 329534 7911634 0.99 ['Music', 'Music']
10 1 96 Light My Way 1 Audioslave/Chris Cornell 303595 7289084 0.99 ['Music', 'Music']
10 1 97 Getaway Car 1 Audioslave/Chris Cornell 299598 7193162 0.99 ['Music', 'Music']
10 1 98 The Last Remaining Light 1 Audioslave/Chris Cornell 317492 7622615 0.99 ['Music', 'Music']
11 4 99 Your Time Has Come 1 Cornell, Commerford, Morello, Wilk 255529 8273592 0.99 ['Music', 'Music']
11 4 100 Out Of Exile 1 Cornell, Commerford, Morello, Wilk 291291 9506571 0.99 ['Music', 'Music']
11 4 101 Be Yourself 1 Cornell, Commerford, Morello, Wilk 279484 9106160 0.99 ['Music', 'Music']
11 4 102 Doesn't Remind Me 1 Cornell, Commerford, Morello, Wilk 255869 8357387 0.99 ['Music', 'Music']
11 4 103 Drown Me Slowly 1 Cornell, Commerford, Morello, Wilk 233691 7609178 0.99 ['Music', 'Music']
11 4 104 Heaven's Dead 1 Cornell, Commerford, Morello, Wilk 276688 9006158 0.99 ['Music', 'Music']
11 4 105 The Worm 1 Cornell, Commerford, Morello, Wilk 237714 7710800 0.99 ['Music', 'Music']
11 4 106 Man Or Animal 1 Cornell, Commerford, Morello, Wilk 233195 7542942 0.99 ['Music', 'Music']
11 4 107 Yesterday To Tomorrow 1 Cornell, Commerford, Morello, Wilk 273763 8944205 0.99 ['Music', 'Music']
11 4 108 Dandelion 1 Cornell, Commerford, Morello, Wilk 278125 9003592 0.99 ['Music', 'Music']
11 4 109 #1 Zero 1 Cornell, Commerford, Morello, Wilk 299102 9731988 0.99 ['Music', 'Music']
11 4 110 The Curse 1 Cornell, Commerford, Morello, Wilk 309786 10029406 0.99 ['Music', 'Music']
12 5 111 Money 1 Berry Gordy, Jr./Janie Bradford 147591 2365897 0.99 ['Music', '90’s Music', 'Music']
12 5 112 Long Tall Sally 1 Enotris Johnson/Little Richard/Robert "Bumps" Blackwell 106396 1707084 0.99 ['Music', '90’s Music', 'Music']
12 5 113 Bad Boy 1 Larry Williams 116088 1862126 0.99 ['Music', '90’s Music', 'Music']
12 5 114 Twist And Shout 1 Bert Russell/Phil Medley 161123 2582553 0.99 ['Music', '90’s Music', 'Music']
12 5 115 Please Mr. Postman 1 Brian Holland/Freddie Gorman/Georgia Dobbins/Robert Bateman/William Garrett 137639 2206986 0.99 ['Music', '90’s Music', 'Music']
12 5 116 C'Mon Everybody 1 Eddie Cochran/Jerry Capehart 140199 2247846 0.99 ['Music', '90’s Music', 'Music']
12 5 117 Rock 'N' Roll Music 1 Chuck Berry 141923 2276788 0.99 ['Music', '90’s Music', 'Music']
12 5 118 Slow Down 1 Larry Williams 163265 2616981 0.99 ['Music', '90’s Music', 'Music']
12 5 119 Roadrunner 1 Bo Diddley 143595 2301989 0.99 ['Music', '90’s Music', 'Music']
12 5 120 Carol 1 Chuck Berry 143830 2306019 0.99 ['Music', '90’s Music', 'Music']
12 5 121 Good Golly Miss Molly 1 Little Richard 106266 1704918 0.99 ['Music', '90’s Music', 'Music']
12 5 122 20 Flight Rock 1 Ned Fairchild 107807 1299960 0.99 ['Music', '90’s Music', 'Music']
13 2 123 Quadrant 1 Billy Cobham 261851 8538199 0.99 ['Music', 'Music']
13 2 124 Snoopy's search-Red baron 1 Billy Cobham 456071 15075616 0.99 ['Music', 'Music']
13 2 125 Spanish moss-"A sound portrait"-Spanish moss 1 Billy Cobham 248084 8217867 0.99 ['Music', 'Music']
13 2 126 Moon germs 1 Billy Cobham 294060 9714812 0.99 ['Music', 'Music']
13 2 127 Stratus 1 Billy Cobham 582086 19115680 0.99 ['Music', 'Music']
13 2 128 The pleasant pheasant 1 Billy Cobham 318066 10630578 0.99 ['Music', 'Music']
13 2 129 Solo-Panhandler 1 Billy Cobham 246151 8230661 0.99 ['Music', 'Music']
13 2 130 Do what cha wanna 1 George Duke 274155 9018565 0.99 ['Music', 'Music']
14 3 131 Intro/ Low Down 1 None 323683 10642901 0.99 ['Music', 'Music']
14 3 132 13 Years Of Grief 1 None 246987 8137421 0.99 ['Music', 'Music']
14 3 133 Stronger Than Death 1 None 300747 9869647 0.99 ['Music', 'Music']
14 3 134 All For You 1 None 235833 7726948 0.99 ['Music', 'Music']
14 3 135 Super Terrorizer 1 None 319373 10513905 0.99 ['Music', 'Music']
14 3 136 Phoney Smile Fake Hellos 1 None 273606 9011701 0.99 ['Music', 'Music']
14 3 137 Lost My Better Half 1 None 284081 9355309 0.99 ['Music', 'Music']
14 3 138 Bored To Tears 1 None 247327 8130090 0.99 ['Music', 'Music']
14 3 139 A.N.D.R.O.T.A.Z. 1 None 266266 8574746 0.99 ['Music', 'Music']
14 3 140 Born To Booze 1 None 282122 9257358 0.99 ['Music', 'Music']
14 3 141 World Of Trouble 1 None 359157 11820932 0.99 ['Music', 'Music']
14 3 142 No More Tears 1 None 555075 18041629 0.99 ['Music', 'Music']
14 3 143 The Begining... At Last 1 None 365662 11965109 0.99 ['Music', 'Music']
15 3 144 Heart Of Gold 1 None 194873 6417460 0.99 ['Music', 'Music']
15 3 145 Snowblind 1 None 420022 13842549 0.99 ['Music', 'Music']
15 3 146 Like A Bird 1 None 276532 9115657 0.99 ['Music', 'Music']
15 3 147 Blood In The Wall 1 None 284368 9359475 0.99 ['Music', 'Music']
15 3 148 The Beginning...At Last 1 None 271960 8975814 0.99 ['Music', 'Music']
16 3 149 Black Sabbath 1 None 382066 12440200 0.99 ['Music', 'Music']
16 3 150 The Wizard 1 None 264829 8646737 0.99 ['Music', 'Music']
16 3 151 Behind The Wall Of Sleep 1 None 217573 7169049 0.99 ['Music', 'Music']
16 3 152 N.I.B. 1 None 368770 12029390 0.99 ['Music', 'Music', 'Heavy Metal Classic']
16 3 153 Evil Woman 1 None 204930 6655170 0.99 ['Music', 'Music']
16 3 154 Sleeping Village 1 None 644571 21128525 0.99 ['Music', 'Music']
16 3 155 Warning 1 None 212062 6893363 0.99 ['Music', 'Music']
17 3 156 Wheels Of Confusion / The Straightener 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 494524 16065830 0.99 ['Music', 'Music']
17 3 157 Tomorrow's Dream 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 192496 6252071 0.99 ['Music', 'Music']
17 3 158 Changes 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 286275 9175517 0.99 ['Music', 'Music']
17 3 159 FX 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 103157 3331776 0.99 ['Music', 'Music']
17 3 160 Supernaut 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 285779 9245971 0.99 ['Music', 'Music', 'Heavy Metal Classic']
17 3 161 Snowblind 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 331676 10813386 0.99 ['Music', 'Music']
17 3 162 Cornucopia 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 234814 7653880 0.99 ['Music', 'Music']
17 3 163 Laguna Sunrise 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 173087 5671374 0.99 ['Music', 'Music']
17 3 164 St. Vitus Dance 1 Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 149655 4884969 0.99 ['Music', 'Music']
...

4) Exercise

Write a query that joins all the following tables, and displays them in a single convenient table:

  • tracks
  • artists
  • albums
  • genres
  • playlists
In [ ]: