/
q20.sql.out
105 lines (104 loc) · 24.4 KB
/
q20.sql.out
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
-- Automatically generated by TPCDSQueryTestSuite
-- !query schema
struct<i_item_id:string,i_item_desc:string,i_category:string,i_class:string,i_current_price:decimal(7,2),itemrevenue:decimal(17,2),revenueratio:decimal(38,17)>
-- !query output
AAAAAAAAMJJBAAAA NULL Books NULL NULL 9010.49 72.07596281370536693
AAAAAAAAMLGDAAAA NULL Books NULL 6.35 1491.96 11.93436244638591899
AAAAAAAAAELBAAAA Precisely elderly bodies Books arts 1.40 4094.31 1.52075020571659240
AAAAAAAAAFODAAAA Close, precise teeth should go for a qualities. Political groups shall not become just important occasions. Trials mean ne Books arts 2.53 332.38 0.12345595555199313
AAAAAAAAAHMAAAAA Abilities could affect cruel parts. Predominantly other events telephone strong signs. Accurate mate Books arts 25.69 2626.56 0.97558359291967949
AAAAAAAAAJOAAAAA Average parents require also times. Children would not describe lightly purposes; large miles love now correct relations. Usual, german goals proceed literary, wooden visitors. Initial councils wil Books arts 1.24 12327.20 4.57869383019594946
AAAAAAAAALNCAAAA Great, contemporary workers would not remove of course cultural values. Then due children might see positive seconds. Significant problems w Books arts 0.55 343.80 0.12769768794384511
AAAAAAAAANKAAAAA Small objects stop etc mediterranean patterns; liberal, free initiatives would not leave less clear british attitudes; good, blue relationships find softly very Books arts 58.41 886.92 0.32942883476194038
AAAAAAAABGDAAAAA Newly national rights head curiously all electrical cells. Chinese, long values might not pull bad lines. High fun clothes ough Books arts 3.28 2219.85 0.82451923380495801
AAAAAAAACBBAAAAA Quick, easy studies must make always necessary systems. Upper, new persons should buy much physical technologies. English sciences hear solicitors. S Books arts 0.99 2050.16 0.76149125047979491
AAAAAAAACMFDAAAA Early, short v Books arts 75.57 5429.86 2.01681375177070042
AAAAAAAADLLDAAAA Black, following services justify by a investors; dirty, different charts will fly however prizes. Temporary, l Books arts 5.56 13539.35 5.02892289488801418
AAAAAAAAEIPCAAAA Scientific, difficult polls would not achieve. Countries reach of course. Bad, new churches realize most english Books arts 3.98 143.88 0.05344137097545211
AAAAAAAAFCIBAAAA United, important objectives put similarly large, previous phenomena; old, present days receive. Happy detectives assi Books arts 1.26 12297.15 4.56753235398096242
AAAAAAAAFFIBAAAA Naturally new years put serious, negative vehicles. Fin Books arts 3.34 4587.47 1.70392470189572752
AAAAAAAAFJGCAAAA Ago correct profits must not handle else. Healthy children may not go only ancient words. Later just characters ought to drink about. British parts must watch soon ago other clients. So vital d Books arts 4.03 5359.20 1.99056849688381241
AAAAAAAAFLNCAAAA Much new waters Books arts 1.85 6718.63 2.49550179508480530
AAAAAAAAGHBAAAAA Hard different differences would not paint even. Together suitable schemes marry directly only open women. Social ca Books arts 2.65 3208.60 1.19177080144450674
AAAAAAAAGLEBAAAA Tall, following actions keep widely willing, secondary groups. Heads could afford however; agricultural, square pri Books arts 9.99 4780.52 1.77562929368618505
AAAAAAAAGMFAAAAA Anonymous, useful women provoke slightly present persons. Ideas ought to cost almost competent, working parties; aspects provide thr Books arts 6.73 5622.46 2.08835119999055082
AAAAAAAAHHEBAAAA Powerful walls will find; there scottish decades must not Books arts 4.16 7914.41 2.93965054810833964
AAAAAAAAHMCEAAAA Too executive doors progress mainly seemingly possible parts; hundreds stay virtually simple workers. Sola Books arts 34.32 3029.48 1.12524023173973205
AAAAAAAAIBOCAAAA Careful privileges ought to live rather to a boards. Possible, broad p Books arts 3.93 1450.99 0.53894144336718969
AAAAAAAAICMBAAAA Aside legitimate decisions may not stand probably sexual g Books arts 3.88 9619.83 3.57309496629679899
AAAAAAAAIFPBAAAA Specially interesting crews continue current, foreign directions; only social men would not call at least political children; circumstances could not understand now in a assessme Books arts 2.13 13616.57 5.05760473160419719
AAAAAAAAIHNAAAAA Unlikely states take later in general extra inf Books arts 0.32 11879.56 4.41242683475911751
AAAAAAAAINFDAAAA Sometimes careful things state probably so Books arts 5.08 25457.85 9.45581321995700176
AAAAAAAAJGHDAAAA Circumstances would not use. Principles seem writers. Times go from a hands. Members find grounds. Central, only teachers pursue properly into a p Books arts 5.95 2567.54 0.95366178505916251
AAAAAAAAJLHBAAAA Inches may lose from a problems. Firm, other corporations shall protect ashamed, important practices. Materials shall not make then by a police. Weeks used Books arts 0.84 1811.85 0.67297572978782944
AAAAAAAAKFGBAAAA Systems cannot await regions. Home appropr Books arts 7.30 1730.16 0.64263360027028230
AAAAAAAAKHLBAAAA Extra, primitive weeks look obviou Books arts 1.18 22.77 0.00845746467272063
AAAAAAAALCFBAAAA More than key reasons should remain. Words used to offer slowly british Books arts 0.28 10311.18 3.82988320527288194
AAAAAAAALGEEAAAA Children may turn also above, historical aspects. Surveys migh Books arts 7.22 11872.32 4.40973768042312729
AAAAAAAALOKCAAAA Trustees know operations. Now past issues cut today german governments. British lines go critical, individual structures. Tonight adequate problems should no Books arts 4.05 8348.99 3.10106666569599586
AAAAAAAAMACDAAAA Useful observers start often white colleagues; simple pro Books arts 3.47 7565.51 2.81005856636428042
AAAAAAAAMNPAAAAA Members should say earnings. Detailed departments would not move just at the hopes. Figures can take. Actually open houses want. Good teachers combine the Books arts 3.09 4363.97 1.62091006182752106
AAAAAAAAMPFCAAAA Major, senior words afford economic libraries; successful seconds need outside. Clinical, new ideas put now red c Books arts 5.87 9661.08 3.58841646026911898
AAAAAAAANABCAAAA Likely states feel astonishingly working roads. Parents put so somewhere able policies. Others may rely shortly instead interesting bodies; bri Books arts 7.50 132.66 0.04927392461498107
AAAAAAAANMECAAAA Floors could not go only for a years. Special reasons shape consequently black, concerned instances. Mutual depths encourage both simple teachers. Cards favour massive Books arts 1.83 20114.53 7.47114303396483641
AAAAAAAAOAHCAAAA Accurate years want then other organisations. Simple lines mean as well so red results. Orthodox, central scales will not in Books arts 7.69 2153.04 0.79970398502215321
AAAAAAAAODBEAAAA Certain customers think exactly already necessary factories. Awkward doubts shall not forget fine Books arts 0.30 231.71 0.08606408165639427
AAAAAAAAOKEDAAAA Visitors could not allow glad wages. Communist, real figures used to apply factors. Aggressive, optimistic days must mean about trees. Detailed courts consider really large pro Books arts 9.08 24425.09 9.07221501111207600
AAAAAAAAOODBAAAA Deep, big areas take for a facilities. Words could replace certainly cases; lights test. Nevertheless practical arts cross. Fa Books arts 7.37 4380.23 1.62694951617879192
AAAAAAAAAJJBAAAA New, reluctant associations see more different, physical symptoms; useful pounds ought to give. Subjects Books business 9.02 3044.02 1.58609001939612781
AAAAAAAABDMAAAAA Imports involve most now indian women. Developments announce intimately in a copies. Projects Books business 3.26 472.29 0.24608723177265498
AAAAAAAABINDAAAA Years shall want free objects. Old residents use absolutely so residential steps. Letters will share variables. Sure fres Books business 40.76 30227.05 15.74983814849696292
AAAAAAAACAADAAAA Whole, important problems make. Indeed industrial members go skills. Soft Books business 3.22 137.92 0.07186336997625310
AAAAAAAACPBBAAAA Other, black houses flow. New soldiers put only eastern hours. Applications reserve there methods; sources cry pretty scarcely special workers. Never british opportunities Books business 8.20 736.96 0.38399383075478162
AAAAAAAAEBPAAAAA Rows could not Books business 1.65 1290.88 0.67261446516056841
AAAAAAAAEEFDAAAA Remaining subjects handle even only certain ladies; eagerly literary days could not provide. Very different articles cut then. Boys see out of a houses. Governme Books business 9.03 1065.30 0.55507575431918810
AAAAAAAAEFEEAAAA White members see highly on a negotiations. Evident, passive colours can refer familiar, ugly factors; away small examinations shall prove Books business 17.97 1446.00 0.75343991433919646
AAAAAAAAEGCCAAAA Manufacturing, ready concerns see already then new pupils. Both stable types used to manage otherw Books business 1.18 2635.71 1.37333963805184198
AAAAAAAAFCGDAAAA Small, capable centres Books business 2.98 5029.45 2.62060053746422658
AAAAAAAAFDLAAAAA Popular, different parameters might take open, used modules. Prisoners use pretty alternative lovers. Annual, professional others spend once true men. Other, small subsidies seem politically Books business 7.25 621.26 0.32370821658531756
AAAAAAAAFEGEAAAA Supreme, free uses handle even in the customers. Other minutes might not make of course social neighbours. So environmental rights come other, able sales Books business 8.08 3950.22 2.05826654109334761
AAAAAAAAGIJAAAAA Always other hours used to use. Women should jump then. Civil samples take therefore other offices. Concrete, major demands Books business 1.42 2013.79 1.04928752772968910
AAAAAAAAHDKCAAAA Visual fragments Books business 6.77 930.13 0.48464527491308216
AAAAAAAAHDLBAAAA Classic issues will draw as european, engl Books business 75.64 556.83 0.29013689315456070
AAAAAAAAHJAAAAAA Again british shareholders see shares. American lives ought to establish horses. Then ideal conservatives might charge even nec Books business 2.44 1898.13 0.98902275560488173
AAAAAAAAHLKAAAAA Confident, video-tape Books business 3.17 1131.00 0.58930881266779474
AAAAAAAAIHNDAAAA Of course fundamental children will not deal still including a suppliers. More crucial powers will not keep enough. As good comments used to devote even convenient electric problems. Publi Books business 8.85 414.75 0.21610595053401226
AAAAAAAAIMJAAAAA Departments could seek now for a commu Books business 5.93 9895.85 5.15624369039663714
AAAAAAAAJFBEAAAA Paintings must not know primary, royal stands; similar, available others ough Books business 0.39 13809.44 7.19542412909562460
AAAAAAAAJJGBAAAA Most present eyes restore fat, central relationships; again considerable habits must face in a discussions. Engineers help at all direct occasions. Curiously del Books business 80.10 9267.25 4.82871095861681771
AAAAAAAAKBMDAAAA So white countries could secure more angry items. National feet must not defend too by the types; guidelines would not view more so flexible authorities. Critics will handle closely lig Books business 2.50 2542.50 1.32477246349059959
AAAAAAAAKJHDAAAA Simple changes ought to vote almost sudden techniques. Partial, golden faces mean in a officials; vertically minor Books business 8.73 22710.22 11.83318548507904997
AAAAAAAAKJOBAAAA Christian lines stand once deep formal aspirations. National, fine islands play together with a patterns. New journals lose etc positive armie Books business 4.89 11560.78 6.02375732565303988
AAAAAAAAKKDAAAAA Children would not mean in favour of a parts. Heavy, whole others shall mean on Books business 3.13 9065.09 4.72337526492192700
AAAAAAAAKLCCAAAA Lips will n Books business 8.48 541.62 0.28221170567385587
AAAAAAAAKNJCAAAA White fees might combine reports. Tr Books business 2.09 37.60 0.01959152197728478
AAAAAAAALAJCAAAA Asleep children invite more. Wealthy forms could expect as. Indeed statistical examinations could la Books business 3.71 2082.24 1.08495347664844290
AAAAAAAALDHBAAAA Most new weeks go yet members. Also encouraging delegates make publications. Different competitors run resources; somehow common views m Books business 1.07 13412.42 6.98855641485568838
AAAAAAAALHMBAAAA Local, bloody names Books business 4.40 1997.44 1.04076834197626873
AAAAAAAALJJCAAAA Large, larg Books business 3.50 12097.82 6.30358261721370521
AAAAAAAANJLBAAAA Only, gothic Books business 1.68 5708.95 2.97465477106967886
AAAAAAAANKCAAAAA Low, large clouds will not visit for example as the notions. Small, unacceptable drugs might not negotiate environmental, happy keys. Books business 3.11 3020.85 1.57401726502874248
AAAAAAAAOAPAAAAA Silver, critical operations could help howev Books business 5.56 2286.24 1.19124790439754116
AAAAAAAAOBAEAAAA Terrible, psychiatric bones will destroy also used studies; solely usual windows should not make shares. Advances continue sufficiently. As key days might not use far artists. Offici Books business 5.83 6672.40 3.47666146918178041
AAAAAAAAOCHCAAAA Too white addresses end by the talks. Hands get only companies. Statements know. Sentences would pay around for a payments; papers wait actually drinks; men would Books business 6.06 7609.35 3.96486031270882752
AAAAAAAAAGLDAAAA New, big arguments may not win since by a tenant Books computers 1.00 904.16 0.32327741862037314
AAAAAAAAALNBAAAA Else substantial problems slip months. Just unique corporations put vast areas. Supporters like far perfect chapters. Now young reports become wrong trials. Available ears shall Books computers 51.46 18752.88 6.70498876094676063
AAAAAAAABEBEAAAA Cheap, desirable members take immediate, estimated debts; months must track typica Books computers 3.26 10027.86 3.58540600677589698
AAAAAAAABHOAAAAA Expert, scottish terms will ask quiet demands; poor bits attempt northern, dangerous si Books computers 2.66 7330.68 2.62104418148557444
AAAAAAAACCDBAAAA Gradually serious visitors bear no doubt technical hearts. Critics continue earlier soviet, standard minute Books computers 6.40 1711.84 0.61205894564136830
AAAAAAAACCPBAAAA Clear, general goods must know never women. Communications meet about. Other rewards spot wide in a skills. Relative, empty drawings facilitate too rooms. Still asian police end speedily comp Books computers 7.64 1292.04 0.46196177220211789
AAAAAAAACFMBAAAA At least remaining results shall keep cuts. Clients should meet policies. Glorious, local times could use enough; clever styles will live political parents. Single, gradual contracts will describe ho Books computers 9.51 3033.10 1.08446816760026298
AAAAAAAACLPDAAAA Environmental, new women pay again fingers. Different, uncomfortable records miss far russian, dependent members. Enough double men will go here immediatel Books computers 89.89 8553.39 3.05821739476786568
AAAAAAAACOFCAAAA Years learn here. Days make too. Only moving systems avoid old groups; short movements cannot see respectiv Books computers 0.60 3411.40 1.21972724504682903
AAAAAAAACONDAAAA Magnetic Books computers 57.19 3569.09 1.27610843437421206
AAAAAAAADAHAAAAA Ga Books computers 5.53 2687.70 0.96097230360331899
AAAAAAAADDBAAAAA S Books computers 65.78 1613.04 0.57673355084432699
AAAAAAAAEAHCAAAA Simple year Books computers 3.01 1262.79 0.45150359611088856
AAAAAAAAECEEAAAA Agricultural players shall smoke. So full reasons undertake Books computers 0.70 4408.27 1.57615261257037727
AAAAAAAAECGEAAAA Then basic years can encourage later traditions. For example christian parts subscribe informal, valuable gr Books computers 2.75 844.19 0.30183547604973987
AAAAAAAAECHAAAAA Boxes batt Books computers 0.83 15300.82 5.47072375727191844
AAAAAAAAEIGCAAAA Separate, dead buildings think possibly english, net policies. Big divisions can use almost Books computers 9.46 12403.71 4.43487806374503246
AAAAAAAAEJECAAAA Artists make times. Rather ready functions must pre Books computers 5.71 1533.00 0.54811569052494252
AAAAAAAAEMKDAAAA Advantages emerge moves; special, expected operations pass etc natural preferences; very posit Books computers 0.15 5241.45 1.87405152387603389
AAAAAAAAFGLAAAAA Since other birds shall blame sudden Books computers 6.74 2098.16 0.75018552983158082
AAAAAAAAFHNAAAAA Legs throw then. Old-fashioned develo Books computers 2.66 163.26 0.05837271209073850