Query #1 c_name orders total Customer#000081565 4 603835.72 Customer#000092968 2 568714.25 Customer#000143749 3 508213.77 Customer#000101287 4 506641.82 Customer#000142841 2 343514.07 Customer#000065593 3 336358.95 Customer#000146863 2 280221.50 Customer#000085198 3 277674.40 Customer#000104909 1 274708.97 Customer#000060233 1 208117.44 Customer#000142322 1 85901.05 Customer#000035320 1 16013.47 Customer#000007154 0 0 Customer#000015168 0 0 Customer#000017373 0 0 Customer#000017684 0 0 Customer#000019227 0 0 Customer#000026828 0 0 Customer#000033690 0 0 Customer#000039138 0 0 Customer#000043044 0 0 Customer#000046001 0 0 Customer#000063209 0 0 Customer#000066615 0 0 Customer#000088119 0 0 Customer#000089408 0 0 Customer#000092669 0 0 Customer#000097382 0 0 Customer#000110568 0 0 Customer#000119675 0 0 Customer#000120138 0 0 Customer#000127380 0 0 Customer#000128044 0 0 Customer#000144597 0 0 Customer#000147166 0 0 (35 rows) Query #2 c_name o_orderdate o_orderpriority first_order second_order Customer#000019348 1998-01-02 5-LOW 1800326 4577254 Customer#000126154 1998-01-06 5-LOW 266662 4832419 Customer#000046003 1998-01-06 2-HIGH 3403111 5263267 Customer#000012934 1998-01-08 2-HIGH 5155236 5962503 Customer#000045652 1998-01-13 5-LOW 1052997 1882304 Customer#000049265 1998-01-15 3-MEDIUM 655906 5811296 Customer#000077827 1998-01-21 3-MEDIUM 5096100 5358950 Customer#000008644 1998-01-22 5-LOW 1326691 1836038 Customer#000121969 1998-01-24 4-NOT SPECIFIED 1403906 2782182 Customer#000075908 1998-01-25 1-URGENT 3140001 5901958 Customer#000138362 1998-01-27 5-LOW 370400 3540390 Customer#000142186 1998-01-27 4-NOT SPECIFIED 4996132 5615907 Customer#000096458 1998-01-31 3-MEDIUM 562278 2110692 Customer#000061441 1998-01-31 3-MEDIUM 773347 4615462 Customer#000043486 1998-02-06 3-MEDIUM 1062916 2804291 Customer#000046573 1998-02-08 4-NOT SPECIFIED 1189315 3024641 Customer#000081911 1998-02-11 1-URGENT 4885990 5791302 Customer#000098497 1998-02-13 2-HIGH 3409347 5306530 Customer#000109468 1998-02-18 1-URGENT 1217383 3994913 Customer#000000148 1998-02-21 5-LOW 377574 5734407 Customer#000108184 1998-02-22 3-MEDIUM 788770 1627363 Customer#000111826 1998-02-25 3-MEDIUM 751908 1635748 Customer#000017632 1998-02-26 4-NOT SPECIFIED 1189217 4848289 Customer#000028679 1998-03-02 3-MEDIUM 1815808 4342946 Customer#000088498 1998-03-06 1-URGENT 2879968 5996870 Customer#000051550 1998-03-07 5-LOW 1232450 3662176 Customer#000012823 1998-03-09 2-HIGH 2475430 5283584 Customer#000089185 1998-03-10 5-LOW 1270913 5794016 Customer#000014662 1998-03-11 1-URGENT 351427 547650 Customer#000054337 1998-03-15 3-MEDIUM 227012 4581186 Customer#000002266 1998-03-15 4-NOT SPECIFIED 1798306 3670311 Customer#000062854 1998-03-16 3-MEDIUM 3485571 5692004 Customer#000111586 1998-03-21 1-URGENT 2127779 4119271 Customer#000051889 1998-03-26 5-LOW 2156901 3166053 Customer#000090118 1998-03-27 3-MEDIUM 1562407 5957349 Customer#000104011 1998-04-01 5-LOW 1909217 5356101 Customer#000026030 1998-04-01 5-LOW 2461410 5141028 Customer#000093229 1998-04-05 2-HIGH 646791 4307299 Customer#000119644 1998-04-07 3-MEDIUM 1221922 5800391 Customer#000115735 1998-04-08 1-URGENT 5157539 5559142 Customer#000048004 1998-04-10 2-HIGH 1121952 4932417 Customer#000012634 1998-04-13 2-HIGH 2976355 4662882 Customer#000111034 1998-04-14 5-LOW 105604 5346372 Customer#000040123 1998-04-14 2-HIGH 3780674 4041223 Customer#000109195 1998-04-17 3-MEDIUM 3451843 4122853 Customer#000039752 1998-04-30 3-MEDIUM 599712 3589826 Customer#000079294 1998-04-30 2-HIGH 3402433 4310818 Customer#000127651 1998-05-05 5-LOW 1719360 2819173 Customer#000094804 1998-05-10 1-URGENT 238726 5624038 Customer#000048181 1998-05-19 5-LOW 1391526 5442628 Customer#000042472 1998-05-22 2-HIGH 444516 1826756 Customer#000119434 1998-05-22 2-HIGH 518018 2458466 Customer#000099079 1998-05-27 1-URGENT 1351841 4974790 Customer#000038326 1998-05-27 1-URGENT 5395207 5838086 Customer#000135619 1998-05-30 1-URGENT 4135168 5599077 Customer#000061120 1998-06-04 5-LOW 876832 2652518 Customer#000144568 1998-06-07 5-LOW 1520450 5834530 Customer#000103288 1998-06-12 3-MEDIUM 1791269 3643814 Customer#000137236 1998-06-22 1-URGENT 3256100 5618885 Customer#000098098 1998-06-24 3-MEDIUM 1003747 5737443 Customer#000018616 1998-07-06 3-MEDIUM 2299684 2986308 Customer#000060217 1998-07-16 3-MEDIUM 679014 4825543 Customer#000021670 1998-07-16 4-NOT SPECIFIED 1455264 3965763 Customer#000010774 1998-07-17 4-NOT SPECIFIED 1414598 2711814 Customer#000071551 1998-07-18 5-LOW 2431716 4214433 Customer#000029473 1998-07-20 3-MEDIUM 3091687 5942400 Customer#000135649 1998-07-25 4-NOT SPECIFIED 111431 1682532 Customer#000025552 1998-07-26 2-HIGH 792580 4449735 Customer#000037369 1998-07-26 5-LOW 3780038 4742917 Customer#000134743 1998-08-01 3-MEDIUM 3854240 5395044 (70 rows) Query #3 c_custkey c_name 4196 Customer#000004196 6254 Customer#000006254 10462 Customer#000010462 15038 Customer#000015038 15487 Customer#000015487 18458 Customer#000018458 18758 Customer#000018758 24953 Customer#000024953 29933 Customer#000029933 31070 Customer#000031070 38483 Customer#000038483 40087 Customer#000040087 41273 Customer#000041273 45512 Customer#000045512 46282 Customer#000046282 47329 Customer#000047329 49952 Customer#000049952 51266 Customer#000051266 56968 Customer#000056968 60431 Customer#000060431 73967 Customer#000073967 75098 Customer#000075098 75320 Customer#000075320 76010 Customer#000076010 78401 Customer#000078401 79568 Customer#000079568 87494 Customer#000087494 87989 Customer#000087989 94366 Customer#000094366 102449 Customer#000102449 104257 Customer#000104257 105182 Customer#000105182 109625 Customer#000109625 113462 Customer#000113462 114437 Customer#000114437 115175 Customer#000115175 128888 Customer#000128888 132683 Customer#000132683 136694 Customer#000136694 139912 Customer#000139912 146300 Customer#000146300 149639 Customer#000149639 (42 rows) Query #4 num_orders customers 0 63320 1 23823 2 23857 3 17626 4 10876 5 5942 6 2719 7 1165 8 446 9 158 10 55 11 11 12 2 (13 rows) Query #5 p_partkey p_name s_name n_name ps_supplycost 5797 turquoise pink blanched peach rose Supplier#000003298 UNITED KINGDOM 628.11 26466 deep dark floral tomato chiffon Supplier#000003973 FRANCE 121.37 47886 cornflower goldenrod maroon pink dim Supplier#000007887 ROMANIA 417.94 68482 goldenrod thistle navy turquoise indian Supplier#000006001 RUSSIA 532.58 77527 lavender saddle floral hot cream Supplier#000002542 RUSSIA 186.90 89864 honeydew wheat yellow plum hot Supplier#000007389 ROMANIA 679.64 125900 tomato dim azure yellow salmon Supplier#000005901 FRANCE 6.36 141406 gainsboro beige bisque cyan rosy Supplier#000008949 UNITED KINGDOM 27.58 160186 yellow pale ghost goldenrod hot Supplier#000002703 FRANCE 259.76 177287 linen navajo mint lace burnished Supplier#000004839 UNITED KINGDOM 362.63 177303 cyan moccasin chartreuse sienna steel Supplier#000002338 RUSSIA 494.32 (11 rows) Query #6 n_name customers ALGERIA 961 ARGENTINA 982 BRAZIL 951 CANADA 987 CHINA 997 EGYPT 1050 ETHIOPIA 986 FRANCE 977 GERMANY 945 INDIA 1041 INDONESIA 1040 IRAN 1005 IRAQ 1060 JAPAN 993 JORDAN 982 KENYA 1011 MOROCCO 968 MOZAMBIQUE 955 PERU 952 ROMANIA 1044 RUSSIA 1007 SAUDI ARABIA 990 UNITED KINGDOM 1043 UNITED STATES 1057 VIETNAM 1032 (25 rows) Query #7 r_name s_name revenue rank AFRICA Supplier#000005994 5192480.32 1 AFRICA Supplier#000006989 5147194.94 2 AFRICA Supplier#000009938 5106385.61 3 AMERICA Supplier#000003453 5056575.20 1 AMERICA Supplier#000008966 5000115.38 2 AMERICA Supplier#000009448 4953409.24 3 ASIA Supplier#000004966 4936878.69 1 ASIA Supplier#000003989 4917422.40 2 ASIA Supplier#000009473 4840938.10 3 EUROPE Supplier#000006490 5084557.70 1 EUROPE Supplier#000000925 5033025.55 2 EUROPE Supplier#000006500 5028685.09 3 MIDDLE EAST Supplier#000007399 4874373.55 1 MIDDLE EAST Supplier#000001452 4812484.86 2 MIDDLE EAST Supplier#000009919 4786311.49 3 (15 rows) Query #8 month orders change running_total 1 19148 19148 2 17584 -1564 36732 3 19052 1468 55784 4 18864 -188 74648 5 19519 655 94167 6 18951 -568 113118 7 19431 480 132549 8 19330 -101 151879 9 18598 -732 170477 10 19337 739 189814 11 18519 -818 208333 12 19450 931 227783 (12 rows)