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
Use the help()
function to get information about functions and types:
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.
Follow the code examples, and make sure to add your own cells and play around with the code.
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.
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:
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?] |
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:
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.
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.
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:
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'} |
... |
For convenience, we might like to flatten those structs into a single table, and give it a name:
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 |
... |
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.
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:
table playlist_track {
PlaylistId: playlists.PlaylistId
TrackId: tracks.TrackId
}
Just for exploration's sake, let's see how many tracks each playlist has.
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 |
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:
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'] |
... |
Write a query that joins all the following tables, and displays them in a single convenient table: