Query #1 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 (200 rows) Query #2 c_name c_acctbal Customer#000000003 7498.12 Customer#000000006 7638.57 Customer#000000009 8324.07 Customer#000000018 5494.43 Customer#000000024 9255.67 Customer#000000027 5679.84 Customer#000000030 9321.01 Customer#000000039 6264.31 Customer#000000042 8727.01 Customer#000000045 9983.38 Customer#000000063 9331.13 Customer#000000075 6684.10 Customer#000000078 7136.97 Customer#000000084 5174.71 Customer#000000087 6327.54 Customer#000000090 7354.23 Customer#000000096 6323.92 Customer#000000102 8462.17 Customer#000000105 9091.82 Customer#000000111 6505.26 Customer#000000123 5897.83 Customer#000000129 9127.27 Customer#000000135 8732.91 Customer#000000141 6706.14 Customer#000000144 6417.31 Customer#000000147 8071.40 Customer#000000153 5454.26 Customer#000000156 9302.95 Customer#000000162 6268.99 Customer#000000177 7457.50 Customer#000000186 8737.50 Customer#000000192 8239.96 Customer#000000210 7250.14 Customer#000000213 9987.71 Customer#000000219 9858.57 Customer#000000222 8893.76 Customer#000000225 8893.20 Customer#000000228 6868.12 Customer#000000234 8383.51 Customer#000000240 7139.68 Customer#000000246 9584.96 Customer#000000258 6022.27 Customer#000000261 7094.22 Customer#000000270 9192.50 Customer#000000279 9663.23 Customer#000000285 7276.72 Customer#000000288 5339.43 Customer#000000297 7096.32 Customer#000000300 8084.92 Customer#000000303 9339.57 Customer#000000309 8824.78 Customer#000000318 9149.98 Customer#000000321 7718.77 Customer#000000327 8762.16 Customer#000000330 8244.73 Customer#000000333 8018.89 Customer#000000336 9241.49 Customer#000000339 8438.07 Customer#000000342 7186.74 Customer#000000354 7095.95 Customer#000000357 8747.36 Customer#000000360 6542.83 Customer#000000375 5562.22 Customer#000000378 5718.05 Customer#000000381 9931.71 Customer#000000390 8862.18 Customer#000000399 7358.53 Customer#000000405 7519.14 Customer#000000408 6825.37 Customer#000000417 6187.73 Customer#000000426 7818.25 Customer#000000429 9247.21 Customer#000000432 5715.64 Customer#000000435 6217.46 Customer#000000441 9451.84 Customer#000000447 7665.98 Customer#000000450 5544.42 Customer#000000453 5678.18 Customer#000000456 8815.78 Customer#000000465 8432.74 Customer#000000468 9834.19 Customer#000000471 5716.90 Customer#000000474 9165.47 Customer#000000483 8877.20 Customer#000000486 7487.40 Customer#000000489 8255.83 Customer#000000492 8635.18 Customer#000000495 7997.81 Customer#000000507 5727.00 Customer#000000519 9074.45 Customer#000000522 6358.46 Customer#000000531 5342.82 Customer#000000534 6520.97 Customer#000000540 9195.77 Customer#000000543 6089.13 Customer#000000555 5486.52 Customer#000000564 6307.59 Customer#000000567 8475.17 Customer#000000570 8480.87 Customer#000000585 7820.26 Customer#000000591 6344.66 Customer#000000594 6518.42 Customer#000000603 8161.13 Customer#000000606 9676.98 Customer#000000612 7669.16 Customer#000000627 5826.68 Customer#000000642 5684.01 Customer#000000648 7029.24 Customer#000000657 8729.97 Customer#000000663 9698.21 Customer#000000669 6019.20 Customer#000000672 7778.95 Customer#000000675 5295.26 Customer#000000678 6302.93 Customer#000000684 8545.90 Customer#000000693 6577.21 Customer#000000711 9591.51 Customer#000000717 8510.94 Customer#000000720 5357.32 Customer#000000726 6253.81 Customer#000000729 8947.26 Customer#000000741 9195.41 Customer#000000753 8114.44 Customer#000000756 8116.99 Customer#000000765 5683.33 Customer#000000768 9618.84 Customer#000000771 7461.74 Customer#000000777 9097.52 Customer#000000780 9874.12 Customer#000000789 6038.60 Customer#000000795 8443.18 Customer#000000801 5207.32 Customer#000000810 9632.77 Customer#000000813 5673.47 Customer#000000816 9239.32 Customer#000000828 7059.68 Customer#000000840 6799.00 Customer#000000846 7650.73 Customer#000000849 9670.64 Customer#000000864 8932.76 Customer#000000867 5680.23 Customer#000000888 6358.04 Customer#000000891 6032.18 Customer#000000909 5565.58 Customer#000000933 8541.16 Customer#000000939 8059.51 Customer#000000942 5898.17 Customer#000000945 9615.39 Customer#000000951 7499.47 Customer#000000954 5740.00 Customer#000000957 9076.68 Customer#000000969 8601.63 Customer#000000987 9850.64 Customer#000000990 6988.49 Customer#000000993 8421.87 Customer#000000996 6450.78 Customer#000001005 7790.94 Customer#000001008 8191.74 Customer#000001020 6914.87 Customer#000001023 7188.35 Customer#000001026 9699.28 Customer#000001029 6252.18 Customer#000001035 7499.36 Customer#000001041 7993.98 Customer#000001044 7291.30 Customer#000001047 8918.99 Customer#000001056 6287.12 Customer#000001077 8581.78 Customer#000001086 9726.83 Customer#000001095 6221.26 Customer#000001107 7961.62 Customer#000001113 7392.30 Customer#000001125 8427.55 Customer#000001128 8123.99 Customer#000001131 6019.10 Customer#000001134 8458.26 Customer#000001140 6319.21 Customer#000001143 8655.98 Customer#000001149 6287.79 Customer#000001152 5680.15 Customer#000001164 7341.35 Customer#000001167 9510.87 Customer#000001176 5827.59 Customer#000001182 8814.39 Customer#000001191 9088.54 Customer#000001194 7582.29 Customer#000001197 9261.05 Customer#000001203 5787.69 Customer#000001206 8437.76 Customer#000001212 7736.03 Customer#000001215 7795.87 Customer#000001218 8801.73 Customer#000001224 8124.15 Customer#000001239 6936.72 Customer#000001248 6539.15 Customer#000001251 7267.76 Customer#000001257 8810.83 Customer#000001263 6975.90 Customer#000001272 6865.14 Customer#000001275 8972.46 (200 rows) Query #3 p_name ps_supplycost l_quantity chocolate floral drab honeydew azure 143.07 5.00 green cornsilk goldenrod chocolate forest 738.63 9.00 pink beige chocolate seashell yellow 551.24 7.00 blush smoke dark chocolate hot 170.70 29.00 blanched indian sienna chocolate cornflower 467.56 48.00 ghost chocolate sandy red plum 540.98 34.00 spring drab forest grey chocolate 673.57 32.00 medium red chocolate cornsilk purple 460.90 1.00 sandy wheat almond chocolate royal 775.33 2.00 coral sky firebrick chocolate sandy 320.51 33.00 grey dim midnight chocolate powder 124.63 21.00 navy ivory chocolate ghost blue 930.85 37.00 chocolate bisque burnished cream ivory 324.30 50.00 black cornflower chocolate plum royal 451.61 24.00 purple blue lavender chocolate dodger 423.45 24.00 turquoise antique chocolate puff misty 925.54 25.00 wheat chocolate papaya blanched red 547.00 21.00 navajo chocolate firebrick salmon violet 934.30 18.00 orchid mint chocolate saddle frosted 878.62 22.00 magenta peach chocolate bisque aquamarine 911.77 29.00 medium salmon floral chocolate tomato 775.96 29.00 lawn medium chocolate cream tomato 237.90 46.00 ivory chocolate pink plum goldenrod 3.39 49.00 smoke blanched aquamarine chocolate red 343.45 19.00 moccasin lavender light burlywood chocolate 185.32 29.00 khaki burnished bisque deep chocolate 242.06 7.00 turquoise lace chocolate brown purple 742.30 16.00 saddle maroon chocolate dodger cornflower 42.25 5.00 powder wheat chocolate dodger green 484.38 26.00 chocolate honeydew violet navajo cornsilk 639.55 9.00 bisque azure chocolate grey light 686.01 3.00 chocolate burlywood beige maroon powder 884.20 11.00 grey lemon brown chocolate olive 826.62 37.00 cyan orchid frosted chocolate cornsilk 415.64 47.00 chocolate turquoise blue burlywood honeydew 530.68 10.00 dim puff chocolate hot ghost 423.11 3.00 chocolate chartreuse moccasin thistle spring 543.18 22.00 chocolate olive grey linen midnight 999.90 41.00 saddle snow chocolate floral almond 478.59 50.00 red burnished bisque chocolate ivory 53.56 29.00 chiffon powder lavender almond chocolate 931.79 44.00 azure chocolate cyan blanched magenta 601.77 12.00 orchid red dodger drab chocolate 888.79 25.00 burlywood brown chocolate seashell royal 347.81 3.00 chocolate olive lawn navy pink 687.37 14.00 violet chocolate magenta olive cyan 33.12 14.00 misty burnished firebrick chocolate azure 243.51 24.00 khaki yellow chocolate cream blush 80.29 45.00 chocolate smoke deep antique turquoise 121.89 45.00 wheat olive misty beige chocolate 72.54 16.00 spring chocolate lime powder coral 374.68 44.00 light rosy chocolate plum firebrick 204.90 37.00 (52 rows) Query #4 r_name n_name s_name total_qty AFRICA ALGERIA Supplier#000002962 133446 AFRICA ALGERIA Supplier#000004078 131163 AFRICA ALGERIA Supplier#000005545 129886 AFRICA ALGERIA Supplier#000005576 134927 AFRICA ALGERIA Supplier#000007150 136375 AFRICA ALGERIA Supplier#000008847 125264 AFRICA ALGERIA Supplier#000009075 140097 AFRICA ALGERIA Supplier#000009664 137582 AFRICA ETHIOPIA Supplier#000000393 126208 AFRICA ETHIOPIA Supplier#000000456 128633 AFRICA ETHIOPIA Supplier#000002985 128827 AFRICA ETHIOPIA Supplier#000004774 127818 AFRICA ETHIOPIA Supplier#000004984 129752 AFRICA ETHIOPIA Supplier#000005870 129662 AFRICA ETHIOPIA Supplier#000006171 126905 AFRICA ETHIOPIA Supplier#000007173 131744 AFRICA ETHIOPIA Supplier#000007284 130685 AFRICA ETHIOPIA Supplier#000008179 143329 AFRICA ETHIOPIA Supplier#000009773 128237 AFRICA KENYA Supplier#000002581 141689 AFRICA KENYA Supplier#000005786 129626 AFRICA KENYA Supplier#000007534 131655 AFRICA KENYA Supplier#000009019 138961 AFRICA MOROCCO Supplier#000001819 132393 AFRICA MOROCCO Supplier#000003050 130152 AFRICA MOROCCO Supplier#000004575 140715 AFRICA MOROCCO Supplier#000005075 129332 AFRICA MOROCCO Supplier#000005160 135829 AFRICA MOROCCO Supplier#000005172 131927 AFRICA MOROCCO Supplier#000006841 139658 AFRICA MOROCCO Supplier#000008074 129148 AFRICA MOZAMBIQUE Supplier#000000377 129582 AFRICA MOZAMBIQUE Supplier#000000818 128951 AFRICA MOZAMBIQUE Supplier#000003236 125536 AFRICA MOZAMBIQUE Supplier#000003838 144563 AFRICA MOZAMBIQUE Supplier#000007563 131861 AFRICA MOZAMBIQUE Supplier#000009262 129970 AFRICA MOZAMBIQUE Supplier#000009354 136099 AFRICA MOZAMBIQUE Supplier#000009481 127816 AMERICA ARGENTINA Supplier#000000886 144221 AMERICA ARGENTINA Supplier#000002821 154159 AMERICA ARGENTINA Supplier#000002899 144151 AMERICA ARGENTINA Supplier#000005817 132958 AMERICA ARGENTINA Supplier#000007031 130920 AMERICA ARGENTINA Supplier#000007698 128705 AMERICA ARGENTINA Supplier#000008397 130169 AMERICA ARGENTINA Supplier#000008573 128795 AMERICA ARGENTINA Supplier#000008907 151659 AMERICA ARGENTINA Supplier#000009964 126057 AMERICA BRAZIL Supplier#000000940 131583 AMERICA BRAZIL Supplier#000001324 126781 AMERICA BRAZIL Supplier#000002146 130867 AMERICA BRAZIL Supplier#000003722 126063 AMERICA BRAZIL Supplier#000006503 143903 AMERICA BRAZIL Supplier#000007221 129560 AMERICA BRAZIL Supplier#000009521 126865 AMERICA CANADA Supplier#000002272 142937 AMERICA CANADA Supplier#000002419 136958 AMERICA CANADA Supplier#000002630 125071 AMERICA CANADA Supplier#000004527 152819 AMERICA CANADA Supplier#000004975 135346 AMERICA CANADA Supplier#000005426 125631 AMERICA PERU Supplier#000001267 132085 AMERICA PERU Supplier#000001961 139051 AMERICA PERU Supplier#000003151 132297 AMERICA PERU Supplier#000003318 134240 AMERICA PERU Supplier#000003628 150577 AMERICA PERU Supplier#000004719 136322 AMERICA PERU Supplier#000005013 143196 AMERICA PERU Supplier#000008389 128301 AMERICA PERU Supplier#000009361 132887 AMERICA UNITED STATES Supplier#000000423 136043 AMERICA UNITED STATES Supplier#000003886 140148 AMERICA UNITED STATES Supplier#000004594 127569 AMERICA UNITED STATES Supplier#000005857 125664 AMERICA UNITED STATES Supplier#000006940 129292 AMERICA UNITED STATES Supplier#000007476 139777 AMERICA UNITED STATES Supplier#000007516 128798 AMERICA UNITED STATES Supplier#000008027 125009 AMERICA UNITED STATES Supplier#000008272 126500 ASIA CHINA Supplier#000000075 134236 ASIA CHINA Supplier#000002650 128231 ASIA CHINA Supplier#000003672 133915 ASIA CHINA Supplier#000005854 130008 ASIA CHINA Supplier#000006273 125250 ASIA CHINA Supplier#000006965 129949 ASIA CHINA Supplier#000007654 131754 ASIA CHINA Supplier#000008262 134690 ASIA CHINA Supplier#000008400 138574 ASIA INDIA Supplier#000004209 135395 ASIA INDIA Supplier#000004507 133568 ASIA INDIA Supplier#000004953 165690 ASIA INDIA Supplier#000005243 135811 ASIA INDIA Supplier#000006440 144847 ASIA INDIA Supplier#000006475 133747 ASIA INDIA Supplier#000008251 132616 ASIA INDIA Supplier#000009175 129349 ASIA INDIA Supplier#000009425 134884 ASIA INDONESIA Supplier#000000534 151118 ASIA INDONESIA Supplier#000000770 127574 ASIA INDONESIA Supplier#000001181 126916 ASIA INDONESIA Supplier#000002453 156026 ASIA INDONESIA Supplier#000003582 132658 ASIA INDONESIA Supplier#000004110 128130 ASIA INDONESIA Supplier#000007702 149581 ASIA JAPAN Supplier#000002216 130106 ASIA JAPAN Supplier#000002559 157504 ASIA JAPAN Supplier#000004027 132530 ASIA JAPAN Supplier#000004450 125637 ASIA JAPAN Supplier#000005957 137990 ASIA JAPAN Supplier#000006822 131599 ASIA JAPAN Supplier#000008363 139407 ASIA JAPAN Supplier#000009415 157441 ASIA VIETNAM Supplier#000002405 135064 ASIA VIETNAM Supplier#000002927 141955 ASIA VIETNAM Supplier#000005815 126405 ASIA VIETNAM Supplier#000005956 134470 ASIA VIETNAM Supplier#000006516 136904 ASIA VIETNAM Supplier#000008162 139009 ASIA VIETNAM Supplier#000009865 134278 EUROPE FRANCE Supplier#000000605 148520 EUROPE FRANCE Supplier#000002304 167800 EUROPE FRANCE Supplier#000002924 137268 EUROPE FRANCE Supplier#000006129 139426 EUROPE FRANCE Supplier#000006209 160069 EUROPE FRANCE Supplier#000006975 127776 EUROPE FRANCE Supplier#000008033 131190 EUROPE GERMANY Supplier#000000996 141484 EUROPE GERMANY Supplier#000009645 130120 EUROPE ROMANIA Supplier#000000510 135506 EUROPE ROMANIA Supplier#000002093 126056 EUROPE ROMANIA Supplier#000003390 129623 EUROPE ROMANIA Supplier#000006085 135013 EUROPE ROMANIA Supplier#000008984 127399 EUROPE ROMANIA Supplier#000009366 149891 EUROPE RUSSIA Supplier#000000791 126463 EUROPE RUSSIA Supplier#000000813 130488 EUROPE RUSSIA Supplier#000001880 132543 EUROPE RUSSIA Supplier#000002865 131963 EUROPE RUSSIA Supplier#000003745 125384 EUROPE RUSSIA Supplier#000005371 127333 EUROPE RUSSIA Supplier#000007110 125658 EUROPE RUSSIA Supplier#000007802 133517 EUROPE RUSSIA Supplier#000009010 125545 EUROPE RUSSIA Supplier#000009605 128017 EUROPE UNITED KINGDOM Supplier#000001112 130548 EUROPE UNITED KINGDOM Supplier#000001518 129729 EUROPE UNITED KINGDOM Supplier#000002371 157021 EUROPE UNITED KINGDOM Supplier#000002632 126996 EUROPE UNITED KINGDOM Supplier#000004811 130313 EUROPE UNITED KINGDOM Supplier#000005146 126996 EUROPE UNITED KINGDOM Supplier#000006239 126190 EUROPE UNITED KINGDOM Supplier#000009441 129934 EUROPE UNITED KINGDOM Supplier#000009478 167356 MIDDLE EAST EGYPT Supplier#000002516 149365 MIDDLE EAST EGYPT Supplier#000003377 126882 MIDDLE EAST EGYPT Supplier#000003924 129168 MIDDLE EAST EGYPT Supplier#000007831 127873 MIDDLE EAST EGYPT Supplier#000008285 132669 MIDDLE EAST EGYPT Supplier#000008605 128496 MIDDLE EAST EGYPT Supplier#000008735 138406 MIDDLE EAST EGYPT Supplier#000009675 129727 MIDDLE EAST EGYPT Supplier#000009781 136013 MIDDLE EAST EGYPT Supplier#000009851 159023 MIDDLE EAST IRAN Supplier#000004784 137326 MIDDLE EAST IRAN Supplier#000004820 134211 MIDDLE EAST IRAN Supplier#000005294 126846 MIDDLE EAST IRAN Supplier#000005447 139868 MIDDLE EAST IRAN Supplier#000005803 144181 MIDDLE EAST IRAN Supplier#000007303 135703 MIDDLE EAST IRAN Supplier#000007846 136740 MIDDLE EAST IRAN Supplier#000007860 127837 MIDDLE EAST IRAN Supplier#000007983 136340 MIDDLE EAST IRAQ Supplier#000002170 140403 MIDDLE EAST IRAQ Supplier#000002306 150831 MIDDLE EAST IRAQ Supplier#000002690 127266 MIDDLE EAST IRAQ Supplier#000003342 127438 MIDDLE EAST IRAQ Supplier#000004428 127417 MIDDLE EAST IRAQ Supplier#000004571 126420 MIDDLE EAST IRAQ Supplier#000005574 127858 MIDDLE EAST IRAQ Supplier#000007408 138938 MIDDLE EAST JORDAN Supplier#000000537 126031 MIDDLE EAST JORDAN Supplier#000004778 134412 MIDDLE EAST JORDAN Supplier#000006643 147916 MIDDLE EAST SAUDI ARABIA Supplier#000001944 129880 MIDDLE EAST SAUDI ARABIA Supplier#000003335 125943 MIDDLE EAST SAUDI ARABIA Supplier#000004831 147984 MIDDLE EAST SAUDI ARABIA Supplier#000005435 142491 MIDDLE EAST SAUDI ARABIA Supplier#000005578 132467 MIDDLE EAST SAUDI ARABIA Supplier#000005920 138001 MIDDLE EAST SAUDI ARABIA Supplier#000006705 131387 MIDDLE EAST SAUDI ARABIA Supplier#000007896 130095 MIDDLE EAST SAUDI ARABIA Supplier#000008210 135919 (193 rows) Query #5 subject count SCOM 156 BIO 150 MATH 133 COB 120 HTH 94 WRTC 91 HIST 76 CHEM 72 KIN 69 PSYC 65 CS 57 ECON 56 SMAD 56 NSG 55 ISAT 53 ISCI 53 POSC 46 PHYS 45 ELED 44 ART 40 MKTG 39 ENG 38 MGT 38 CIS 37 ENGR 34 SRM 34 SOCI 33 PHIL 32 MUS 29 ACTG 28 FIN 28 GEOG 28 HM 27 REL 26 GEOL 24 CSD 22 LED 22 SPAN 22 ARTH 20 IA 20 EXED 19 JUST 19 MUAP 19 THEA 19 DANC 18 EDUC 17 BUS 16 HUM 16 ITAL 16 ANTH 14 HON 13 MBA 13 SOWK 12 IT 11 MSSE 11 OT 11 HRD 10 MSCI 10 NUTR 10 ARCD 9 CRJU 9 GRPH 9 HSA 9 UNST 9 LDT 8 ADSU 7 ASTR 5 ECED 5 FR 5 IECE 5 IS 5 MUED 5 PA 5 PPA 5 AAAD 4 CHIN 4 MUI 4 WGSS 4 FAM 3 GER 3 IPE 3 LAXC 3 SRL 3 STAD 3 AMST 2 ATEP 2 BSAN 2 ENVT 2 FL 2 IB 2 INDU 2 INTA 2 JAPN 2 KOR 2 NPS 2 TCLD 2 AIRS 1 BIOT 1 BLAW 1 DATA 1 GERN 1 GRAD 1 HUMN 1 LTLE 1 TESL 1 (105 rows) Query #6 instructor students Riley,Philip B 649 Stewart,Michael Clark 548 Lam,Michael O 534 Molloy,Kevin Patrick 511 Bowers,John C 505 Johnson,Christopher R 484 Sprague,Nathan R 483 Mayfield,Christopher Scott 437 Aboutabl,Mohamed Said 433 Weikle,Dee Ann Burgess 383 Kirkpatrick,Michael Scott 382 Buchholz,Florian Paul 350 Bhaskar,Siddharth K 330 Wang,Xunhua 328 Duan,Zhoujun 327 Bernstein,David H 315 El Kadi,Mona A 308 Wang,Isaac Decheng 307 Shrestha,Chandani 275 Richards,Kirsten Esther 262 Simmons,Sharon Jeanette 219 Bernstein,David Howard 183 Heydari,Mohammad H 180 Chao,Alvin J 162 Tjaden,Brett C. 124 Duan,Zhuojun 123 Fox,Christopher J 96 Tjaden,Brett Clinton 93 Normand,Allison Paige 34 Duncan,David Lee 27 Salman,Ahmad Ali Ali 25 West,Robert C 22 El-Tawab,Samy Sayed 8 West,Robert Charles 6 Blow,Cartinez 5 Zhu,Alf 3 2 Salib,Emil Habib 1 Nischal,Peddiraju V 0 (39 rows) Query #7 count last_name 132337 martin 58932 mason 34238 miller 32986 mary 30242 mitchell 29543 mcdonald 29375 meyer 26619 morris 26410 mr 26361 morton 24082 mann 22831 morrison 21882 moss 21504 manning 20164 miss 19284 marshall 17156 middleton 16714 merrill 15868 moody 14859 michael 14617 maxwell 13397 myers 13071 morse 12464 mc donald 12337 mcintyre 11823 meyers 11571 milton 11555 mackay 11527 matthews 11502 milne 11382 munro 11175 mackenzie 11052 moses 11004 mc kinley 10665 mc lean 10375 marsh 10303 mooney 10055 morley 9852 moran 9473 mc kenzie 9408 march 9276 mc cormick 9125 mills 8707 mortimer 8661 moor 8483 maloney 8339 monday 8082 mack 8049 martinez 7956 mountain 7586 mayer 6960 morgan 6953 maria 6948 marks 6641 moir 6629 malcolm 6584 mathews 6447 macdonald 6308 me 6198 mead 6101 mac 5813 morrill 5732 mckay 5728 moulton 5681 mercer 5504 merchant 4819 mc laughlin 4584 mc carthy 4467 mallory 4379 mellor 4360 mcfarlane 4128 mark 4065 masters 3975 moore 3973 margaret 3969 madison 3839 mackey 3731 muir 3586 marion 3526 muller 3463 metcalf 3376 mc dowell 3330 mckenzie 3310 melville 3308 mansfield 3305 mclean 3290 mott 3283 marr 3265 mcintosh 3205 mac donald 3156 maguire 3033 mcpherson 3005 major 3004 manley 2974 more 2938 mahoney 2849 merritt 2827 mar 2811 markham 2760 mil 2609 maddox 2581 morison 2500 mitchel 2436 manson 2428 mosher 2318 mayhew 2305 mo 2285 mc clure 2246 mccarthy 2210 mc bride 2175 marriott 2028 marsden 1977 mc mahon 1923 magee 1815 millard 1705 milligan 1671 mcleod 1608 massey 1570 mc leod 1556 mcgregor 1500 moseley 1474 mcmillan 1443 mc farland 1396 mater 1318 maher 1285 merrick 1268 murdock 1212 meek 1205 melntyre 1133 month 1116 mccormick 1099 marvin 1094 meadows 1090 misses 991 mentioned 933 monk 920 metcalfe 876 mc connell 753 malone 672 ml 658 menzies (141 rows) Query #8 passenger_id first_name last_name 21 BROOKS DUNCAN 22 JOSUE SMALL 39 WESTON RICHARDSON 50 SOPHIA BULL 60 ELI JACKSON 136 DANIEL DATED 156 NOAH SMITH 174 ESMERALDA SMITH 240 CECILIA PHILIP 248 ALEXANDER BARNETT 305 NATHANIEL MERRICK 311 LUKE RUSSELL 339 ELI MARTINEZ 341 JAYLEEN SCHOOL 351 AVERY WATSON 364 KARTER CURRIER 372 DANTE DAWES 411 MIA FREEMAN 417 KARINA ANNA 560 TYLER HUDSON 561 BENJAMIN NEWTON 692 JASON MOIR 700 AALIYAH MARION 737 DANIEL BRIDGE 744 BODHI ORR 782 JACK WM 876 AIDEN SIMPSON 928 EMILIANO WALL 972 MARK PHELPS 982 ANTHONY TURNER 1095 JADEN BLISS 1101 CHARLOTTE JOHNSON 1116 ROBERTO JAMESON 1151 GRACE PRATT 1153 TRISTAN WRIGHT 1159 THOMAS JOHNSTON 1175 EMILY NEWMAN 1195 JORDYN TURNER 1232 JASON CHAMPION 1259 EMMA FAIRBANKS 1261 LIAM LIVINGSTON 1276 PATRICIA MCINTYRE 1373 JACOB HOFFMAN 1410 LILY LOVELL 1607 CHEYENNE WOOD 1649 LYLA MAC 1662 JORDAN SWEET 1666 DANA STODDARD 1691 ZAYDEN MEYERS 1708 HUNTER MACKENZIE 1720 TYLER JOSEPH 1790 LENNON JONES 1861 WAYLON SIMPSON 1882 CARTER BAILEY 1896 DYLAN BENEDICT 1898 JORGE PAINE 1956 NOAH SMITH 2004 TROY MARTINEZ 2039 JACOB LONDON 2062 LINA TEMPLE 2073 VINCENT SMITH 2075 SEBASTIAN ROBINSON 2135 KAIRO SLADE 2165 FINN HURD 2177 ABIGAIL RICHARDS 2294 MIKAYLA WRAY 2347 JAMES HOLLIDAY 2357 AIDEN LYNCH 2376 OLIVIA THOMAS 2378 VIVIANA TATE 2443 KAMILA ROWE 2451 KEVIN WHITE 2474 LUCIA ARNOLD 2642 MIA MEYERS 2643 ALEXANDER GLOVER 2644 AVIANNA JEFFERSON 3284 ANDY STEPHENSON 3285 ANGELICA GOODRICH 3286 RAUL ROCK 3497 ISABELLE COUNTY 3498 CODY NEWMAN 3499 LIAM BIGELOW 3527 NICHOLAS WILLIAMS 3528 ANA BARNARD 3529 ANGEL MARY 3566 PENELOPE TURNER 3567 IVY HURD 3568 ZAHRA HELLER 4080 ADELINA BRADBURY 4081 DEACON ROSS 4082 AYLA HART 4292 ZARA PECK 4293 SEBASTIAN ROWLEY 4294 COLTON CRAWFORD 4406 LIZBETH WHITE 4407 LUCIA PARSONS 4408 JASON FRY 4472 SOPHIE PATTERSON 4473 VALENTINA BARRON 4474 ZOEY PHILIPS 4544 SAMANTHA BOYER 4545 ALONSO ANDERSON 4546 MADELINE CREEK 4706 STEVEN SO 4707 GAVIN NORTH 4708 RICARDO SUN 4781 Jordan Bartlett 4782 STELLA WICKS 4783 KEVIN WOODCOCK 4973 NIXON GEORGE 4974 DYLAN SMITH 4975 KENDRA STUART 5162 BERNARDO BROWN 5163 ARI DONNELLY 5164 JASPER MC CORMICK 5231 CADEN AVERY 5232 LUKAS THOMAS 5233 VICTORIA NAYLOR 5322 AUSTIN SMITH 5323 DIANA BURNETT 5324 SEBASTIAN MORISON 5408 ELISA MERRILL 5409 JAMES BALLARD 5410 ISAAC SPARKS 5651 darian Vail 5652 MAVERICK WILLIAMS 5653 GRAYSON WILCOX 6149 Madeline carr 6150 OLIVIA NOBLE 6151 ZION SULLIVAN 6213 AMANDA MARTIN 6214 MADISON ZIMMERMAN 6215 URIEL ANDREWS 6386 LOGAN CAMP 6387 LUCAS BECKETT 6388 EDGAR SON 7383 AARON BUDD 7384 ADDISON KENYON 7385 RILEY GRAY 7480 ADA PARKER 7481 AYDEN GALLOWAY 7482 ZACHARY LOUIS 7601 KEYLA DODGE 7602 JORGE RICHARDS 7603 COLE FRANK 7825 MANUEL BURDICK 7826 PAYTON OLIVER 7827 JUDE RILEY 7966 BRANDON MISS 7967 JACOB SINGLETON 7968 JOANNA HOWARD 8075 ISABELLA HASKELL 8076 RICHARD PEARSON 8077 SAGE HART 8354 JOEL HOOD 8355 OWEN WARNER 8356 ISABELLA PEASE 8517 JOSEPHINE FELLOW 8518 KAYDEN JAS 8519 JASPER ENGLAND 8603 LIBERTY THAYER 8604 SEBASTIAN CAMP 8605 SEBASTIAN CITY 8633 JONATHAN BIGGS 8634 ZAIRA SHERMAN 8635 NATHANAEL WELCH 8648 BARON CLEMENT 8649 ALEJANDRO YATES 8650 DYLAN ROGERS 8666 BRADLEY HUSSEY 8667 NIXON HENDERSON 8668 OLIVER GIBSON 8693 weston martin 8694 JAYDEN SIMPSON 8695 RAFAEL SMITH 8714 mateo Saunders 8715 JACOB HALL 8716 JAYDEN BROWN 8735 MAXIMILIANO JOHNSON 8736 STEPHEN ANDREWS 8737 ALLAN HARLAN 9232 JASMINE FORD 9233 NOA LARKIN 9234 KASEN DAVIDSON 9431 DAVID BALL 9432 DANIEL BOYD 9433 JORGE BAILEY 9482 Juliette watson 9483 BRIXTON JONES 9484 JAKE FROST 9530 DYLAN DAVIES 9531 SOPHIA BREWER 9532 DELILAH WELLS 9617 MORGAN TAYLOR 9624 GIANNA HOLT 9625 FINN MC KENZIE 9626 ALEXANDER HUGHES 9720 JACOB STOCKTON 9721 SERENA FIRTH 9773 Alana Sim (200 rows) Query #9 first_name last_name iso_country TROY JEWETT BD CLARISSA HICKMAN BD JORGE COWAN BD MATTHEW COLLEGE BD MADDOX THOMAS BD JACOB FRASER BD DYLAN PATERSON BD LUCAS HURD BD GAEL LYNN BD GABRIEL LYONS BD ALEX STEVENS BD JUDITH SHARPE BD KARIM MCINTYRE BD BRIANNA HUDSON BD LOGAN FREEMAN BD Natalie Howe BD GARY HALL BD ATTICUS REYNOLDS BD MANUEL HAROLD BD MAXWELL PICKERING BD AARON MARY BD WAYLON CARR BD JACK LAWRENCE BD JORDYN WISEMAN BD JASPER CHAPLIN BD LOGAN PERRY BD AVA IRVING BD AALIYAH WRIGHT BD ALEXANDER CAMERON BD CONNOR CARNEY BD OLIVIA PARK BD MIRA INGALLS BD NATASHA WILLIAMS BD MOLLY HARTLEY BD JONATHAN MILTON BD JACOB WOOD BD DYLAN SULLIVAN BD BENTLEY FOX BD DAVINA BASSETT BD LOGAN FOLEY BD SKYLER FINN BD DANIEL LAW BD JACOB SUN BD ABIGAIL NEWELL BD VIRGINIA LEWIS BD NATHANIEL DOOLEY BD ANTHONY FLEMING BD LOGAN LIVINGSTON BD MATTHEW MILLER BD ADA KERR BD ALINA STS BD BENNETT HORN BD ALESSANDRA HARRISON BD ALEJANDRO CALDWELL BD KILLIAN GARDNER BD DANILO THOMAS BD CAMILLE MERRILL BD ANTHONY NELSON BD AMELIA UNIVERSITY BD JULIAN GUNN BD BRIELLE ADAMS BD ANGEL LONG BD ARYANNA MORGAN BD SEBASTIAN ADAMSON BD ALEX ADAMS BD AMIRA GORDON BD LINCOLN WM BD GUSTAVO WILLIAMS BD MALAYA WILLIAMS BD RONALD BALDWIN BD LUKAS DAVIDSON BD JACK HART BD OLIVER GRIFFITH BD JACOB PHELPS BD HELEN LEES BD KEEGAN PARKER BD SCARLETT JOHNSTON BD AVA BLACK BD JACOB CLINTON BD NOAH SMITH BD ELI BENNETT BD AVA FLEMING BD ALESSANDRO ELLIS BD JORGE BUTLER BD BENNETT MITCHELL BD ANTHONY HOLLIDAY BD LEVI SCOTT BD HANNAH HALL BD GRACE FISHER BD MONTSERRAT THOMAS BD ROME ANDREWS BD ROME ANDREWS BD LEILA JAMES BD LEILA JAMES BD ADELINE DANIEL BD ADELINE DANIEL BD HAZEL BROOKS BD HAZEL BROOKS BD ZACHARY ALLAN BD ZACHARY ALLAN BD NATHAN COHEN BD NATHAN COHEN BD RYAN BLACK BD RYAN BLACK BD VINCENT BROWN BD VINCENT BROWN BD CALEB WATERS BD CALEB WATERS BD RAUL READ BD RAUL READ BD LILLIAN MORTON BD LILLIAN MORTON BD ZAYN ANN BD ZAYN ANN BD JACE ANDERSON BD JACE ANDERSON BD BODHI REES BD BODHI REES BD EZEKIEL SMITH BD EZEKIEL SMITH BD STELLA TAFT BD STELLA TAFT BD DYLAN ANDERSON BD DYLAN ANDERSON BD FELIX MASON BD FELIX MASON BD JASON KENDALL BD JASON KENDALL BD AVA SMITH BD AVA SMITH BD ALEXANDER BROOKE BD ALEXANDER BROOKE BD DANIEL WARD BD DANIEL WARD BD ROMEO MASON BD ROMEO MASON BD ALICIA PLUMMER BD ALICIA PLUMMER BD JAX HOOPER BD JAX HOOPER BD ARIAN ALLEN BD ARIAN ALLEN BD DANIEL FREEMAN BD DANIEL FREEMAN BD KAI HYDE BD KAI HYDE BD MATEO JARVIS BD MATEO JARVIS BD JACQUELINE YEAR BD JACQUELINE YEAR BD EVAN BRIGHT BD TRAVIS COX BD SEBASTIAN JOHNSTON BD MILAN STEWART BD Izabella orr BD SIERRA YORK BD RODRIGO KELLY BD AYDEN MYERS BD Nathaniel Tompkins BD CHARLES BARTLETT BD MATEO ALEXANDER BD EMILY WELCH BD TRISTAN COUNTY BD STEPHANIE UPTON BD HARRY NO BD NOAH SCOTT BD JORDAN LIVINGSTON BD CAMERON SMITH BD NATHAN SHARP BD KELSEY HOLMAN BD ISAIAH ROWLAND BD CHARLES GRIFFIN BD PATRICK LYNCH BD MAURICIO DALY BD LENNON WATSON BD THEODORE CROSS BD KEVIN WEIR BD ABEL WOOD BD ELEANOR CREEK BD JUNE ANDERSON BD juan mc lean BD RAUL PATTERSON BD ASHLEY TURNER BD ALEXANDER JACKSON BD JESUS LORD BD KALIYAH DONOVAN BD NATHAN LEE BD JOSE APPLETON BD OLIVER BOYLE BD MICHAEL CORPS BD OWEN HALL BD ALEXANDER SMITH BD OLIVER CHURCH BD JAVIER AMOS BD ANDREW CHAPMAN BD CHARLOTTE HOUSTON BD EMILIA KENT BD LUCA BRIGGS BD HUDSON LEWIS BD MIA SHEARER BD (200 rows) Query #10 departure_airport percentage AAH 17.94871794871795 ABJ 18.990384615384613 ABV 19.667832167832167 ACC 20.085470085470085 ACT 10.897435897435898 ADA 17.94871794871795 ADB 15.976331360946746 ADD 17.403846153846153 ADJ 21.794871794871796 ADL 20.97902097902098 AEP 17.307692307692307 AEX 21.301775147928996 AGA 10.256410256410255 AGB 19.871794871794872 AGP 13.782051282051283 AGR 15.384615384615385 AGU 13.461538461538462 AJU 23.076923076923077 AKC 19.230769230769234 AKL 18.13186813186813 ALP 14.743589743589745 ALY 19.230769230769234 AMA 21.052631578947366 AMD 10.256410256410255 AMI 21.153846153846153 AMM 19.72027972027972 AMQ 20.51282051282051 AMS 18.784457862956156 ANC 17.142857142857142 ANK 11.538461538461538 ANR 21.153846153846153 AOC 18.58974358974359 APL 21.794871794871796 AQP 12.82051282051282 ARN 19.355847404627895 ASR 22.435897435897438 ASU 16.666666666666664 ATH 19.08653846153846 ATL 18.265856950067477 ATQ 19.230769230769234 AUG 17.94871794871795 AUH 18.622338113863538 AUS 18.55921855921856 AYT 17.823639774859288 AZD 7.6923076923076925 AZI 20.51282051282051 BAD 19.230769230769234 BAQ 16.025641025641026 BBI 13.461538461538462 BBJ 19.871794871794872 BBU 19.871794871794872 BCD 20.51282051282051 BCN 18.89198884017537 BDJ 19.230769230769234 BDO 21.794871794871796 BEL 19.871794871794872 BEW 20.51282051282051 BEY 17.735042735042736 BFH 21.153846153846153 BFI 20.054945054945055 BFL 19.047619047619047 BFM 13.461538461538462 BFN 17.94871794871795 BFS 19.648829431438127 BGA 21.153846153846153 BGF 15.384615384615385 BGY 17.20647773279352 BHD 21.428571428571427 BHO 16.025641025641026 BHX 19.755244755244757 BIF 19.230769230769234 BJM 21.367521367521366 BKI 17.307692307692307 BKK 18.697361033127457 BKO 14.285714285714285 BLQ 15.128205128205128 BLR 17.557251908396946 BMA 21.794871794871796 BNA 19.1008316008316 BND 20.51282051282051 BNE 18.085106382978726 BOD 22.344322344322347 BOG 19.48717948717949 BOH 17.032967032967033 BOI 17.081447963800905 BOS 19.17136917136917 BPC 19.230769230769234 BPN 10.897435897435898 BRE 18.803418803418804 BRI 16.88034188034188 BRM 16.025641025641026 BRO 15.384615384615385 BRS 19.71153846153846 BRU 19.771634615384613 BSB 19.11764705882353 BTH 21.153846153846153 BTR 18.016194331983808 BTZ 17.307692307692307 BUD 16.595441595441596 BUF 17.27898966704937 BUG 23.076923076923077 BUQ 15.384615384615385 BUX 21.794871794871796 BWE 12.82051282051282 BWI 18.420060331825038 BWU 14.102564102564102 BYK 12.82051282051282 BYU 21.794871794871796 BZV 16.025641025641026 CAB 20.51282051282051 CAI 17.52958579881657 CAN 18.16724941724942 CBB 14.743589743589745 CBQ 16.666666666666664 CCP 21.794871794871796 CCS 17.908653846153847 CDG 18.779264214046822 CGB 20.51282051282051 CGH 15.384615384615385 CGK 18.209408194233685 CGN 16.105769230769234 CGO 18.104118104118104 CGP 19.871794871794872 CGR 16.666666666666664 CHA 19.65811965811966 CIA 19.055944055944053 CIX 16.025641025641026 CJB 18.58974358974359 CJS 19.871794871794872 CKG 17.871017871017873 CLE 18.09629219701162 CLO 19.230769230769234 CLT 19.143639531989045 CMB 15.625 CMH 18.328100470957615 CMN 18.791208791208792 CNF 18.055555555555554 CNW 18.58974358974359 COO 19.230769230769234 COS 18.657937806873978 CPH 17.890818858560795 CPT 19.951923076923077 CRP 15 CTA 18.356643356643357 CTG 17.307692307692307 CTS 18.91025641025641 CTU 18.20353559483994 CUC 19.230769230769234 CUL 14.423076923076922 CUN 19.230769230769234 CUU 17.307692307692307 CVG 18.970503181029496 CVJ 17.94871794871795 CWB 18.40659340659341 DAC 17.307692307692307 DAL 20.17094017094017 DAM 22.252747252747252 DAR 17.307692307692307 DCA 18.04608893216488 DEL 19.365721997300945 DEN 18.347079616226225 DET 26.282051282051285 DGO 16.025641025641026 DJB 17.94871794871795 DKR 19.230769230769234 DLA 18.982630272952854 DLC 16.35969664138678 DMA 20.51282051282051 DNZ 21.794871794871796 DPS 17.992177314211215 DRS 20.040485829959515 DSM 19.672131147540984 DTM 15.705128205128204 DTW 17.86897313213103 DUB 19.176213857064923 DUR 19.78021978021978 DUS 19.538461538461537 DXB 17.52136752136752 DYU 17.307692307692307 EDF 19.230769230769234 EDI 18 EFD 21.153846153846153 ELP 17.227564102564102 EME 17.94871794871795 ENU 15.384615384615385 EOH 20.51282051282051 ERF 13.461538461538462 ESB 20.753205128205128 ESS 10.897435897435898 EVN 16.538461538461537 EWR 18.37121212121212 FAT 19.602977667493796 FCO 20.159151193633953 FDH 16.025641025641026 FIH 18.639053254437872 FKI 17.94871794871795 FLL 18.45557543231962 FLN 20.76923076923077 FNA 16.968325791855204 FNJ 14.102564102564102 (200 rows)