For your testing purposes, three sample test cases and their output is provided in this file. Use it to verify that your code is working properly. You donot need to turn in the output of these queries. For submission instructions, please refer to the class website (check out INSTRUCTIONS.txt) ----------------------------------------------------- Step 1: Generate 1GB data using dbgen Use the dbgen program to generate the following 8 relations using a scaleup factor of 1: part, supplier, partsupp, customer, nation, lineitem, region, orders Step 2: Convert text files to binary database files using your code Next execute your code and create binary dataabase files and a B-tree index for the following relations and attribute listed below: table | create B-tree index on attribute -------------------------------------------- nation | n_name partsupp | ps_suppkey orders | o_totalprice The schema for the relations are available in the file relschema. We will use the same schema file from the last assignment. Example: What do you want to do? 1. Load a text file into a binary database file. 2. Apply a selection predicate to a binary database file. 1 What do you want to do? 1. Create a binary file without an index. 2. Create a binary file with a B+-Tree index. 2 What is the name of the text file to load? partsupp.tbl What is the name of the file where the schema is located? relschema What is the name of the relation schema? partsupp Where should the binary file be stored? /var/tmp/partsuppFile What attribute would you like to index? ps_suppkey Where should the B+-Tree index file be stored? /var/tmp/partsupp.bt Step 3: Run the sample test cases and verify the output Sample Test Case 1: ==================== This test case makes use of the b-tree on the nation table. What is the name of the attribute to be queried over? n_name What is the lower bound of the query range? CANADA What is the upper bound of the query range? RUSSIA What is the name of the B+-Tree file that will be used to answer the query? /var/tmp/nation.btree Verify that your output matches the postgres output given below. tpch1g=# select * from nation where n_name > 'CANADA' and n_name < 'RUSSIA'; n_nationkey | n_name | n_regionkey | n_comment -------------+---------------------------+-------------+---------------------------------------------------------------------------------------------------------------+-------- 4 | EGYPT | 4 | pending accounts haggle furiously. furiously bold accounts detect. platelets at the packages haggle caref | 5 | ETHIOPIA | 0 | fluffily ruthless requests integrate fluffily. pending ideas wake blithely acco | 6 | FRANCE | 3 | even requests detect near the pendin | 7 | GERMANY | 3 | blithely ironic foxes grow. quickly pending accounts are b | 8 | INDIA | 2 | ironic packages should have to are slyly around the special, ironic accounts. iron | 9 | INDONESIA | 2 | unusual excuses are quickly requests. slyly ironic accounts haggle carefully above the pendin | 10 | IRAN | 4 | blithely even accounts about the furiously regular foxes nag slyly final accounts. quickly final fo | 11 | IRAQ | 4 | express, pending deposits boost quick | 12 | JAPAN | 2 | blithely final packages cajole quickly even dependencies? blithely regular deposits haggle express, ironic re | 13 | JORDAN | 4 | blithe, express deposits boost carefully busy accounts. furiously pending depos | 14 | KENYA | 0 | ironic requests boost. quickly pending pinto beans cajole slyly slyly even deposits. ironic packages | 15 | MOROCCO | 0 | ideas according to the fluffily final pinto beans sleep furiously | 16 | MOZAMBIQUE | 0 | ironic courts wake fluffily even, bold deposi | 17 | PERU | 1 | final, final accounts sleep slyly across the requests. | 18 | CHINA | 2 | bold accounts are. slyly ironic escapades haggle acc | 19 | ROMANIA | 3 | deposits boost against the brave id | (16 rows) Sample Test Case 2: ==================== This test case makes use of the b-tree on the partsupp table. What is the name of the attribute to be queried over? ps_suppkey What is the lower bound of the query range? 4000 What is the upper bound of the query range? 4002 What is the name of the B+-Tree file that will be used to answer the query? /var/tmp/partsupp.bt Verify that your output matches the postgres output given below. tpch1g=# select * from partsupp where ps_suppkey > 4000 and ps_suppkey < 4002; ps_partkey | ps_suppkey | ps_availqty | ps_supplycost | ps_comment ------------+------------+-------------+---------------+--------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------+--------- 1500 | 4001 | 4975 | 554.85 | final depths must are carefully. even accounts are furiously. carefully silent requests | 4000 | 4001 | 4076 | 277.03 | quickly pending accounts detect even, even platelets. carefully ironic instructions wake slyly above the | 6500 | 4001 | 631 | 770.69 | final braids sleep blithely. carefully even accounts hinder carefully across the final, express | 9000 | 4001 | 5803 | 751.19 | blithely busy packages after the silent platelets sleep slyly about t | 11499 | 4001 | 1184 | 271.88 | bold theodolites above the carefully ironic excuses haggle fluffily against the furiously ironic deposits. f | 14000 | 4001 | 804 | 105.46 | furiously ironic dependencies grow furiously after the blithely regular deposits. blithely regular pinto beans among the blithely pe | 16497 | 4001 | 2936 | 728.2 | slyly even requests sleep. slyly regular asymptotes are slyly. ironic theodolites haggle fluff | 18998 | 4001 | 1866 | 502.51 | slyly ironic courts according to the quickly ironic accounts are carefully blithely regular gr | 21498 | 4001 | 6702 | 227.62 | slyly regular somas wake carefully. quickly regular excuses nag blithely packages. furiousl | 24000 | 4001 | 4349 | 812.82 | instructions cajole after the blithely express deposits. ironic requests wake slyly express, pending foxes! fu rious | 26494 | 4001 | 6811 | 453.56 | blithely regular pinto beans sleep. blithely express courts boost fluffily alongside of the fluffily pending t heodolites. final theodolites haggle blithel | 28996 | 4001 | 419 | 586.09 | unusual dependencies nag quickly across the slyly express pinto beans; quickly even pinto beans affix along th e blithely pending | 31497 | 4001 | 135 | 338.98 | bold accounts are. slyly final deposits for the dogged theodolites haggle regular, ironic deposits. slyly regu lar accounts use blithely across the ideas. blithely pending re | 34000 | 4001 | 9774 | 53.25 | regular packages alongside of the furiously pending pinto beans play blithely pinto beans. regular deposits us e carefully across the special escapades. spe | 36491 | 4001 | 2586 | 366.98 | carefully final dependencies across the blithely special gifts boost slyly special instructions. express packa ges are furiously furiously | 38994 | 4001 | 5426 | 213.58 | unusual requests sleep blithely fluffily final dolphins. pending pinto beans hinder. furiously unusual account s boost after the special, ironic excuses. regular, ironic | 41496 | 4001 | 943 | 780.49 | carefully express accounts hang carefully among the requests. foxes along the ironic excuses boost along the q uickly ironic accounts. packages sleep blithely blithely special deposits. slyly final | 44000 | 4001 | 1553 | 616.39 | furiously bold Tiresias cajole blithely furiously pending deposits. pending pac | 46488 | 4001 | 1098 | 711.06 | quickly even theodolites boost slyly alongside of the quickly final deposits. unusual packages wake acco | 48992 | 4001 | 4972 | 969.06 | quickly express instructions haggle doggedly furiously regular multipliers. ruthlessly bold pinto beans lose f uriously across the slyly special requ | 51495 | 4001 | 7857 | 794.64 | fluffily even deposits above the carefully ironic packages wake after the blithely even ideas. | 54000 | 4001 | 6317 | 358.46 | carefully close accounts boost forges. slyly silent accounts wake among the carefully regular requests. quickl y even packages sleep furiously. carefully regular accounts nag da | 56485 | 4001 | 2977 | 942.54 | accounts wake slyly above the instructions. silent theodolites w | 58990 | 4001 | 8314 | 934.52 | slyly ironic platelets are. pending, express accounts print. sometimes special deposits nag careful | 61494 | 4001 | 7759 | 784.45 | pending, special requests wake. even requests above the accounts cajole special, ironic requests. carefully ex press Tiresias sleep furiously against the carefully pending instructions. | 64000 | 4001 | 9652 | 270.01 | sly, pending packages nod. unusual theodolites are. carefully even foxes around the fluffily unusual theodolit es sleep platelets; slyly dogged platelets doze s | 66482 | 4001 | 3338 | 166.78 | blithely even deposits sleep dinos. slyly regular requests use blithely packages. carefully unusual requests h aggle slyly final foxes. furiously ironic de | 68988 | 4001 | 3293 | 902.85 | regular, even deposits sublate quickly final, even excuses. quickly express requests are blithely carefully ev en foxes. final, regular accounts haggle. slyly special packages engage slyly blithel | 71493 | 4001 | 7057 | 645.58 | furiously bold sentiments doze. special platelets cajole fluffily. deposits detect blithely. fl | 74000 | 4001 | 2980 | 419.65 | blithely daring accounts sleep slyly across the blithely final deposits. regular, regular dependencies cajole furiously ironic pinto beans. slyly bold foxes at the furiously | 76479 | 4001 | 5676 | 704.57 | carefully regular accounts are slyly. slyly ironic packages against the quickly regular excuses boost slyly ac counts. | 78986 | 4001 | 2933 | 363.77 | ironic, ironic theodolites doubt. accounts affix about the theodolites. quickly pe | 81492 | 4001 | 7479 | 275.78 | carefully ironic packages detect carefully. quickly ironic deposits are blithely. furiously regular packages r un above the pending asymptotes. pending pinto beans after the ca | 84000 | 4001 | 3025 | 498.66 | epitaphs above the unusual, special asymptotes nag above the furiously even packages. carefully stealthy packa ges against the even, even theodolites boost furiously special packages. slyly regular a | 86476 | 4001 | 1527 | 522.75 | regular instructions are furiously. requests cajole carefully alongside of the slyly final dolphins. ironic, s ilent requests wake quickly. blithely ironic | 88984 | 4001 | 6718 | 800.3 | busily ironic theodolites sleep slyly. instructions against the platelets use quickly blithely express package s; quickly silent deposits across the foxes sleep according to | 91491 | 4001 | 6699 | 551.33 | final requests need to haggle furiously above the slyly regular instructions. bold dependencies breach slyly | 94000 | 4001 | 5241 | 877.21 | requests solve quickly blithely even depths. express theodolites are furiously. furiously express tithes wake. account | 96473 | 4001 | 7172 | 113.39 | quickly bold platelets cajole fluffily even, final foxes. packages are slyly carefully even packages. furiousl y ex | 98982 | 4001 | 828 | 396.95 | furiously express dependencies poach furiously after the quickly bold requests; pending packages about the exp ress asymptotes detect blithely carefully unusual dolphins. slyly final f | 101490 | 4001 | 7034 | 603.46 | pending accounts mold furiously across the even requests. never ironic deposits are carefully about the furiou sly regular requests. fluffily ironic req | 104000 | 4001 | 4454 | 796.5 | ironic, final requests haggle above the furiously express instructions. fluffily close excuses nag furiously a bout the blithely regular requests. c | 106470 | 4001 | 4785 | 565.71 | Tiresias wake carefully. final, regular accounts sleep slyly slyly regular depo | 108980 | 4001 | 8137 | 836.42 | blithely bold accounts across the blithely slow excuses nag carefully ironic, express requests. blithely regul ar depen | 111489 | 4001 | 1499 | 902 | quickly unusual deposits wake slyly about the quickly final foxes. ironic reques | 114000 | 4001 | 3685 | 667.76 | accounts use; furiously quiet packages cajole even, ironic packages. fluffily regular packages detect slyly. | 116467 | 4001 | 3779 | 279.79 | ironically pending ideas cajole. blithely pending courts wake. quickly regular instructions wake above the fin al requests. platelets believe slyly even platelets. unusual requests sle | 118978 | 4001 | 5183 | 512.65 | carefully bold deposits cajole slyly regular deposits. furiously ironic deposits | 121488 | 4001 | 3365 | 439.56 | dugouts haggle along the even dependencies. slyly bold foxes haggle about the packages? quickly special packag es along the slyly regular packages sleep blithely closely even sh | 124000 | 4001 | 3326 | 191.01 | slyly express Tiresias about the regular, express theodolites cajole carefully above the slyly u | 126464 | 4001 | 8666 | 110.75 | furiously regular packages sleep carefully. requests print blithely alongside of the carefully ironic deposits . | 128976 | 4001 | 4800 | 720.49 | regular, blithe requests print quickly furiously ironic foxes. slyly even foxes are carefully alongside of the quickly express accounts. busy deposits of the slyly regular asymptotes wake q | 131487 | 4001 | 9168 | 399.52 | blithely regular accounts use about the blithely even dependencies. furiously ironic deposits use alongside of the slyly final accounts. flu | 134000 | 4001 | 8396 | 777.61 | special pinto beans are slyly final requests. ironic, regular pinto beans nag carefully instructions. furiousl y careful packages use | 136461 | 4001 | 2248 | 899.84 | carefully regular packages haggle blithely slyly even requests. requests across the carefully ironic packages boost blithely regular packages. final somas are slyly alongside of the quickl | 138974 | 4001 | 4116 | 370.6 | furiously even accounts nag across the permanent foxes. quickly unusual requests haggle. regular, express plat elets nag fluffily. regular pinto beans cajole carefully furiously silent | 141486 | 4001 | 2194 | 40.01 | furiously unusual packages around the foxes wake slyly blithely regular dolphins. pending deposits cajole | 144000 | 4001 | 9342 | 275.88 | fluffily regular theodolites cajole even foxes. blithely special packages haggle slyly carefully bold platelet s. quickly even orbits | 146458 | 4001 | 8941 | 615.67 | packages boost furiously furiously bold foxes. furiously bold accounts above the accounts maintain carefully a ccording to the pending, e | 148972 | 4001 | 2398 | 876.28 | carefully final theodolites cajole blithely against the slyly final pinto beans. slyly pending requests accord ing to the fluffily even instructions detect fluffily qu | 151485 | 4001 | 2976 | 138.47 | quickly even packages wake regular, even dolphins. blithely unusual courts wake slyly among the special courts . unusual theodolites above the fluffily regular packages solve on the regular t | 154000 | 4001 | 2492 | 719.96 | even, regular accounts wake carefully during the packages. final, even packages after the blithely final multi pliers wake fluffily regular ideas. regular ideas are furiously a | 156455 | 4001 | 1190 | 722.82 | furiously express accounts cajole furiously even instructions-- re | 158970 | 4001 | 4594 | 948.76 | pending, bold escapades wake. quickly regular accounts boost carefully dogged accou | 161484 | 4001 | 5841 | 612.31 | furiously special packages cajole after the dolphins. pinto beans cajole furiously regular accounts. carefully unusual patterns wake carefully al | 164000 | 4001 | 8460 | 788.42 | even braids above the blithely pending requests poach carefully ironic deposits. | 166452 | 4001 | 7855 | 151.81 | fluffily ironic pinto beans use fluffily. furiously final packages use furiously furiously regular accoun | 168968 | 4001 | 9014 | 161.67 | fluffily even pinto beans use quickly above the carefully unusual pinto beans. regular platelets sleep blithel y even | 171483 | 4001 | 2896 | 916.51 | quickly regular packages nag furiously ideas. furiously ironic attainments haggle beside the blithely ironic | 174000 | 4001 | 471 | 963.7 | fluffily ironic accounts must have to sleep blithely. ironic ideas nag; courts a | 176449 | 4001 | 9198 | 122.81 | slyly express requests wake quickly. slyly regular requests use. ironic ideas sleep carefully quick excuses. s pecial, regular requests along | 178966 | 4001 | 9906 | 253.88 | idle, pending packages wake. blithely special courts after the pending platelets sleep according to the quickl | 181482 | 4001 | 3937 | 763.64 | carefully ironic deposits sleep idly upon the regular requests. blithely bold accounts along the slyly final g rouches cajole furiously regular frays. ideas detect quickly. even, even packages ha | 184000 | 4001 | 750 | 763.87 | blithely regular packages integrate blithely according to the blithely pending instructions. blithely unusual epitaphs cajole quickly. slyly even instructions | 186446 | 4001 | 7004 | 811.07 | regular, final accounts alongside of the carefully final packages nag quickly even dolphins. final, final idea s are after the silent f | 188964 | 4001 | 5208 | 642.76 | slyly final theodolites boost. unusual packages cajole express, ironic instructi | 191481 | 4001 | 3896 | 876.99 | carefully special packages nag furiously ironic accounts. special, bold packages will haggle slyly packages. s lyly even ideas boos | 194000 | 4001 | 7618 | 869.47 | quickly ironic courts nag? carefully ironic ideas detect blithely. furiously final theodolites are doggedly re gular dependencies. furiously special accounts above the furiously special accounts | 196443 | 4001 | 2773 | 954.56 | quickly furious deposits kindle. fluffily even accounts sleep. never furious foxes cajole. slyly bold foxes wa ke. fluffily special | 198962 | 4001 | 9006 | 986.58 | furiously silent pinto beans haggle slyly. accounts sleep slyly according to the daring deposits? slyly re | (80 rows) Sample Test Case 3: ==================== This test case makes use of the b-tree on the orders table. What is the name of the attribute to be queried over? o_totalprice What is the lower bound of the query range? 2010.88 What is the upper bound of the query range? 2030.99 What is the name of the B+-Tree file that will be used to answer the query? /var/tmp/orders.bt Verify that your output matches the postgres output given below. tpch1g=# select * from orders where o_totalprice > 2010.88 and o_totalprice < 2030.99; o_orderkey | o_custkey | o_orderstatus | o_totalprice | o_orderdate | o_orderpriority | o_clerk | o_shippriority | o_comment ------------+-----------+---------------+--------------+-------------+-----------------+-----------------+----------------+-------------------------------------------- ------------------------------------+-------- 99077 | 208 | F | 2025.81 | 1992-03-04 | 5-LOW | Clerk#000000974 | 0 | pinto beans cajole carefully ac | 138721 | 92444 | F | 2029.69 | 1992-06-18 | 3-MEDIUM | Clerk#000000899 | 0 | regular ideas sleep. furiously final excuse s sleep. platelets use | 161698 | 100888 | F | 2017.04 | 1995-01-04 | 3-MEDIUM | Clerk#000000111 | 0 | theodolites across the bold accou | 300231 | 136424 | O | 2017.72 | 1997-12-20 | 3-MEDIUM | Clerk#000000737 | 0 | furiously express ideas detect. carefully s ilent | 382855 | 6742 | O | 2024.59 | 1998-02-15 | 2-HIGH | Clerk#000000990 | 0 | express, regular acc | 429863 | 23050 | O | 2013.57 | 1997-10-01 | 4-NOT SPECIFIED | Clerk#000000515 | 0 | slyly unusual accounts integrate blithely r egular do | 560512 | 143111 | O | 2021.91 | 1997-05-25 | 3-MEDIUM | Clerk#000000839 | 0 | ironic ideas up the express, silent ideas s nooze quickly slyly bold depo | 630117 | 68770 | O | 2012.11 | 1996-12-01 | 5-LOW | Clerk#000000219 | 0 | regularly even braids haggle slyly express packages. deposits serve so | 648804 | 21986 | F | 2019.79 | 1992-03-02 | 2-HIGH | Clerk#000000492 | 0 | slyly regular orbits nag blithely even asym ptotes-- packages haggle sly | 682914 | 7204 | F | 2014.06 | 1994-04-12 | 4-NOT SPECIFIED | Clerk#000000432 | 0 | regular requests nag furiously dogged ideas . carefully unusual excuses after t | 902211 | 66310 | F | 2030.03 | 1995-01-04 | 2-HIGH | Clerk#000000136 | 0 | quickly ironic requests above the | 923205 | 73019 | F | 2019.32 | 1992-03-18 | 2-HIGH | Clerk#000000033 | 0 | special asymptotes nod-- furiously thin sau ternes wake above the bli | 1035170 | 122542 | O | 2013.78 | 1995-07-12 | 4-NOT SPECIFIED | Clerk#000000325 | 0 | quickly pending platelets sleep bravely. fu riously regular asymptotes ar | 1066785 | 92750 | F | 2024.64 | 1993-04-24 | 4-NOT SPECIFIED | Clerk#000000477 | 0 | final accounts kindle slyly re | 1110022 | 2545 | O | 2014.56 | 1996-07-03 | 4-NOT SPECIFIED | Clerk#000000944 | 0 | fluffily fluffy theodoli | 1372416 | 142654 | F | 2014.93 | 1992-02-21 | 3-MEDIUM | Clerk#000000124 | 0 | fluffily silent requests along the slyly ir onic | 1418210 | 138395 | O | 2023.13 | 1996-06-04 | 4-NOT SPECIFIED | Clerk#000000847 | 0 | instructions about the iro | 1594886 | 15749 | O | 2023.19 | 1997-12-24 | 1-URGENT | Clerk#000000787 | 0 | slyly sly instructions cajo | 1781410 | 146032 | O | 2019.98 | 1997-07-21 | 4-NOT SPECIFIED | Clerk#000000651 | 0 | accounts haggle to the pending, even a | 2039809 | 106804 | O | 2024.99 | 1995-12-08 | 3-MEDIUM | Clerk#000000673 | 0 | silent dependencies | 2093254 | 23510 | F | 2020.08 | 1993-01-26 | 3-MEDIUM | Clerk#000000304 | 0 | blithely bold pinto beans integrate quickly furiously pending accou | 2149664 | 112910 | F | 2027.01 | 1993-07-15 | 5-LOW | Clerk#000000693 | 0 | blithely unusual packages boost always. sly ly eve | 2397250 | 120812 | O | 2015.63 | 1996-05-22 | 3-MEDIUM | Clerk#000000326 | 0 | fluffily final warthogs haggle blithely acr oss the fluffily unusua | 2665188 | 138304 | F | 2019.45 | 1993-01-14 | 3-MEDIUM | Clerk#000000918 | 0 | quickly unusual theodolit | 2824358 | 127471 | O | 2014.66 | 1997-01-02 | 2-HIGH | Clerk#000000731 | 0 | furiously regular asymptotes are | 2864740 | 62872 | F | 2019.7 | 1993-01-07 | 2-HIGH | Clerk#000000656 | 0 | carefully express dep | 3017922 | 12185 | F | 2021.52 | 1992-06-18 | 5-LOW | Clerk#000000262 | 0 | express pinto beans sleep. even pearls are carefully ab | 3252161 | 140944 | F | 2023.81 | 1992-06-11 | 5-LOW | Clerk#000000415 | 0 | fluffily express theodolites detect along t he pains. blith | 3255522 | 127282 | F | 2020.63 | 1993-10-02 | 2-HIGH | Clerk#000000701 | 0 | furiously final courts grow blithely silent requests? | 3387909 | 115678 | O | 2030.95 | 1997-06-08 | 5-LOW | Clerk#000000606 | 0 | regular ideas should sleep carefu | 3420740 | 46345 | F | 2013.09 | 1994-10-21 | 5-LOW | Clerk#000000583 | 0 | pending warhorses impress. final multiplier s across | 3440386 | 84671 | F | 2028.62 | 1993-09-21 | 1-URGENT | Clerk#000000769 | 0 | fluffily even dependencies are stealthily a r | 3799809 | 116876 | O | 2020.89 | 1996-04-14 | 5-LOW | Clerk#000000784 | 0 | carefully regular platelets believe against the ca | 3842464 | 135995 | F | 2019.61 | 1993-06-13 | 5-LOW | Clerk#000000812 | 0 | express requests sleep carefully. carefully regular instructi | 3915713 | 80198 | F | 2016.89 | 1992-10-31 | 4-NOT SPECIFIED | Clerk#000000053 | 0 | unusual, silent instructions sleep carefull | 3925059 | 80704 | F | 2015.64 | 1994-06-01 | 4-NOT SPECIFIED | Clerk#000000095 | 0 | carefully regular instructions cajole blith el | 4116390 | 27562 | O | 2015.54 | 1995-10-04 | 5-LOW | Clerk#000000926 | 0 | enticingly regular courts against the bold ideas use furiously | 4155431 | 70447 | F | 2021.44 | 1992-08-22 | 2-HIGH | Clerk#000000989 | 0 | slyly special excuses a | 4305635 | 124540 | F | 2017.16 | 1993-06-11 | 3-MEDIUM | Clerk#000000629 | 0 | pending, special instructions use blithely quiet, final asymptotes. | 4375488 | 135562 | F | 2013.24 | 1994-10-21 | 1-URGENT | Clerk#000000809 | 0 | regular frets wake carefully special orbits | 4412834 | 53860 | O | 2018.4 | 1996-05-19 | 4-NOT SPECIFIED | Clerk#000000241 | 0 | express pinto beans us | 4837473 | 65461 | O | 2021.45 | 1996-01-08 | 4-NOT SPECIFIED | Clerk#000000186 | 0 | quickly express foxes integrate carefully b lithe | 4898503 | 115057 | F | 2026.31 | 1994-02-01 | 2-HIGH | Clerk#000000710 | 0 | final deposits wake furiously regular excus es. dogged theodolites along the s | 4975073 | 7336 | F | 2025.3 | 1992-07-07 | 1-URGENT | Clerk#000000334 | 0 | deposits haggle regular dolphins. theodolit es detect flu | 5058181 | 85291 | O | 2026.8 | 1998-03-09 | 3-MEDIUM | Clerk#000000504 | 0 | furiously express foxes haggle special, pen ding | 5115617 | 82507 | F | 2012.47 | 1994-05-07 | 5-LOW | Clerk#000000068 | 0 | deposits wake fluffily | 5118818 | 107326 | O | 2012.9 | 1995-09-30 | 2-HIGH | Clerk#000000374 | 0 | slyly special dugouts engage carefully acro ss t | 5172196 | 146240 | O | 2023.03 | 1997-08-18 | 2-HIGH | Clerk#000000860 | 0 | regular ideas are sly | 5208230 | 84037 | F | 2011.41 | 1993-12-23 | 2-HIGH | Clerk#000000357 | 0 | unusual foxes against the accounts print sl yly theodolites. blithely fin | 5308482 | 69220 | O | 2010.95 | 1997-12-18 | 3-MEDIUM | Clerk#000000958 | 0 | tithes haggle carefully about the packages. carefully ironic pinto beans n | 5544196 | 140228 | O | 2030.54 | 1997-03-09 | 5-LOW | Clerk#000000467 | 0 | special, silent dugouts behind the fluffily re | 5612996 | 149198 | O | 2019.12 | 1996-05-07 | 5-LOW | Clerk#000000535 | 0 | express requests haggle. packages use. unus ua | 5653639 | 111784 | F | 2028.58 | 1992-02-14 | 3-MEDIUM | Clerk#000000428 | 0 | quickly even packages | 5738021 | 111778 | F | 2013.12 | 1994-03-14 | 2-HIGH | Clerk#000000867 | 0 | slyly regular grouches detect bl | 5763940 | 75076 | O | 2020.54 | 1998-06-23 | 2-HIGH | Clerk#000000717 | 0 | accounts haggle quickly among the re | 5898624 | 137050 | O | 2028.02 | 1996-01-27 | 2-HIGH | Clerk#000000855 | 0 | furiously final excuses nag slyly pe | 5966401 | 37282 | F | 2028.99 | 1992-11-20 | 3-MEDIUM | Clerk#000000115 | 0 | blithely even accounts against the carefull y ex | (57 rows) ---------------------- Good luck!