QUERY #1 kind | year ------------+------ movie | 1977 episode | 1980 video game | 1983 video game | 1988 video game | 1991 episode | 1998 episode | 2000 episode | 2002 episode | 2005 episode | 2005 episode | 2008 video game | 2010 episode | 2011 episode | 2011 episode | 2012 episode | 2012 episode | 2013 episode | 2014 episode | 2014 episode | 2014 episode | 2014 episode | 2015 episode | 2015 episode | 2015 episode | 2016 (25 rows) QUERY #2 real_name | char_name ---------------------+-------------------------- Arnett, Will | Batman Arnett, Will | Bruce Wayne Banks, Elizabeth | Wyldstyle Banks, Elizabeth | Lucy Berry, Craig | Additional Voices Berry, Craig | Blake Brie, Alison | Unikitty Burrows, David | Additional Voices Burrows, David | Octan Robot Daniels, Anthony | C-3PO Day, Charlie | Benny Farinos, Amanda | Mom Ferguson, Keith | Han Solo Ferrell, Will | The Man Upstairs Ferrell, Will | Lord Business Ferrell, Will | President Business Forte, Will | Abraham Lincoln Franco, Dave | Wally Freeman, Morgan | Vitruvius Hansen, Todd | Additional Voices Hansen, Todd | Gandalf Hill, Jonah | Green Lantern Johnson, Jake | Barry Key, Keegan-Michael | Foreman Jim Lafferty, Kelly | Lord Business' Assistant McKay, Chris | Larry the Barista McKay, Chris | Additional Voices Miller, Christopher | TV Presenter Miller, Graham | Duplo Neeson, Liam | Bad Cop Neeson, Liam | Good Cop Neeson, Liam | Pa Cop Nicholas, Doug | Surfer Dave Nicholas, Doug | Additional Voices O'Neal, Shaquille | Shaq Offerman, Nick | Metal Beard Paluszek, Chris | Robot Foreman Pratt, Chris | Emmet Brickowoski Romano, Chris | Joe Sand, Jadon | Finn Smulders, Cobie | Wonder Woman Sturm, Melissa | Gail Sturm, Melissa | Ma Cop Taccone, Jorma | Additional Voices Taccone, Jorma | Shakespeare Tatum, Channing | Superman Williams, Billy Dee | Lando Veskimets, Leiki | Computer (48 rows) QUERY #3 title | runtime | plot --------------------------------------------------------------+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Anjelah Johnson: Not Fancy | USA:90 | Brandee Built on Crazee | USA:90 | This comedy is loosely based on Brandee Tucker's life. Tucker plays over fifteen characters where she walks the audience through her experiences starting from age six. The audience will go through a journey meeting childhood bullies, a beauty shop guru, relatives with mental illness, an inspiring grandmother and many more characters. Night of the Wild | USA:90 | Stormageddon | USA:90 | What happens when you ask the most powerful computer program, run by the most powerful computers, to follow, listen and predict human behavior? The program learns, becomes sentient and begins to behave like a human. When a master computer program, Echelon, takes over America's entire online system, our country is threatened to be brought to its knees. Hacking into DARPA, Echelon gains the ability to manipulate the weather, create earthquakes, and cause a level of destruction unlike anything the country could ever imagine. But how do you stop a computer program when it has control over any and every defense you have? Andrew Dice Clay Presents the Blue Show | USA:87 | Andrew Dice Clay Presents The "Blue Show" with some of his favorite ... you guessed "Blue Comics"; Erik Myers, Steve Wilson, Eleanor Kerrigan, Michael Wheels Parise, The Smash Brothers; Cory & Chad, Colin Kane and Jason Rouse. Dice and his crew where as blue as he has always been without losing any bit of what has made him the infamous "Undisputed Bad Boy of Comedy." If you like your comedy edgy and filthy this is your show! O.J. Speaks: The Hidden Tapes | USA:86 | Through exclusive access to O.J. extensive deposition testimony, and exclusive interviews with the key insiders, O.J. SPEAKS tells the story of what it took to finally bring O.J. down. When O.J. Simpson was found not guilty of murder in a Los Angeles criminal court in October 1995 - at the end of the notorious "Trial of the Century" - families of the victims thought all hope of getting justice was lost. For Fred Goldman, father of murder victim Ron Goldman, the verdict was especially tough. But from their grief, Fred and his daughter Kim, found another avenue to pursue Simpson. They would join the family of Nicole Brown Simpson in filing a civil lawsuit for the wrongful deaths of Ron and Nicole. Even though a verdict in the Goldman's favor would not put Simpson behind bars, it would be what the family wanted more than anything else - for a court of law to hold the former NFL star responsible for the slayings. Fred and Kim knew they were in over their heads in the legal morass of a civil suit, so they began their search for the right attorney to help them pursue justice. By luck, they stumbled across Dan Petrocelli, a terrific civil lawyer, but one who had never tried anything close to a wrongful death case. The Goldmans believed in Petrocelli's passion and decided he was the right person to go after Simpson. Petrocelli told Fred and Kim that there was one major difference between a criminal case and a civil case. In a criminal case, Simpson did not have to testify. In a civil lawsuit the rules were different. Simpson would, for the first time, have to answer questions under oath about his possible involvement in the double homicide. Under the harsh and unrelenting questioning of Daniel Petrocelli, Simpson's own words revealed an O.J. Simpson who had woven a web of lies and who clearly believed that he was above the law. Told through Simpson's own words in his deposition tapes, this is the story of how the Goldman family and their unlikely choice for an attorney took on one of the nation's biggest celebrities, forced him to talk about his possible involvement in the killings, and dragged him into a different kind of trial - one which Fred Goldman described as being about the law and not about theatrics. It was a trial in which celebrity had no currency - a trial in which O.J.'s own words ultimately proved his responsibility for the double murder finally bringing justice to Fred Goldman and the Brown family. The Christmas Gift | USA:85 | I'm Not Ready for Christmas | USA:84 | The Secret Tapes of the O.J. Case: The Untold Story | USA:84 | In 1994, O.J. Simpson - beloved athlete, movie star, spokesperson, and American hero - was charged for the brutal double murder of his ex-wife Nicole Brown Simpson and her friend Ron Goldman. Although ultimately acquitted on Oct 3, 1994, Simpson was the most famous American ever charged with murder and many - despite the "mountain of evidence" - had trouble believing that it could be true. But there was a dark side to O.J. Simpson that most people didn't know. Now for the first time, new interviews with many of O.J. and Nicole's closest friends - including Kris Jenner, Keith Zlomsowitch (Nicole's ex-boyfriend), Robin Greer (a close friend of Nicole's), Joe Kolkowitz (talent agent and member of O.J.'s inner circle), and Fred Levinson (longtime friend of O.J.'s who witnessed his womanizing and controlling behavior) - reveal Simpson's Jekyll and Hyde persona. Through these intimate revelations the portrait of a domineering narcissist emerges, one prone to lies, self-deception, psychological abuse, and domestic violence. The Secret Tapes of the O.J. Case: The Untold Story uses an unprecedented collection of exclusive audio and visual materials, most of which have never been broadcast. Highlights include a suicidal-sounding audio recording made by Simpson shortly before the infamous Bronco chase; deposition testimony of O.J. Simpson being caught in a web of lies while under oath; excerpts from Nicole Simpson's diaries and never before heard audio recordings of O.J.'s now deceased close friend Robert Kardashian (Kris Jenner's ex-husband) who stood by him throughout the "Trial of the Century" as his attorney and confidante only to be left with nagging doubt. Who was this man he thought he knew? Lavalantula | USA:81 | Journey of Faith: Vespers Service at St. Patrick's Cathedral | USA:75 | Marc Maron: More Later | USA:75 | Multi-religious Service at 9/11 Memorial and Museum | USA:75 | Jay Mohr: Happy. And a Lot. | USA:67 | Convergence | USA:61 | Two men, separated by two continents, are being drawn together by undefined forces. Jon Hill, a stoic security agent for a global energy company in the U.S. is investigating multiple abductions linked to the oil industry around the world. One of these cases includes Ernesto Sandoval, an idealistic research scientist for the National Energy Agency in Venezuela. Both men have been conducting clandestine renewable energy research in direct conflict with their infinitely powerful industry. On the verge of a breakthrough, each is what the other is looking for as they attempt to take the future of energy into their own hands. (15 rows) QUERY #4 name | count ------------------------+------- Smith, Ian | 1814 Smith, Roger Craig | 941 Smith, Hal | 886 Smith, Yeardley | 869 Smith, Shepard | 823 Smith, Jordan Patrick | 715 Smith, Hillary B. | 712 Smith, Will | 712 Smith, Sandra | 635 Thorne-Smith, Courtney | 612 (10 rows) QUERY #5 char_name --------------------------------------------------------------------------- Axel Blackmar Barnabas Collins Bon Bon Captain Jack Sparrow Cesar Chick Purchase Commander Spencer Armacost Cry Baby Cry-Baby Customer in suit store Dean Corso Don Juan DeMarco Donnie Donnie Fleischer Eddie Edward D. Wood Jr. Edward Scissorhands Ed Wood Frank Tupelo Gene Watson George Jung Gilbert Grape Glen Lantz Guy Lapointe Guy on TV Harry Houdini Himself Himself, #24 Himself - #26: Things They Shouldn't Have Said Himself, #30 Himself - #99: Johnny Depp and the Winona Tattoo Himself - Actor Himself - César d'honneur Himself - Guest Himself - Interviewee Himself - Into the Woods Himself - Narrator Himself - Nominee: Best Actor in a Leading Role Himself - Nominee: Best Actor in a Motion Picture - Comedy Himself - Nominee: Best Actor in a Motion Picture [Drama] Himself - Nominee: Best Actor in a Motion Picture - Musical or Comedy Himself - Nominee: Favorite Movie Actor Himself - 'Patriot' Himself - Performer Himself - Place #88 Himself - Presenter Himself - Presenter: Best Actress in a Motion Picture - Comedy or Musical Himself - Presenter: Song 'Philadelphia' Himself - Producer Himself - Winner Himself - Winner: Favorite Movie Actor Himself - Winner: Male Star of Tomorrow Ichabod Crane Imaginarium Tony 1 Inspector Frederick Abberline Jack Jack Kahuna Laguna Jack Kerouac Jack Sparrow James 'Whitey' Bulger John Dillinger Johnny Depp Kemp Lars Lerner Lieutenant Victor L'inconnu Lionel Viland Mad Hatter Matthew Smith Mortdecai Mort Rainey Mr. Hayes Musical Narration Narrator Officer Tom Hanson Pete Rango Raoul Duke Raphael Reader Rob Cameron Rochester Roux Sam Sands Sherlock Gnomes Sir James Matthew Barrie Sweeney Todd Tonto Victor Van Dort Vince Dooler Vinnie Dooler Voice from an Animated Movie Will Caster William Blake Willy Wonka Wolf Yogi Victor (100 rows) QUERY #6 title | kind | count --------------------------------------------------+---------+------- Batman v Superman: Dawn of Justice | movie | 234 Captain America: Civil War | movie | 159 Deadpool | movie | 157 X-Men: Apocalypse | movie | 136 Suicide Squad | movie | 135 The Abominable Bride | episode | 132 Teenage Mutant Ninja Turtles: Out of the Shadows | movie | 113 Star Trek Beyond | movie | 112 The 5th Wave | movie | 101 Eddie the Eagle | movie | 95 The Angry Birds Movie | movie | 94 Kung Fu Panda 3 | movie | 91 13 Hours: The Secret Soldiers of Benghazi | movie | 87 Zoolander 2 | movie | 86 Shooting Clerks | movie | 85 Zootopia | movie | 81 Warcraft | movie | 79 Finding Dory | movie | 77 Gods of Egypt | movie | 77 Doctor Strange | movie | 76 Hail, Caesar! | movie | 76 Alice Through the Looking Glass | movie | 68 The BFG | movie | 68 The Legend of Tarzan | movie | 68 Ride Along 2 | movie | 65 Fantastic Beasts and Where to Find Them | movie | 63 Grimsby | movie | 61 King Lear | movie | 61 The Finest Hours | movie | 61 Pride and Prejudice and Zombies | movie | 60 The Huntsman Winter's War | movie | 60 Independence Day: Resurgence | movie | 59 Ghostbusters | movie | 58 The Jungle Book | movie | 58 The Divergent Series: Allegiant | movie | 57 Inferno | movie | 56 The Forest | movie | 56 Qualia | movie | 55 At the Foot of the Rainbow | movie | 54 Snowden | movie | 54 Assassin's Creed | movie | 53 Cold Side of the Pillow | movie | 53 Dirty Grandpa | movie | 53 Wazir | movie | 53 Highway to Havasu | movie | 52 Rogue One: A Star Wars Story | movie | 52 The Nice Guys | movie | 52 Free State of Jones | movie | 51 Jane Got a Gun | movie | 51 Moana | movie | 51 (50 rows) QUERY #7 p_partkey | p_name | p_retailprice -----------+-------------------------------------------------+--------------- 1000 | cream frosted navajo aquamarine black | 901.00 2 | blush rosy metallic lemon navajo | 902.00 1001 | goldenrod moccasin blush tan medium | 902.00 2000 | drab blue goldenrod powder medium | 902.00 3 | dark green antique puff wheat | 903.00 1002 | khaki pink blue misty chocolate | 903.00 2001 | chocolate blush dark peru navy | 903.00 3001 | moccasin wheat honeydew cornflower royal | 904.00 4000 | ghost spring green misty cornsilk | 904.00 1004 | light navajo indian pale antique | 905.00 2003 | floral yellow peach sandy lime | 905.00 3002 | black orchid navy lawn tan | 905.00 5000 | seashell blush papaya cornflower ghost | 905.00 6 | white ivory azure firebrick black | 906.00 1005 | antique olive saddle papaya chiffon | 906.00 2004 | violet blush purple plum gainsboro | 906.00 6000 | chocolate deep hot firebrick moccasin | 906.00 1006 | lime tomato orchid dim beige | 907.00 2005 | goldenrod sienna black gainsboro beige | 907.00 5002 | firebrick tan cornsilk smoke cornflower | 907.00 6001 | navajo aquamarine ivory peach antique | 907.00 7000 | beige dim sienna khaki blue | 907.00 8 | ivory khaki cream midnight rosy | 908.00 1007 | hot lemon medium blue salmon | 908.00 2006 | deep red midnight chartreuse lime | 908.00 3005 | sky linen firebrick goldenrod magenta | 908.00 5003 | bisque moccasin medium snow sienna | 908.00 6002 | cyan saddle cornsilk medium tan | 908.00 7001 | turquoise beige forest white tomato | 908.00 9 | thistle rose moccasin light floral | 909.00 1008 | blue cream aquamarine saddle beige | 909.00 2007 | pink cream blue black olive | 909.00 3006 | lawn dodger black orange plum | 909.00 4005 | floral goldenrod firebrick ghost cyan | 909.00 8001 | green medium burlywood dodger metallic | 909.00 9000 | plum blue khaki lawn lemon | 909.00 1009 | powder lace cyan hot chartreuse | 910.00 2008 | aquamarine gainsboro chocolate frosted tomato | 910.00 4006 | forest white peach cream lavender | 910.00 6004 | white forest cornflower smoke magenta | 910.00 7003 | navy yellow lavender tomato pink | 910.00 8002 | floral cream sandy chocolate chartreuse | 910.00 10000 | slate deep plum steel black | 910.00 2009 | wheat dark orange plum saddle | 911.00 3008 | ivory mint hot lavender metallic | 911.00 4007 | azure cream wheat rosy purple | 911.00 5006 | smoke blush orchid olive pink | 911.00 6005 | powder deep pink magenta pale | 911.00 7004 | lime blush red navy deep | 911.00 11000 | khaki mint chocolate aquamarine grey | 911.00 11 | chocolate turquoise sandy snow misty | 911.01 1010 | peach chocolate olive brown hot | 911.01 3009 | burnished light spring antique grey | 912.00 4008 | orange black wheat slate beige | 912.00 6006 | burlywood plum bisque honeydew almond | 912.00 7005 | sandy azure coral chiffon hot | 912.00 10002 | cyan green rose navy orchid | 912.00 11001 | snow mint wheat chocolate midnight | 912.00 12000 | coral cream firebrick magenta grey | 912.00 12 | peru ivory olive powder frosted | 912.01 4009 | brown sandy burnished medium cornsilk | 913.00 5008 | powder chocolate steel orange plum | 913.00 6007 | steel cornflower midnight moccasin dark | 913.00 7006 | linen khaki indian lime white | 913.00 8005 | violet salmon cornsilk misty chiffon | 913.00 12001 | cornflower lavender navy rosy khaki | 913.00 13000 | azure purple brown cornsilk puff | 913.00 1012 | dim linen puff lemon frosted | 913.01 2011 | royal antique burlywood powder cornflower | 913.01 3010 | hot green maroon deep medium | 913.01 5009 | cyan saddle ghost peach frosted | 914.00 6008 | saddle cornsilk bisque dark blanched | 914.00 7007 | black chocolate coral blanched firebrick | 914.00 8006 | blanched forest salmon dark floral | 914.00 9005 | indian seashell antique metallic royal | 914.00 11003 | antique ivory powder beige blush | 914.00 12002 | light blush gainsboro dodger drab | 914.00 13001 | forest ivory lavender khaki lace | 914.00 1013 | mint navajo beige burnished peach | 914.01 2012 | olive misty ivory cyan wheat | 914.01 6009 | navy drab powder mint sandy | 915.00 7008 | beige lawn dark spring smoke | 915.00 9006 | bisque slate rosy snow dark | 915.00 11004 | tan mint blanched navajo frosted | 915.00 12003 | lime rosy white lemon bisque | 915.00 13002 | mint floral azure light goldenrod | 915.00 15000 | snow burlywood orchid dim chocolate | 915.00 15 | navajo dark sky turquoise royal | 915.01 1014 | peach brown maroon green burlywood | 915.01 2013 | black lavender misty coral lawn | 915.01 4011 | violet indian aquamarine coral blush | 915.01 7009 | violet lace cornsilk frosted honeydew | 916.00 8008 | turquoise firebrick ivory cornsilk papaya | 916.00 9007 | blanched metallic turquoise lavender yellow | 916.00 10006 | azure dodger antique dark honeydew | 916.00 11005 | deep bisque chocolate blanched rose | 916.00 14002 | lemon chocolate cornflower medium indian | 916.00 15001 | navajo peru sky cyan blush | 916.00 16000 | metallic white frosted black spring | 916.00 16 | deep brown turquoise dim papaya | 916.01 1015 | salmon peach rose goldenrod burlywood | 916.01 4012 | dim chartreuse magenta navy orange | 916.01 5011 | black tan cyan indian forest | 916.01 6010 | lavender goldenrod gainsboro khaki dark | 916.01 8009 | gainsboro moccasin mint metallic bisque | 917.00 9008 | light tan burlywood burnished chiffon | 917.00 10007 | midnight indian peru purple ghost | 917.00 17000 | gainsboro salmon antique rosy khaki | 917.00 17 | burnished navy orange dodger cream | 917.01 2015 | drab beige dim midnight hot | 917.01 5012 | drab khaki grey chiffon green | 917.01 9009 | tan orange indian wheat chiffon | 918.00 11007 | pink chocolate aquamarine medium peach | 918.00 12006 | grey maroon peru smoke cream | 918.00 13005 | floral lime drab chartreuse chocolate | 918.00 14004 | forest chartreuse dim saddle ghost | 918.00 16002 | brown spring light chocolate olive | 918.00 1017 | lime blush yellow dodger brown | 918.01 2016 | chocolate violet goldenrod khaki steel | 918.01 4014 | papaya forest deep dim dark | 918.01 6012 | drab orange chartreuse cyan hot | 918.01 7011 | steel metallic violet peru sienna | 918.01 8010 | purple tan peach plum black | 918.01 12007 | chiffon rosy coral green papaya | 919.00 13006 | sky coral honeydew lemon snow | 919.00 14005 | wheat chiffon metallic olive thistle | 919.00 15004 | ivory goldenrod lemon firebrick light | 919.00 16003 | almond firebrick black rosy frosted | 919.00 19000 | cyan linen rosy azure violet | 919.00 19 | dodger forest floral cream black | 919.01 1018 | tan chartreuse wheat pink blanched | 919.01 2017 | dim rose salmon lemon honeydew | 919.01 3016 | peru smoke brown puff dark | 919.01 4015 | beige chiffon magenta cyan saddle | 919.01 6013 | linen tan rose honeydew sky | 919.01 7012 | seashell chiffon beige sky metallic | 919.01 11009 | tan chiffon burnished sky coral | 920.00 12008 | purple floral green honeydew sky | 920.00 13007 | smoke pale green white aquamarine | 920.00 14006 | maroon coral cream deep orange | 920.00 17003 | almond floral bisque rose ivory | 920.00 18002 | sky indian gainsboro antique ivory | 920.00 1019 | deep wheat blanched purple black | 920.01 2018 | seashell navajo yellow rose goldenrod | 920.01 4016 | khaki light royal papaya beige | 920.01 5015 | smoke lace burnished floral aquamarine | 920.01 6014 | red orange plum cornsilk seashell | 920.01 7013 | metallic puff steel pale cyan | 920.01 9011 | pale peach grey goldenrod black | 920.01 10010 | sienna dodger honeydew black beige | 920.01 12009 | firebrick sienna beige lime chocolate | 921.00 13008 | turquoise indian blanched wheat blue | 921.00 14007 | steel cream black dodger midnight | 921.00 16005 | firebrick midnight antique chocolate smoke | 921.00 17004 | beige hot gainsboro pale honeydew | 921.00 18003 | dodger sandy azure indian honeydew | 921.00 20001 | metallic navajo tomato blanched azure | 921.00 3018 | frosted chiffon black antique honeydew | 921.01 4017 | white snow brown thistle honeydew | 921.01 5016 | purple plum moccasin frosted lemon | 921.01 6015 | chartreuse chocolate lavender smoke ghost | 921.01 9012 | peru navajo peach aquamarine grey | 921.01 10011 | hot lawn burlywood papaya blanched | 921.01 21 | lemon aquamarine firebrick floral almond | 921.02 14008 | burnished royal lace steel frosted | 922.00 17005 | lavender honeydew burnished cornflower sienna | 922.00 18004 | almond maroon blue hot orange | 922.00 19003 | beige papaya drab light plum | 922.00 21001 | papaya turquoise cream burlywood lace | 922.00 22000 | chartreuse dodger azure chocolate midnight | 922.00 3019 | white blue khaki forest goldenrod | 922.01 4018 | lavender sienna blue cornflower mint | 922.01 5017 | cream forest maroon saddle lime | 922.01 7015 | blush aquamarine steel azure blue | 922.01 11011 | purple dark misty red beige | 922.01 1021 | azure maroon blanched purple lawn | 922.02 14009 | chocolate maroon cornsilk frosted linen | 923.00 15008 | blanched cornflower dark thistle linen | 923.00 16007 | rosy goldenrod maroon cornflower lavender | 923.00 17006 | light lavender tomato goldenrod grey | 923.00 19004 | hot dim cyan blue saddle | 923.00 21002 | drab smoke aquamarine slate grey | 923.00 22001 | ghost olive thistle yellow bisque | 923.00 4019 | black dark honeydew aquamarine antique | 923.01 6017 | chocolate red lavender dim medium | 923.01 7016 | salmon dodger powder peach floral | 923.01 9014 | sienna blue turquoise magenta yellow | 923.01 11012 | pale burlywood bisque forest yellow | 923.01 12011 | cyan rose gainsboro thistle floral | 923.01 23 | firebrick bisque slate rose blanched | 923.02 3020 | lace ghost thistle burnished beige | 923.02 15009 | honeydew frosted goldenrod smoke maroon | 924.00 19005 | frosted navajo linen khaki sandy | 924.00 20004 | drab dodger salmon violet cornflower | 924.00 21003 | snow ghost orchid azure plum | 924.00 23001 | dark cyan almond hot blush | 924.00 5019 | green firebrick grey gainsboro rosy | 924.01 6018 | lavender chocolate frosted moccasin peach | 924.01 7017 | chocolate metallic mint maroon sandy | 924.01 8016 | turquoise dim antique goldenrod powder | 924.01 9015 | beige azure lawn orchid cornsilk | 924.01 11013 | chiffon gainsboro dodger misty honeydew | 924.01 12012 | firebrick chartreuse metallic steel moccasin | 924.01 14010 | plum medium mint light blanched | 924.01 24 | saddle dim white honeydew spring | 924.02 4020 | cornflower dim maroon violet green | 924.02 16009 | dark brown plum bisque white | 925.00 18007 | goldenrod peru violet indian burlywood | 925.00 19006 | thistle turquoise honeydew bisque olive | 925.00 20005 | dim azure turquoise white sandy | 925.00 21004 | beige navajo spring grey peach | 925.00 23002 | antique black yellow chocolate sky | 925.00 24001 | lime peru lace midnight forest | 925.00 25000 | blanched puff yellow salmon burnished | 925.00 6019 | frosted cream almond burnished pink | 925.01 7018 | purple green tomato papaya dim | 925.01 9016 | magenta olive seashell deep red | 925.01 10015 | firebrick seashell dark chartreuse salmon | 925.01 11014 | misty peru lawn metallic green | 925.01 12013 | light aquamarine dim bisque slate | 925.01 14011 | deep dim cream bisque orchid | 925.01 25 | blush forest magenta metallic turquoise | 925.02 1024 | lawn sienna honeydew black mint | 925.02 3022 | brown bisque burlywood dim royal | 925.02 4021 | cornflower purple deep frosted tan | 925.02 17009 | dim papaya almond floral mint | 926.00 18008 | magenta violet cornsilk bisque white | 926.00 20006 | cyan violet light bisque midnight | 926.00 21005 | white cream yellow metallic grey | 926.00 23003 | spring orange steel grey lime | 926.00 26000 | azure misty lace blanched moccasin | 926.00 8018 | hot beige navy orange saddle | 926.01 9017 | peach grey snow rose lawn | 926.01 10016 | sky rosy olive forest powder | 926.01 12014 | seashell coral grey cyan saddle | 926.01 16010 | navajo metallic tomato blue goldenrod | 926.01 2024 | sky spring frosted slate chartreuse | 926.02 3023 | dark bisque lawn burnished blush | 926.02 5021 | gainsboro pink dodger rose chocolate | 926.02 18009 | cream red magenta chartreuse bisque | 927.00 19008 | blanched bisque yellow light firebrick | 927.00 22005 | seashell papaya plum cornsilk mint | 927.00 23004 | hot sky cream saddle sienna | 927.00 25002 | metallic smoke blanched drab almond | 927.00 8019 | chartreuse blue thistle cornsilk puff | 927.01 9018 | maroon navajo royal dim plum | 927.01 10017 | aquamarine grey brown salmon navy | 927.01 11016 | midnight aquamarine goldenrod rose metallic | 927.01 12015 | turquoise slate aquamarine blue ghost | 927.01 14013 | aquamarine olive orange wheat light | 927.01 4023 | blue chartreuse pale khaki seashell | 927.02 6021 | goldenrod honeydew seashell blanched thistle | 927.02 19009 | violet cyan lavender sienna chocolate | 928.00 21007 | azure cyan chiffon mint seashell | 928.00 22006 | frosted lemon lime brown rosy | 928.00 24004 | green misty lemon turquoise coral | 928.00 26002 | peach indian pale salmon cornsilk | 928.00 27001 | metallic chartreuse dim frosted pale | 928.00 28000 | brown red floral saddle dim | 928.00 9019 | magenta brown yellow dim tan | 928.01 10018 | wheat blue rose light burnished | 928.01 13015 | wheat pale misty cornsilk grey | 928.01 14014 | thistle salmon moccasin hot cream | 928.01 15013 | steel sienna black blue frosted | 928.01 17011 | dim chocolate spring misty blush | 928.01 18010 | sky pale steel dodger lemon | 928.01 2026 | frosted ivory almond puff floral | 928.02 3025 | rosy spring blush burlywood goldenrod | 928.02 4024 | azure dodger cream rose sienna | 928.02 5023 | antique azure chiffon goldenrod royal | 928.02 8020 | dark rosy steel navy cornflower | 928.02 20009 | lavender ivory blush black midnight | 929.00 21008 | navajo sandy brown black lemon | 929.00 22007 | peru chiffon coral almond misty | 929.00 23006 | tomato dodger cornflower hot cornsilk | 929.00 24005 | khaki chiffon drab navajo firebrick | 929.00 26003 | powder azure beige coral chocolate | 929.00 27002 | puff dim aquamarine lime orange | 929.00 29000 | grey deep gainsboro yellow forest | 929.00 11018 | beige olive coral seashell cornsilk | 929.01 12017 | bisque beige lace cream slate | 929.01 14015 | antique peru cornflower drab almond | 929.01 15014 | green black mint olive floral | 929.01 16013 | snow almond lemon gainsboro blanched | 929.01 17012 | pink turquoise lavender green hot | 929.01 19010 | misty burnished plum mint midnight | 929.01 2027 | cyan seashell pink blush goldenrod | 929.02 4025 | purple lime blush saddle dark | 929.02 5024 | navajo mint green peach metallic | 929.02 9020 | lawn honeydew olive dark magenta | 929.02 21009 | deep puff forest burnished peru | 930.00 22008 | lime dodger burnished goldenrod slate | 930.00 25005 | misty burnished cream lime yellow | 930.00 28002 | navy medium lemon orchid blanched | 930.00 14016 | thistle blush deep antique blanched | 930.01 17013 | salmon tomato midnight misty snow | 930.01 19011 | cornflower dim frosted brown tan | 930.01 20010 | navy salmon medium papaya hot | 930.01 1029 | purple rose khaki linen azure | 930.02 2028 | drab ivory azure forest yellow | 930.02 5025 | blush drab dim plum deep | 930.02 6024 | white blue navy purple goldenrod | 930.02 8022 | ivory firebrick tomato beige aquamarine | 930.02 9021 | burlywood burnished deep rose goldenrod | 930.02 30 | blush beige steel cyan navy | 930.03 22009 | chiffon aquamarine steel rosy white | 931.00 24007 | steel chiffon orange chocolate frosted | 931.00 25006 | hot spring metallic misty orange | 931.00 26005 | ghost blue plum olive peru | 931.00 27004 | lemon puff midnight khaki burnished | 931.00 28003 | cornflower deep lemon puff powder | 931.00 13018 | brown antique steel goldenrod almond | 931.01 14017 | blue chartreuse spring brown almond | 931.01 16015 | dark cream dim cornflower magenta | 931.01 17014 | rosy black spring wheat firebrick | 931.01 18013 | drab linen frosted dim orchid | 931.01 19012 | grey lime olive ghost light | 931.01 21010 | thistle lawn lemon moccasin peach | 931.01 3028 | yellow medium cornflower green misty | 931.02 4027 | sky indian lawn chiffon powder | 931.02 7024 | goldenrod rosy chiffon firebrick hot | 931.02 8023 | green dodger peru cornsilk pink | 931.02 10021 | brown chartreuse goldenrod seashell burnished | 931.02 31 | grey ghost steel maroon moccasin | 931.03 24008 | tan deep dim maroon forest | 932.00 26006 | tan grey medium azure dodger | 932.00 27005 | rose brown medium black midnight | 932.00 29003 | almond lime orange cyan blue | 932.00 30002 | chiffon blanched blue floral frosted | 932.00 31001 | aquamarine blush linen khaki azure | 932.00 32000 | black gainsboro burnished khaki orchid | 932.00 13019 | peach snow cyan lavender azure | 932.01 15017 | slate chocolate red medium steel | 932.01 16016 | linen grey blanched seashell blush | 932.01 17015 | brown ivory light black plum | 932.01 19013 | coral chartreuse tomato azure blue | 932.01 21011 | deep royal grey violet chocolate | 932.01 22010 | spring light salmon frosted black | 932.01 9023 | indian cornflower misty sandy goldenrod | 932.02 32 | yellow wheat midnight papaya blue | 932.03 1031 | firebrick red snow slate white | 932.03 25008 | bisque mint coral indian dodger | 933.00 26007 | maroon bisque khaki blue drab | 933.00 30003 | smoke orange lime cornflower mint | 933.00 32001 | burnished plum cornflower cream salmon | 933.00 33000 | deep mint blanched brown maroon | 933.00 14019 | drab chiffon magenta floral pale | 933.01 20013 | chocolate aquamarine lime cornsilk linen | 933.01 21012 | red beige olive white firebrick | 933.01 4029 | peru peach yellow metallic blanched | 933.02 7026 | blanched firebrick peru rose brown | 933.02 8025 | lemon khaki coral tan powder | 933.02 9024 | drab lime blush medium sienna | 933.02 10023 | firebrick steel lace dodger chiffon | 933.02 11022 | burnished goldenrod pale white purple | 933.02 13020 | chartreuse midnight khaki ivory rose | 933.02 33 | maroon beige mint cyan peru | 933.03 2031 | misty moccasin navajo lime wheat | 933.03 3030 | maroon chiffon light chartreuse drab | 933.03 25009 | dark chartreuse cream dodger ivory | 934.00 26008 | lemon violet coral floral peach | 934.00 28006 | green yellow dark frosted black | 934.00 29005 | gainsboro floral blush puff lime | 934.00 31003 | moccasin papaya cyan navy navajo | 934.00 33001 | chocolate moccasin dim frosted olive | 934.00 15019 | chartreuse green salmon light midnight | 934.01 16018 | chartreuse indian powder black lemon | 934.01 17017 | cream snow hot blush cyan | 934.01 18016 | firebrick spring peach cyan honeydew | 934.01 19015 | violet mint brown lavender tomato | 934.01 21013 | cream cornsilk orchid ivory forest | 934.01 24010 | cornflower white ivory deep cornsilk | 934.01 7027 | blush tan azure goldenrod maroon | 934.02 9025 | cornflower hot floral cornsilk medium | 934.02 10024 | spring navajo magenta yellow gainsboro | 934.02 12022 | olive royal ghost spring goldenrod | 934.02 13021 | sandy deep midnight saddle cornsilk | 934.02 14020 | magenta cream pale floral lavender | 934.02 34 | bisque pink dodger cream goldenrod | 934.03 1033 | blush chiffon midnight pink coral | 934.03 2032 | blanched purple royal chocolate burnished | 934.03 4030 | almond cornsilk maroon green antique | 934.03 26009 | bisque white azure goldenrod sandy | 935.00 28007 | floral wheat violet aquamarine turquoise | 935.00 29006 | turquoise medium chocolate grey antique | 935.00 31004 | powder coral sienna navajo lawn | 935.00 32003 | azure moccasin light dark blush | 935.00 35000 | saddle indian frosted metallic spring | 935.00 18017 | saddle steel dodger cyan azure | 935.01 19016 | honeydew green pale hot antique | 935.01 20015 | burnished rosy royal slate floral | 935.01 21014 | bisque green burnished white lace | 935.01 22013 | light pink beige ivory deep | 935.01 23012 | medium lace ivory peru cyan | 935.01 24011 | midnight turquoise purple chartreuse cornflower | 935.01 6029 | seashell misty azure gainsboro violet | 935.02 7028 | saddle orange cyan sandy floral | 935.02 11024 | ivory grey bisque cornsilk seashell | 935.02 13022 | mint chocolate antique midnight lavender | 935.02 15020 | cornsilk dark smoke lemon black | 935.02 35 | green blue coral antique sandy | 935.03 1034 | lime ivory sky gainsboro mint | 935.03 2033 | frosted misty cream pale sienna | 935.03 3032 | firebrick smoke goldenrod grey antique | 935.03 5030 | firebrick forest sandy tomato brown | 935.03 27009 | olive pink bisque lace blush | 936.00 28008 | moccasin deep ghost thistle maroon | 936.00 30006 | medium peach metallic floral burlywood | 936.00 31005 | aquamarine hot blue mint honeydew | 936.00 32004 | chartreuse frosted cyan yellow lawn | 936.00 33003 | seashell chartreuse metallic drab yellow | 936.00 34002 | azure ghost chiffon magenta slate | 936.00 36000 | royal pink purple chocolate coral | 936.00 18018 | moccasin cornflower burlywood tan mint | 936.01 19017 | ivory smoke ghost goldenrod medium | 936.01 20016 | cornsilk blue purple lace chiffon | 936.01 21015 | lawn honeydew peach moccasin cyan | 936.01 24012 | green orchid honeydew steel navy | 936.01 25011 | chocolate forest papaya azure sandy | 936.01 8028 | orange coral dodger metallic lemon | 936.02 9027 | azure wheat hot beige chartreuse | 936.02 12024 | spring hot dark tan thistle | 936.02 13023 | blanched cornsilk salmon dodger indian | 936.02 14022 | dodger red royal burlywood olive | 936.02 15021 | azure lawn plum drab cream | 936.02 16020 | orchid beige honeydew puff slate | 936.02 36 | chiffon smoke floral misty navy | 936.03 3033 | almond grey cornsilk papaya peach | 936.03 4032 | slate royal drab almond sienna | 936.03 5031 | orchid puff purple chiffon navy | 936.03 29008 | red white lawn light blanched | 937.00 32005 | bisque olive honeydew chiffon yellow | 937.00 33004 | blue burlywood chocolate brown tan | 937.00 34003 | medium plum honeydew blush brown | 937.00 35002 | misty ivory antique papaya ghost | 937.00 36001 | seashell hot tan cream misty | 937.00 37000 | peach smoke chiffon chocolate pink | 937.00 18019 | tan brown linen chiffon ghost | 937.01 19018 | lawn peach cornsilk steel grey | 937.01 23014 | bisque royal misty rosy antique | 937.01 24013 | peach lime blush dark sienna | 937.01 25012 | steel spring antique beige navy | 937.01 27010 | khaki violet bisque sky forest | 937.01 10027 | floral medium dark yellow coral | 937.02 12025 | maroon sandy magenta saddle bisque | 937.02 13024 | dark honeydew wheat burnished midnight | 937.02 14023 | navajo lawn peach bisque ghost | 937.02 15022 | tomato mint khaki peru pale | 937.02 1036 | honeydew lawn moccasin papaya tan | 937.03 3034 | burlywood burnished sandy lawn powder | 937.03 4033 | drab dodger violet blush antique | 937.03 5032 | spring hot tomato navajo puff | 937.03 6031 | ivory black blanched maroon sienna | 937.03 29009 | coral indian firebrick moccasin green | 938.00 30008 | aquamarine floral firebrick moccasin violet | 938.00 31007 | papaya lawn sky azure goldenrod | 938.00 32006 | chartreuse tomato cornsilk cornflower burnished | 938.00 35003 | green metallic rose turquoise lawn | 938.00 36002 | peach burlywood tan deep lace | 938.00 37001 | honeydew goldenrod ghost seashell tomato | 938.00 22016 | bisque cornflower violet chiffon dim | 938.01 24014 | hot ghost sky lemon bisque | 938.01 26012 | indian hot forest maroon blue | 938.01 27011 | cyan chiffon seashell medium lime | 938.01 28010 | beige khaki papaya cream bisque | 938.01 9029 | black cream peru sandy hot | 938.02 13025 | midnight azure ghost ivory bisque | 938.02 15023 | blush dodger slate ghost aquamarine | 938.02 16022 | purple black drab tan chiffon | 938.02 18020 | chiffon beige blush grey violet | 938.02 38 | seashell floral bisque midnight black | 938.03 1037 | violet sky chiffon drab lawn | 938.03 5033 | floral bisque beige midnight hot | 938.03 7031 | moccasin salmon green blush metallic | 938.03 8030 | rosy coral ivory violet khaki | 938.03 30009 | royal brown chocolate light cornflower | 939.00 31008 | brown spring wheat blush burnished | 939.00 32007 | olive dim hot seashell orchid | 939.00 34005 | chartreuse magenta turquoise burnished linen | 939.00 36003 | wheat blue honeydew slate grey | 939.00 37002 | pale antique cyan black blue | 939.00 39000 | midnight navy rose orchid plum | 939.00 20019 | rose red thistle orange floral | 939.01 22017 | burnished powder mint green misty | 939.01 24015 | papaya dodger firebrick purple rose | 939.01 27012 | dodger lace puff cyan cornsilk | 939.01 29010 | green papaya chartreuse dark firebrick | 939.01 10029 | cornsilk deep misty puff bisque | 939.02 12027 | midnight floral green forest chartreuse | 939.02 18021 | azure green floral brown dodger | 939.02 19020 | cyan steel brown sky dodger | 939.02 39 | rose dodger lace peru floral | 939.03 1038 | floral blue grey bisque saddle | 939.03 2037 | grey almond puff floral navy | 939.03 3036 | puff slate coral lace sandy | 939.03 4035 | thistle violet bisque magenta dim | 939.03 5034 | goldenrod seashell beige metallic lavender | 939.03 6033 | olive green linen saddle moccasin | 939.03 7032 | cornflower brown chartreuse lime white | 939.03 9030 | khaki orange beige dim antique | 939.03 (500 rows) QUERY #8 ps_partkey | ps_suppkey | min_supplycost ------------+------------+---------------- 1 | 5002 | 337.09 2 | 7503 | 306.39 3 | 7504 | 191.92 4 | 5005 | 51.37 5 | 2506 | 50.52 6 | 7 | 130.72 7 | 5008 | 68.77 8 | 5009 | 220.62 9 | 10 | 84.20 10 | 5011 | 164.00 11 | 7512 | 471.98 12 | 2513 | 332.81 13 | 5014 | 38.64 14 | 7515 | 310.13 15 | 5016 | 265.89 16 | 17 | 709.16 17 | 7518 | 64.40 18 | 2519 | 52.44 19 | 20 | 144.80 20 | 7521 | 115.89 21 | 2522 | 139.05 22 | 5023 | 359.16 23 | 7524 | 51.75 24 | 7525 | 62.15 25 | 5026 | 694.35 26 | 5027 | 382.11 27 | 5028 | 151.34 28 | 29 | 204.86 29 | 7530 | 186.21 30 | 5031 | 568.86 31 | 2532 | 120.99 32 | 2533 | 109.34 33 | 5034 | 310.76 34 | 2535 | 265.31 35 | 7536 | 411.17 36 | 7537 | 289.15 37 | 5038 | 15.72 38 | 5039 | 160.70 39 | 2540 | 300.43 40 | 7541 | 196.64 41 | 7542 | 37.59 42 | 7543 | 29.46 43 | 7544 | 307.12 44 | 2545 | 114.37 45 | 7546 | 155.32 46 | 5047 | 14.78 47 | 5048 | 74.54 48 | 2549 | 191.36 49 | 50 | 35.11 50 | 7551 | 107.17 51 | 2552 | 85.03 52 | 53 | 54.92 53 | 54 | 192.78 54 | 5055 | 23.78 55 | 7556 | 130.33 56 | 5057 | 52.29 57 | 58 | 123.11 58 | 7559 | 25.09 59 | 7560 | 45.50 60 | 7561 | 92.64 61 | 7562 | 153.74 62 | 7563 | 255.78 63 | 5064 | 274.15 64 | 7565 | 25.77 65 | 7566 | 288.73 66 | 5067 | 447.08 67 | 68 | 306.37 68 | 2569 | 5.16 69 | 7570 | 344.28 70 | 7571 | 182.58 71 | 2572 | 239.57 72 | 2573 | 41.04 73 | 5074 | 108.96 74 | 75 | 345.92 75 | 5076 | 433.59 76 | 2577 | 108.97 77 | 78 | 254.92 78 | 7579 | 382.82 79 | 2580 | 28.33 80 | 81 | 127.65 81 | 2582 | 220.23 82 | 2583 | 585.86 83 | 7584 | 24.73 84 | 85 | 233.61 85 | 7586 | 73.81 86 | 87 | 65.98 87 | 2588 | 435.42 88 | 2589 | 71.50 89 | 5090 | 417.61 90 | 7591 | 50.84 91 | 92 | 528.64 92 | 5093 | 91.63 93 | 2594 | 376.47 94 | 2595 | 358.08 95 | 96 | 291.03 96 | 97 | 202.06 97 | 98 | 129.77 98 | 5099 | 139.00 99 | 5100 | 365.83 100 | 7601 | 22.00 101 | 2602 | 218.71 102 | 7603 | 231.02 103 | 5104 | 361.48 104 | 2605 | 15.57 105 | 106 | 27.75 106 | 7607 | 281.98 107 | 2608 | 91.31 108 | 2609 | 241.47 109 | 110 | 275.19 110 | 2611 | 183.47 111 | 112 | 321.97 112 | 113 | 111.42 113 | 7614 | 141.48 114 | 5115 | 382.87 115 | 7616 | 81.52 116 | 7617 | 37.30 117 | 2618 | 322.08 118 | 5119 | 283.27 119 | 120 | 473.64 120 | 121 | 201.21 121 | 122 | 147.45 122 | 123 | 451.29 123 | 124 | 107.03 124 | 7625 | 822.78 125 | 126 | 358.45 126 | 2627 | 194.38 127 | 5128 | 3.14 128 | 2629 | 224.49 129 | 7630 | 27.22 130 | 131 | 223.38 131 | 132 | 211.70 132 | 7633 | 353.06 133 | 134 | 49.17 134 | 2635 | 102.99 135 | 2636 | 9.83 136 | 5137 | 387.57 137 | 7638 | 187.31 138 | 5139 | 119.83 139 | 140 | 285.75 140 | 5141 | 45.84 141 | 2642 | 139.18 142 | 2643 | 334.33 143 | 7644 | 199.37 144 | 7645 | 361.83 145 | 5146 | 422.60 146 | 2647 | 123.91 147 | 2648 | 102.19 148 | 149 | 177.40 149 | 2650 | 201.03 150 | 5151 | 33.71 151 | 5152 | 71.68 152 | 5153 | 77.38 153 | 7654 | 285.92 154 | 7655 | 160.31 155 | 156 | 222.02 156 | 7657 | 9.87 157 | 7658 | 288.41 158 | 159 | 408.72 159 | 5160 | 171.40 160 | 161 | 525.73 161 | 2662 | 394.05 162 | 2663 | 104.20 163 | 2664 | 499.51 164 | 7665 | 64.89 165 | 7666 | 210.84 166 | 167 | 309.00 167 | 5168 | 336.75 168 | 169 | 394.83 169 | 7670 | 476.19 170 | 7671 | 202.07 171 | 5172 | 22.69 172 | 173 | 184.96 173 | 2674 | 70.22 174 | 7675 | 126.20 175 | 176 | 487.68 176 | 2677 | 157.38 177 | 178 | 44.75 178 | 2679 | 362.26 179 | 7680 | 8.39 180 | 5181 | 426.16 181 | 7682 | 657.25 182 | 7683 | 365.00 183 | 2684 | 424.86 184 | 7685 | 186.84 185 | 2686 | 213.04 186 | 2687 | 18.75 187 | 188 | 238.66 188 | 2689 | 331.70 189 | 190 | 392.50 190 | 5191 | 396.60 191 | 7692 | 119.41 192 | 193 | 198.69 193 | 194 | 335.98 194 | 7695 | 79.40 195 | 196 | 20.39 196 | 5197 | 37.61 197 | 2698 | 279.05 198 | 5199 | 166.93 199 | 2700 | 46.52 200 | 2701 | 242.52 201 | 202 | 280.98 202 | 5203 | 160.45 203 | 204 | 399.16 204 | 5205 | 172.65 205 | 7706 | 123.08 206 | 2707 | 362.30 207 | 208 | 335.16 208 | 2709 | 54.46 209 | 5210 | 81.80 210 | 7711 | 259.05 211 | 212 | 475.68 212 | 7713 | 318.74 213 | 214 | 565.71 214 | 5215 | 17.50 215 | 5216 | 636.10 216 | 5217 | 25.22 217 | 5218 | 463.83 218 | 5219 | 55.36 219 | 7720 | 1.43 220 | 7721 | 297.83 221 | 7722 | 80.70 222 | 2723 | 422.77 223 | 7724 | 287.24 224 | 2725 | 252.76 225 | 2726 | 116.17 226 | 7727 | 58.38 227 | 228 | 453.33 228 | 7729 | 133.30 229 | 2730 | 497.84 230 | 7731 | 491.83 231 | 2732 | 253.34 232 | 233 | 42.14 233 | 5234 | 372.96 234 | 2735 | 194.46 235 | 2736 | 96.25 236 | 5237 | 192.44 237 | 7738 | 67.83 238 | 7739 | 171.18 239 | 240 | 155.22 240 | 241 | 91.89 241 | 7742 | 520.41 242 | 2743 | 97.24 243 | 2744 | 618.10 244 | 245 | 148.84 245 | 5246 | 79.54 246 | 5247 | 170.68 247 | 248 | 58.15 248 | 249 | 65.54 249 | 2750 | 50.74 250 | 7751 | 281.06 251 | 2752 | 154.11 252 | 253 | 168.05 253 | 2754 | 515.91 254 | 255 | 111.11 255 | 2756 | 225.64 256 | 5257 | 33.72 257 | 258 | 391.32 258 | 259 | 310.17 259 | 7760 | 12.99 260 | 2761 | 11.99 261 | 2762 | 2.47 262 | 263 | 11.82 263 | 264 | 123.18 264 | 2765 | 239.05 265 | 5266 | 72.22 266 | 267 | 262.17 267 | 7768 | 111.49 268 | 5269 | 742.57 269 | 2770 | 750.77 270 | 7771 | 8.87 271 | 5272 | 202.41 272 | 7773 | 13.85 273 | 2774 | 26.34 274 | 7775 | 71.95 275 | 2776 | 88.24 276 | 277 | 210.08 277 | 5278 | 210.21 278 | 5279 | 67.03 279 | 7780 | 340.51 280 | 5281 | 538.74 281 | 2782 | 15.41 282 | 283 | 37.01 283 | 2784 | 125.39 284 | 285 | 261.10 285 | 7786 | 12.85 286 | 287 | 376.75 287 | 288 | 219.71 288 | 7789 | 6.69 289 | 7790 | 519.98 290 | 291 | 197.07 291 | 2792 | 219.57 292 | 5293 | 143.75 293 | 7794 | 323.62 294 | 7795 | 324.37 295 | 7796 | 45.25 296 | 5297 | 175.09 297 | 5298 | 281.94 298 | 7799 | 18.20 299 | 5300 | 248.11 300 | 2801 | 190.59 301 | 302 | 251.11 302 | 2803 | 38.78 303 | 7804 | 106.23 304 | 2805 | 315.96 305 | 306 | 105.28 306 | 7807 | 33.95 307 | 308 | 354.10 308 | 2809 | 169.31 309 | 310 | 12.41 310 | 7811 | 185.63 311 | 2812 | 62.15 312 | 2813 | 3.01 313 | 314 | 413.31 314 | 5315 | 85.10 315 | 5316 | 536.31 316 | 7817 | 325.50 317 | 7818 | 319.63 318 | 7819 | 209.06 319 | 5320 | 326.82 320 | 2821 | 309.83 321 | 322 | 42.75 322 | 7823 | 134.72 323 | 5324 | 131.93 324 | 2825 | 473.94 325 | 2826 | 314.81 326 | 2827 | 592.60 327 | 5328 | 51.95 328 | 5329 | 213.64 329 | 7830 | 167.54 330 | 7831 | 183.79 331 | 2832 | 176.15 332 | 2833 | 151.88 333 | 334 | 249.97 334 | 7835 | 406.96 335 | 7836 | 130.57 336 | 7837 | 339.32 337 | 5338 | 229.87 338 | 2839 | 73.37 339 | 2840 | 48.45 340 | 5341 | 415.14 341 | 5342 | 125.74 342 | 7843 | 79.22 343 | 344 | 18.48 344 | 345 | 60.81 345 | 5346 | 638.37 346 | 347 | 26.92 347 | 348 | 8.56 348 | 7849 | 452.86 349 | 5350 | 205.04 350 | 351 | 286.09 351 | 5352 | 107.33 352 | 7853 | 422.98 353 | 354 | 250.61 354 | 355 | 517.87 355 | 7856 | 328.97 356 | 7857 | 308.49 357 | 358 | 169.85 358 | 7859 | 27.27 359 | 360 | 67.67 360 | 2861 | 362.25 361 | 2862 | 32.98 362 | 363 | 309.21 363 | 5364 | 373.26 364 | 7865 | 325.86 365 | 2866 | 290.80 366 | 367 | 161.03 367 | 368 | 232.30 368 | 5369 | 283.24 369 | 370 | 621.06 370 | 7871 | 552.41 371 | 7872 | 47.59 372 | 7873 | 332.86 373 | 5374 | 81.94 374 | 7875 | 150.28 375 | 7876 | 151.67 376 | 7877 | 39.91 377 | 2878 | 296.70 378 | 7879 | 34.65 379 | 380 | 243.36 380 | 2881 | 134.72 381 | 5382 | 10.65 382 | 5383 | 14.97 383 | 2884 | 484.18 384 | 2885 | 45.13 385 | 7886 | 121.60 386 | 387 | 60.71 387 | 7888 | 140.71 388 | 5389 | 358.91 389 | 5390 | 265.01 390 | 2891 | 115.98 391 | 5392 | 274.87 392 | 5393 | 123.85 393 | 7894 | 164.27 394 | 2895 | 203.54 395 | 2896 | 472.77 396 | 7897 | 504.86 397 | 5398 | 140.07 398 | 7899 | 323.53 399 | 400 | 298.29 400 | 7901 | 40.65 401 | 5402 | 170.75 402 | 403 | 17.55 403 | 5404 | 469.60 404 | 405 | 462.90 405 | 7906 | 358.83 406 | 407 | 91.03 407 | 7908 | 294.33 408 | 409 | 35.25 409 | 7910 | 148.11 410 | 411 | 89.08 411 | 5412 | 245.29 412 | 7913 | 429.35 413 | 2914 | 80.56 414 | 415 | 83.28 415 | 5416 | 258.51 416 | 2917 | 615.06 417 | 5418 | 287.83 418 | 5419 | 213.36 419 | 7920 | 105.12 420 | 2921 | 476.15 421 | 2922 | 234.57 422 | 7923 | 323.23 423 | 5424 | 50.19 424 | 7925 | 48.30 425 | 2926 | 325.76 426 | 7927 | 213.28 427 | 5428 | 128.74 428 | 2929 | 179.41 429 | 5430 | 43.51 430 | 5431 | 291.06 431 | 2932 | 143.64 432 | 2933 | 280.03 433 | 7934 | 102.32 434 | 2935 | 74.66 435 | 7936 | 224.91 436 | 5437 | 26.74 437 | 7938 | 341.75 438 | 5439 | 284.39 439 | 7940 | 178.61 440 | 2941 | 16.89 441 | 2942 | 160.16 442 | 7943 | 497.52 443 | 2944 | 33.49 444 | 445 | 61.36 445 | 7946 | 641.72 446 | 7947 | 119.31 447 | 5448 | 260.26 448 | 2949 | 133.27 449 | 5450 | 35.69 450 | 451 | 118.60 451 | 452 | 112.26 452 | 7953 | 494.85 453 | 2954 | 202.70 454 | 5455 | 195.33 455 | 456 | 482.68 456 | 457 | 50.22 457 | 7958 | 178.97 458 | 459 | 118.01 459 | 460 | 43.89 460 | 5461 | 120.67 461 | 2962 | 441.86 462 | 7963 | 28.16 463 | 2964 | 19.04 464 | 7965 | 19.18 465 | 7966 | 122.39 466 | 2967 | 201.80 467 | 2968 | 226.09 468 | 7969 | 22.03 469 | 2970 | 802.25 470 | 2971 | 193.64 471 | 7972 | 9.34 472 | 5473 | 102.02 473 | 2974 | 46.60 474 | 7975 | 67.76 475 | 476 | 250.52 476 | 477 | 177.86 477 | 2978 | 167.95 478 | 5479 | 107.59 479 | 7980 | 4.02 480 | 2981 | 130.96 481 | 7982 | 56.20 482 | 7983 | 336.60 483 | 484 | 133.44 484 | 7985 | 218.97 485 | 486 | 109.26 486 | 487 | 595.51 487 | 488 | 46.84 488 | 489 | 9.73 489 | 2990 | 174.34 490 | 491 | 17.68 491 | 492 | 115.31 492 | 493 | 359.98 493 | 7994 | 237.16 494 | 495 | 153.49 495 | 2996 | 14.27 496 | 2997 | 86.66 497 | 498 | 152.41 498 | 7999 | 303.88 499 | 3000 | 481.78 500 | 8001 | 30.89 (500 rows) QUERY #9 o_orderkey | o_custkey | o_orderstatus ------------+-----------+--------------- 2 | 78002 | O 36 | 115252 | O 128 | 73957 | F 228 | 44078 | F 324 | 105155 | F 423 | 103396 | O 452 | 59560 | O 550 | 23524 | O 673 | 79148 | F 706 | 147367 | O 934 | 51295 | O 996 | 70915 | O 1056 | 27494 | F 1062 | 104914 | O 1091 | 82777 | O 1249 | 149620 | F 1313 | 147671 | F 1351 | 105941 | O 1798 | 51518 | O 1858 | 142186 | O 1894 | 74996 | F 2663 | 94012 | O 2787 | 102814 | O 2788 | 123353 | F 3237 | 18148 | F 3330 | 6442 | F 3398 | 66703 | O 3424 | 101206 | O 3431 | 46297 | F 3681 | 51580 | F 3938 | 29617 | F 4003 | 110048 | F 4358 | 23518 | O 4420 | 108965 | F 4582 | 18208 | O 5026 | 27061 | O 5058 | 118945 | O 5120 | 15439 | O 5123 | 9623 | O 5440 | 129038 | O 5508 | 55661 | O 5667 | 43373 | O 5732 | 35117 | O 6273 | 4124 | F 6279 | 110806 | F 6466 | 16900 | O 6530 | 6235 | O 6595 | 88006 | F 6624 | 112927 | O 6787 | 11536 | O 6945 | 68297 | F 7012 | 139442 | O 7043 | 36377 | F 7074 | 112433 | F 7139 | 141877 | O 7175 | 127523 | F 7460 | 39037 | O 7781 | 124843 | O 7808 | 124135 | O 7815 | 33803 | F 8032 | 13264 | F 8775 | 82171 | F 8839 | 92806 | F 8865 | 63268 | F 9220 | 48169 | O 9607 | 64250 | O 10016 | 129487 | F 10084 | 142355 | O 10114 | 106345 | F 10118 | 74035 | F 10151 | 58786 | F 10464 | 23233 | F 10753 | 142903 | F 11328 | 46444 | F 11367 | 41723 | F 11552 | 142051 | F 11559 | 92966 | O 11810 | 64637 | F 11942 | 132259 | F 12003 | 120499 | O 12133 | 35926 | F 12192 | 27556 | F 12291 | 73930 | O 12325 | 97159 | F 12416 | 114889 | F 12454 | 21583 | O 12673 | 6127 | F 12870 | 136567 | F 13058 | 115462 | O 13189 | 9212 | F 13574 | 15077 | O 13637 | 18778 | O 13700 | 106249 | F 13766 | 138610 | F 13857 | 27460 | O 14213 | 47678 | F 14305 | 142660 | O 14625 | 107393 | F 14690 | 93425 | O 14724 | 139562 | O 14788 | 119026 | O 14982 | 146170 | F 15013 | 135853 | F 15076 | 56611 | O 15110 | 139639 | F 15203 | 12868 | O 15367 | 1948 | F 15492 | 98378 | F 15526 | 68134 | O 15584 | 133876 | O 15623 | 34213 | F 15649 | 83177 | O 15844 | 31384 | F 16160 | 58037 | O 16226 | 25381 | O 16327 | 69178 | F 16482 | 60769 | F 16484 | 6541 | O 16672 | 24170 | O 16770 | 88364 | F 16964 | 19625 | O 17223 | 15047 | F 17284 | 140918 | F 17510 | 89462 | F 17574 | 32680 | O 17602 | 38300 | F 17607 | 103792 | F 17925 | 131336 | F 18310 | 132205 | F 18341 | 118198 | F 18373 | 20635 | F 18531 | 36581 | F 18721 | 57731 | F 18752 | 146690 | O 18759 | 107579 | O 18915 | 24928 | F 18983 | 74005 | F 19009 | 98957 | F 19202 | 13778 | O 19715 | 104572 | F 20033 | 3877 | F 20609 | 59797 | F 20611 | 132056 | O 20672 | 115705 | F 20935 | 99547 | O 21059 | 53518 | F 21218 | 15190 | O 21348 | 11672 | F 21381 | 25930 | F 22087 | 45607 | F 22179 | 125251 | F 22405 | 127933 | O 22753 | 27512 | F 22919 | 74744 | F 23365 | 49223 | O 23715 | 71432 | O 23810 | 147635 | F 24001 | 63643 | O 24199 | 97558 | F 24261 | 18037 | F 24295 | 46564 | O 24513 | 136990 | O 24583 | 128644 | O 24742 | 132821 | F 25057 | 31876 | O 25344 | 34192 | O 25379 | 45982 | O 25571 | 85298 | F 25700 | 100894 | O 25764 | 111934 | O 25827 | 89957 | O 26369 | 120703 | F 26435 | 13972 | F 26438 | 50510 | O 26467 | 115717 | O 26562 | 131161 | O 26820 | 84580 | F 26917 | 13990 | O 26944 | 147896 | F 27207 | 1502 | O 27332 | 10798 | O 27650 | 25835 | F 27744 | 74389 | F 28096 | 106564 | O 28229 | 98557 | O 28353 | 23807 | F 28356 | 84019 | O 28453 | 72902 | F 28583 | 136078 | F 28609 | 98192 | O 28647 | 135041 | F 28706 | 104099 | F 28800 | 18325 | O 29124 | 112634 | F 29157 | 35731 | O 29184 | 62614 | F 29189 | 124609 | F 29190 | 126062 | O 29251 | 129505 | O 29286 | 11044 | F 29412 | 94360 | F 29573 | 25561 | F 29575 | 84326 | F 29828 | 88432 | O 29990 | 25415 | F 30150 | 118282 | F 30177 | 27785 | F 30309 | 55012 | O 30496 | 54913 | O 30502 | 24577 | F 30688 | 116599 | O 30816 | 107491 | O 30946 | 19975 | F 30982 | 124777 | O 31140 | 118238 | F 31334 | 7454 | O 31905 | 38852 | O 31975 | 100435 | F 32035 | 110545 | O 32068 | 11423 | F 32545 | 74050 | O 32551 | 85718 | O 32576 | 53830 | O 32612 | 116878 | F 32677 | 65176 | O 32706 | 107020 | F 32834 | 55802 | F 32867 | 81067 | O 32997 | 142894 | O 33059 | 117127 | F 33154 | 10000 | F 33188 | 94747 | O 33221 | 137957 | O 33287 | 144370 | O 33348 | 97639 | F 33443 | 677 | F 33632 | 135982 | F 33733 | 121114 | F 34021 | 146332 | O 34183 | 144352 | F 34496 | 32509 | F 34561 | 104869 | F 34594 | 126466 | F 34656 | 74830 | O 34785 | 14812 | F 34944 | 33778 | O 35138 | 97297 | O 35329 | 62606 | O 35972 | 976 | F 36000 | 106199 | F 36165 | 30760 | O 36259 | 44092 | O 36288 | 86113 | F 36615 | 105043 | F 37030 | 28583 | O 37187 | 69070 | O 37217 | 102809 | O 37350 | 32684 | F 37509 | 90821 | O 37892 | 112468 | F 38144 | 80848 | O 38368 | 18110 | F 38469 | 63430 | O 38500 | 98863 | F 38627 | 27623 | F 38819 | 15412 | F 38946 | 142681 | O 39203 | 73231 | F 39271 | 130522 | O 39622 | 34516 | O 39942 | 71164 | F 40037 | 144149 | F 40519 | 7942 | F 40576 | 87778 | F 40768 | 31840 | O 40773 | 33712 | F 40805 | 137731 | F 41159 | 57457 | O 41344 | 19259 | F 41414 | 22177 | F 41507 | 70523 | F 41698 | 49036 | O 41925 | 139390 | O 42182 | 115046 | F 42371 | 111466 | O 42468 | 101294 | F 42789 | 90239 | F 43169 | 27670 | F 43174 | 112163 | O 43397 | 95398 | F 43459 | 100894 | O 43652 | 62590 | O 43748 | 65024 | F 43840 | 123208 | O 43970 | 69979 | F 44033 | 136951 | F 44291 | 21211 | O 44773 | 97375 | O 44902 | 31390 | O 44931 | 106954 | O 44934 | 574 | F 45124 | 39173 | O 45191 | 75064 | F 45344 | 149255 | F 45415 | 2761 | F 45445 | 102658 | O 45479 | 144406 | O 45829 | 51265 | O 45894 | 127514 | O 46150 | 41450 | F 46373 | 57472 | O 46464 | 58369 | O 46535 | 56293 | F 46594 | 148792 | O 46663 | 19754 | O 46880 | 130645 | F 46951 | 385 | O 47047 | 48943 | F 47201 | 22909 | F 47233 | 30533 | F 47238 | 30094 | F 47333 | 40783 | O 47587 | 115189 | O 47619 | 38752 | F 47623 | 57820 | F 47649 | 42049 | F 47778 | 94688 | F 47782 | 138524 | F 48033 | 65983 | O 48069 | 73015 | O 48099 | 33125 | O 48256 | 135838 | F 48417 | 30904 | O 48871 | 39481 | O 48903 | 146248 | F 49028 | 63892 | O 49222 | 58910 | O 49573 | 88106 | O 49606 | 134333 | F 50085 | 109937 | O 50178 | 43387 | F 50244 | 44942 | F 50273 | 82255 | F 50368 | 70588 | F 50464 | 82993 | O 50817 | 119264 | O 51430 | 126565 | O 51456 | 92335 | F 51523 | 69424 | F 51716 | 52502 | O 51779 | 130192 | O 51841 | 140324 | O 51876 | 35210 | F 52418 | 13237 | O 52610 | 105466 | F 52677 | 31886 | F 52679 | 11605 | O 52804 | 107431 | F 53031 | 6485 | O 53092 | 7624 | O 53251 | 89888 | F 53410 | 108472 | F 53602 | 113578 | F 53632 | 71920 | F 53697 | 61789 | F 53734 | 121744 | O 53796 | 102745 | F 53860 | 110287 | F 53955 | 96085 | F 54055 | 78085 | F 54150 | 135317 | O 54530 | 76820 | F 54535 | 25009 | O 54689 | 77098 | F 54849 | 104587 | O 54915 | 22567 | O 55109 | 33268 | O 55301 | 122516 | F 55589 | 5707 | F 55622 | 42941 | F 55682 | 37669 | F 55879 | 125437 | F 56325 | 20413 | O 56353 | 67757 | O 56676 | 132875 | F 56775 | 881 | F 56935 | 114362 | F 57156 | 30104 | O 57157 | 1249 | F 57351 | 71368 | O 57637 | 111394 | O 57990 | 79432 | F 58050 | 76397 | F 58112 | 78506 | O 58119 | 136826 | F 58305 | 115648 | F 58563 | 131563 | F 58567 | 110299 | O 58721 | 146251 | O 58853 | 37333 | F 59040 | 23194 | O 59712 | 52654 | F 59908 | 24188 | F 59970 | 96920 | O 60034 | 96445 | F 60039 | 68509 | F 60295 | 100366 | O 60609 | 124942 | O 60646 | 29419 | F 61313 | 79772 | F 61698 | 16627 | O 61731 | 28280 | O 61732 | 93677 | O 62182 | 84091 | F 62245 | 9715 | F 62338 | 1006 | F 62497 | 71561 | O 62529 | 76928 | O 62535 | 110681 | F 62562 | 4105 | F 62951 | 53446 | O 63075 | 91027 | F 63232 | 33028 | F 63559 | 41702 | O 63843 | 21073 | O 63877 | 112336 | F 63879 | 78473 | F 64100 | 19603 | O 64259 | 112063 | O 64260 | 36397 | F 64546 | 100543 | O 64738 | 54461 | O 64804 | 110186 | F 64903 | 32836 | O 65382 | 143905 | O 65440 | 135970 | F 65702 | 7088 | F 65733 | 19681 | O 65826 | 126077 | O 65984 | 70555 | F 66084 | 22078 | F 66243 | 80842 | F 66466 | 146131 | O 66694 | 14218 | O 66788 | 14980 | O 67014 | 103207 | F 67047 | 34181 | O 67365 | 107179 | F 67552 | 14890 | F 67588 | 58243 | O 67906 | 27058 | O 67973 | 23429 | F 68229 | 148640 | F 68288 | 109045 | O 68325 | 87737 | F 68327 | 11516 | F 68352 | 36832 | F 68389 | 46007 | O 68580 | 140606 | O 68583 | 59728 | F 68934 | 3089 | F 68996 | 36886 | F 69060 | 65513 | F 69152 | 103208 | F 69154 | 3217 | O 69412 | 95722 | O 69415 | 131875 | F 69634 | 51259 | F 69733 | 41995 | F 69857 | 118975 | O 70244 | 138977 | F 70340 | 30424 | F 70498 | 34717 | F 70566 | 122378 | F 70690 | 107744 | F 70725 | 91330 | F 70848 | 22268 | O 71234 | 54869 | F 71329 | 96086 | F 71745 | 99704 | O 72096 | 126568 | O 72353 | 101224 | F 72384 | 80456 | F 72679 | 63515 | O 72769 | 17840 | O 72870 | 82720 | O 72928 | 98258 | F 73474 | 110698 | F 73600 | 113446 | O 73637 | 138142 | O 73893 | 40330 | F 74022 | 126290 | O 74084 | 126521 | F 74178 | 91387 | F 74215 | 5869 | F 74402 | 102197 | F 74405 | 121366 | F 74465 | 127424 | O 74496 | 144550 | F 74561 | 113149 | O (500 rows) QUERY #10 p_partkey | p_name | p_retailprice -----------+--------------------------------------------+--------------- 29097 | dark khaki burlywood coral thistle | 1026.09 73166 | moccasin cornsilk papaya cream chartreuse | 1139.16 58223 | turquoise metallic lawn honeydew saddle | 1181.22 10285 | pink light antique almond coral | 1195.28 87228 | cream beige slate brown floral | 1215.22 98219 | lace cyan beige powder medium | 1217.21 369 | grey hot sky dodger drab | 1269.36 150225 | indian navajo deep bisque spring | 1275.22 49351 | plum cornflower papaya orchid khaki | 1300.35 65341 | black deep navajo rosy coral | 1306.34 43414 | cornflower peach firebrick lime lace | 1357.41 185282 | yellow red honeydew navy misty | 1367.28 52455 | aquamarine dodger orange lace misty | 1407.45 515 | indian dim lime blue peach | 1415.51 111438 | rosy coral sandy sky burlywood | 1449.43 41520 | chartreuse steel navy misty powder | 1461.52 134448 | drab mint violet brown yellow | 1482.44 171500 | azure blue brown deep lemon | 1571.50 81638 | almond cornsilk linen royal gainsboro | 1619.63 163567 | cornflower navy aquamarine ghost goldenrod | 1630.56 36739 | peru maroon forest frosted brown | 1675.73 13795 | bisque chartreuse mint khaki magenta | 1708.79 159725 | cornflower lime smoke spring linen | 1784.72 177764 | smoke thistle drab misty orange | 1841.76 115846 | misty cyan brown lemon indian | 1861.84 96912 | bisque forest olive blush chartreuse | 1908.91 195995 | light metallic drab dim beige | 2090.99 (27 rows)