| ==== |
| ---- QUERY: TPCDS-Q12 |
| select i_item_id |
| ,i_item_desc |
| ,i_category |
| ,i_class |
| ,i_current_price |
| ,sum(ws_ext_sales_price) as itemrevenue |
| ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over |
| (partition by i_class) as revenueratio |
| from |
| web_sales |
| ,item |
| ,date_dim |
| where |
| ws_item_sk = i_item_sk |
| and i_category in ('Sports', 'Books', 'Home') |
| and ws_sold_date_sk = d_date_sk |
| and cast(d_date as timestamp) between cast('1999-02-22' as timestamp) |
| and (cast('1999-02-22' as timestamp) + interval 30 days) |
| group by |
| i_item_id |
| ,i_item_desc |
| ,i_category |
| ,i_class |
| ,i_current_price |
| order by |
| i_category |
| ,i_class |
| ,i_item_id |
| ,i_item_desc |
| ,revenueratio |
| limit 100; |
| ---- RESULTS |
| 'AAAAAAAAAAKAAAAA','Small, political activities help great, bad policies. Therefore square features provide on a machines. Rules make over me','Books','arts',2.42,2742.60,3.71 |
| 'AAAAAAAABHDCAAAA','Minor heads close common children; recently strong firms provide. Useful, young men ought to create changes. Popular, common regulations might decide. Points fit. Obvious, glad officials ','Books','arts',3.88,4258.84,5.77 |
| 'AAAAAAAACKEAAAAA','Legs appear eventually soci','Books','arts',35.27,4010.65,5.43 |
| 'AAAAAAAACMDCAAAA','Black, powerful others go now years. Diverse orders might not mean away medium minutes; tight authorities ought to put however for the things','Books','arts',2.75,1156.40,1.56 |
| 'AAAAAAAACNEDAAAA','Particularly labour stores get farmers. Hence true records see rel','Books','arts',6.89,6606.82,8.95 |
| 'AAAAAAAADCCDAAAA','Glad users understand very almost original jobs. Towns can understand. Supreme, following days work by a parents; german, crucial weapons work sure; fair pictur','Books','arts',7.18,10391.81,14.08 |
| 'AAAAAAAADJFCAAAA','Significant, preliminary boys can remain lightly more pale discussion','Books','arts',2.74,8279.54,11.22 |
| 'AAAAAAAADPCCAAAA','Especially true items might supply particularly. Black, automatic words might develop post-war problems. Fresh, visible workers could not appe','Books','arts',4.23,351.78,0.47 |
| 'AAAAAAAAEDKDAAAA','Times live now to a sales. British years bring all financ','Books','arts',4.24,11699.92,15.85 |
| 'AAAAAAAAEGAEAAAA','Far injuries pay so various arms. Courses could go anywhere universal possibilities; talks stand since mean, colonial scho','Books','arts',9.57,51.84,0.07 |
| 'AAAAAAAAFCFBAAAA','Golden estates meet as yet hands. About solid proteins used to tell. Once causal boots imagine frequently new elections; flexible, other ways find re','Books','arts',9.76,59.01,0.07 |
| 'AAAAAAAAGHOBAAAA','Fully existing proceedings could not tak','Books','arts',8.66,625.65,0.84 |
| 'AAAAAAAAIEPCAAAA','New, popular years should think. Shareholders speak also friends; special members could not identify social eyes; indoors full ','Books','arts',0.91,1390.83,1.88 |
| 'AAAAAAAAIHKBAAAA','Very historic arms may happen even able exis','Books','arts',9.19,13439.76,18.21 |
| 'AAAAAAAAIIPDAAAA','Af','Books','arts',6.04,109.23,0.14 |
| 'AAAAAAAAIJGAAAAA','Then western animals could teach somewhere. Today waiting servants confuse','Books','arts',4.10,868.50,1.17 |
| 'AAAAAAAAKKIAAAAA','Naked, popular schemes campaign then offices. Underlying shares may join','Books','arts',79.28,1841.04,2.49 |
| 'AAAAAAAAKNBCAAAA','Early, powerful towns add mainly english savings. Years assist then new, public colleagues. Things might encounter then right new features','Books','arts',6.89,365.60,0.49 |
| 'AAAAAAAAOKPBAAAA','Just good settings must not make; payments assure to a bishops. Principal, sorry amounts would safeguard very so other leaders; tory, substantial stairs m','Books','arts',2.60,5525.16,7.48 |
| 'AAAAAAAAABMBAAAA','Situations retain; units might sit operations; girls shall make. Ca','Books','business',3.16,1204.56,0.96 |
| 'AAAAAAAAACEBAAAA','Prese','Books','business',15.17,17499.32,14.07 |
| 'AAAAAAAAAKBDAAAA','Essential students change even despite a powers. General connections will not maximi','Books','business',3.10,84.80,0.06 |
| 'AAAAAAAABIPBAAAA','Ultimate, other objects might not install good ','Books','business',2.57,7199.93,5.79 |
| 'AAAAAAAABKACAAAA','Total pp. accept with a questions; able, generous a','Books','business',5.25,3702.38,2.97 |
| 'AAAAAAAABMDDAAAA','Head facts resolve even. Characteristics put. Toxic, genuine officials shall not meet. Difficult chil','Books','business',3.85,333.90,0.26 |
| 'AAAAAAAACDBCAAAA','Tiny years could run too above tough volumes. New germans must not leave as possible sales; inj','Books','business',1.22,799.89,0.64 |
| 'AAAAAAAACEPBAAAA','Long, married artists would see negative feelings. Emot','Books','business',1.73,2686.56,2.16 |
| 'AAAAAAAACPODAAAA','Cells stay economic, thin members. Soon special conservatives solve to the figu','Books','business',2.93,2431.81,1.95 |
| 'AAAAAAAADHNCAAAA','Originally major industries matter mediterranean bodies. Cases should not ','Books','business',45.06,2186.10,1.75 |
| 'AAAAAAAAEILDAAAA','Bad, able systems shall fall else. Nuclear, economic ways put in an paths. Serious, labour women must not muster however. Wide new readers ought to help ','Books','business',1.36,293.23,0.23 |
| 'AAAAAAAAFGJCAAAA','Secondary, red structures may seek eyes. High true titles should make now junior fat thoughts. Partly excellent authorities receive direct, net parties. Parents look most also other issues. Empty, con','Books','business',8.59,3319.89,2.67 |
| 'AAAAAAAAFLMDAAAA','Significantly relevant colleges extract knowingly broad investors. Entire members stay. Mediterranean legs would cut on the knees. Forthcoming, particular students u','Books','business',4.81,347.70,0.27 |
| 'AAAAAAAAFNOCAAAA','Wonderful systems ask also very parliamentary orders; british companies','Books','business',87.12,105.98,0.08 |
| 'AAAAAAAAGFDCAAAA','Particularly medieval blocks would not find slightly with a carers. Years respond about at a sec','Books','business',6.00,51.40,0.04 |
| 'AAAAAAAAGONBAAAA','Ever top offers might struggle far, automatic men. Long-term, long goods dare however; new, other gr','Books','business',2.30,1233.76,0.99 |
| 'AAAAAAAAIBKDAAAA','Hundreds drop nearly unacceptable accidents. Then strong methods tell large unions. Short companies should help so. Moves shall not set later chief problems. R','Books','business',0.78,1158.21,0.93 |
| 'AAAAAAAAIJECAAAA','Difficult, royal units put particularly significant, other plans. Essential, contemporary journals will need players. Alternatively parental','Books','business',4.34,10631.67,8.55 |
| 'AAAAAAAAIKEAAAAA','All ','Books','business',9.44,2.07,0.00 |
| 'AAAAAAAAIPADAAAA','Orders go into the documents. Social, existing specialists will seem twice associated wishes. Finally nation','Books','business',5.15,1755.92,1.41 |
| 'AAAAAAAAKAJDAAAA','Short neighbours implement innocently tiny titles. Briefly simple years should not tell potentially successful, whole years. Orange workers carry; home hot feet l','Books','business',4.43,17638.20,14.18 |
| 'AAAAAAAAKMAAAAAA','Plans consult interested, light boys. Selective, other problems create scientific, young parties. Sufficient speakers might not kiss too social, basic interests. Dual, other times s','Books','business',0.19,3867.73,3.11 |
| 'AAAAAAAALDFAAAAA','Hands may not allow only in a lands; linear, other pubs say; social, precise women identify for a patients. Preferences develop alone now rich motives. Ever good tas','Books','business',3.68,470.96,0.37 |
| 'AAAAAAAALGBBAAAA','Modern records retain about there civil plans. Social bodies survive. Great, living losses bother late, coherent others. About british sports ought to use cautiously from ','Books','business',1.94,229.35,0.18 |
| 'AAAAAAAALPDCAAAA','So small edges will understand currently in a things. New trains point usually systems. Years look growing questions. Different cases could sell just alive, late rules; big, large results will make ','Books','business',4.12,6151.95,4.94 |
| 'AAAAAAAAMIGCAAAA','Carefully physical hotels must put together; similar details cannot appreciate by a standards. Rates can break m','Books','business',6.63,25528.76,20.53 |
| 'AAAAAAAAMIMCAAAA','About likely houses like international members. Final, relevant birds answer after the paintings. Hungry, personal days borrow tiny, primary resources. As social relations could choose quite also ','Books','business',0.77,417.22,0.33 |
| 'AAAAAAAAMKHAAAAA','Unions shall see enough over true attitudes; of course full variable','Books','business',8.90,633.16,0.50 |
| 'AAAAAAAAMKNDAAAA','Special, clear elements would buy at a games. Things should spot today strange, only devices. Armies should like at a patients. Hands could perform simply narrow values. N','Books','business',1.28,11196.30,9.00 |
| 'AAAAAAAANACBAAAA','New teachers might demand never assets. Deeply bright ministers make generally never prime imports. Odd writings step common readers; talks take young, r','Books','business',2.95,1151.28,0.92 |
| 'AAAAAAAAAHKDAAAA','Decisions play actually exclusive activities. Well assistant e','Books','computers',8.77,822.69,0.98 |
| 'AAAAAAAABHEEAAAA','Subjects may remain officials. Forward, straight objects used to see wh','Books','computers',6.97,5663.04,6.77 |
| 'AAAAAAAAEAPAAAAA','Just distinct children think individuals; popular arguments develop here cautious methods; appropriate children might beat. Proper, empirical hundreds fall oth','Books','computers',4.01,9320.46,11.15 |
| 'AAAAAAAAEDMAAAAA','Books understand. Principles produce just at a premises. Years ','Books','computers',44.48,787.29,0.94 |
| 'AAAAAAAAEMHAAAAA','Boots recommend usually just local centres; c','Books','computers',7.56,765.23,0.91 |
| 'AAAAAAAAFEEAAAAA','Capital, united feelings paint only things. Greatly financial economies should not pay somewhere soviet necessary armies; educational concepts mus','Books','computers',3.83,78.76,0.09 |
| 'AAAAAAAAGENAAAAA','Genera','Books','computers',2.84,4719.74,5.65 |
| 'AAAAAAAAGHCBAAAA','Hundreds would meet regardless german, foreign scien','Books','computers',9.77,2451.75,2.93 |
| 'AAAAAAAAGMBDAAAA','Vulnerable b','Books','computers',0.58,31.86,0.03 |
| 'AAAAAAAAGNGBAAAA','Brilliant, massive prisons take still national others. Only northern guidelines go right by the lips. General, spiritual walls shall reach in a languages. British nations eat substantial polici','Books','computers',3.42,2248.01,2.69 |
| 'AAAAAAAAIGCEAAAA','Concerned numbers can attempt now particular, white friends; un','Books','computers',3.38,1297.25,1.55 |
| 'AAAAAAAAIGJAAAAA','Probably terrible students may go. There whole issues get academic, soviet charts. ','Books','computers',4.11,84.42,0.10 |
| 'AAAAAAAAIILCAAAA','At least low personnel might a','Books','computers',9.13,529.20,0.63 |
| 'AAAAAAAAJBADAAAA','Mean, good relations wake however strictly white possibilities. About aw','Books','computers',6.42,5473.02,6.55 |
| 'AAAAAAAAJJGBAAAA','Strangers gain officially enough labour problems. Overall systems may not help below lives. Heroes find just apparently generous couple','Books','computers',7.15,7846.40,9.39 |
| 'AAAAAAAALCDAAAAA','Clearly actual places would supply apparently only rats.','Books','computers',4.34,4611.20,5.52 |
| 'AAAAAAAALDBBAAAA','Mines should talk outside trees. Regular eyes encourage with an victims. Civil functions try actions. Movies fit secretly for a regions. Whole, imperial customs forget','Books','computers',7.44,5240.16,6.27 |
| 'AAAAAAAAMJEAAAAA','Local pro','Books','computers',1.04,843.52,1.00 |
| 'AAAAAAAAMMDEAAAA','Women support almost','Books','computers',4.68,1401.06,1.67 |
| 'AAAAAAAAMNOBAAAA','Scientific, young creditors might see for the alternativ','Books','computers',6.98,100.95,0.12 |
| 'AAAAAAAAMOHBAAAA','Fortunately past rules mind respectively appropriate losses. Men must develop above the sources. Mere values lis','Books','computers',2.02,5603.38,6.70 |
| 'AAAAAAAANAJDAAAA','Religious, delicious ways must a','Books','computers',7.07,14.55,0.01 |
| 'AAAAAAAANFJBAAAA','Only old doors shall wear again. Earlier high minerals might not tell better persona','Books','computers',16.62,0.00,0.00 |
| 'AAAAAAAANHFDAAAA','Easier strong operators could not break very; new, permanent animals ','Books','computers',1.15,2953.07,3.53 |
| 'AAAAAAAAOBNDAAAA','Levels undermine unfortunately efficient weeks','Books','computers',2.19,2853.36,3.41 |
| 'AAAAAAAAPDLCAAAA','Inc considerations should dare sales. Little, long chapters check better exciting employers. Still english unions could pull wrong shoes. Factors would kee','Books','computers',70.39,7100.08,8.50 |
| 'AAAAAAAAPJCCAAAA','Strong, british horses may not choose less. Results will not carry harsh workers. False claims will want over labour increases. Co','Books','computers',1.05,7745.78,9.27 |
| 'AAAAAAAAPKOBAAAA','Yet whole dealers p','Books','computers',3.63,2856.73,3.42 |
| 'AAAAAAAAPLIDAAAA','Items look somewhat new designs. Patients should solve about a officers. Minutes can act still companies. About dangerous records will not run towa','Books','computers',1.43,86.09,0.10 |
| 'AAAAAAAAABPAAAAA','Particularly professional women may not tell never present, distant times. Current, only weeks could hurry quite appropriate months. Little attacks waste carefully never politi','Books','cooking',1.82,6350.52,12.31 |
| 'AAAAAAAAAJNDAAAA','Physical, political decis','Books','cooking',6.76,0.00,0.00 |
| 'AAAAAAAABINAAAAA','Below invisi','Books','cooking',9.59,2547.42,4.94 |
| 'AAAAAAAABONAAAAA','Gains cannot cross colourful, long individuals. Drily red difficulties may not say to a plans. Very different cases ta','Books','cooking',1.60,1388.77,2.69 |
| 'AAAAAAAACBDCAAAA','Well independent scores fight rare changes. Scottish rights would not give; implicit, modern services like yet. Conservative, effective yards should marry about a buildings. Valid, m','Books','cooking',0.50,381.18,0.73 |
| 'AAAAAAAAGALAAAAA','Great, only pages might not contribute so; small components require on a films. Times find apparently. So traditional sources find conditions. Gro','Books','cooking',3.40,2359.09,4.57 |
| 'AAAAAAAAGMMCAAAA','Chief countries leave actually rural, other fathers. Women discover very otherwise large ministers. Slow, envi','Books','cooking',7.35,13258.98,25.71 |
| 'AAAAAAAAGOCAAAAA','Historical, economic lights shall stand much big, odd proposals. Rather grateful branches ought to take. Northern, high miles must ask increasingly. Once chronic','Books','cooking',4.37,3383.64,6.56 |
| 'AAAAAAAAKCCAAAAA','Possible schools carry primarily dual rises; important meetings could continue other passengers. More scottish things might not fall orders. Right, unable expectati','Books','cooking',4.44,4158.51,8.06 |
| 'AAAAAAAAKEJAAAAA','Other, atlantic regions know fast. Li','Books','cooking',68.84,5439.00,10.54 |
| 'AAAAAAAAKJGDAAAA','International eyes might see sales. Joint universities must not hold somewhat with a days. Perfect, profitable trials ought to seem; even pale quantities ','Books','cooking',0.94,5746.30,11.14 |
| 'AAAAAAAALBKAAAAA','Conditions used to test so for a spirits; open, royal provisions might not look approximate','Books','cooking',36.97,5238.71,10.16 |
| 'AAAAAAAALIGAAAAA','There superb accidents may strike individual results. Quiet, only forests drop as little unlikely towns. Observations can discern with a points. Substantial banks dest','Books','cooking',0.88,73.37,0.14 |
| 'AAAAAAAAMIBCAAAA','Views present rapidly in the relations. Average winners could fall double stations; also corresponding heroes promote direct,','Books','cooking',3.17,693.26,1.34 |
| 'AAAAAAAAONGCAAAA','Outcomes will become high wide, substantial clients. Sufficient, new resources weaken only over the moments. Of cour','Books','cooking',1.32,170.00,0.32 |
| 'AAAAAAAAPNFEAAAA','Wooden, civil fingers keep great, possible scales. Police begin ago in common responsible times. Further open fathers can believe aga','Books','cooking',0.33,367.15,0.71 |
| 'AAAAAAAAADBDAAAA','Upper men used to give still different girls. Proposals subsidise famous nerves. C','Books','entertainments',2.21,701.28,1.07 |
| 'AAAAAAAAAIKCAAAA','Troubles must know wise indicators. Kinds enter technical, new doubts. Likely, annual eyes see equivalent payments. Both inadequate feelings decide ever initial ','Books','entertainments',5.04,10130.68,15.55 |
| 'AAAAAAAABGOBAAAA','Japanese, long students may help very; there partial bombs must assess; intentions cannot execute most certain children; indeed necessary a','Books','entertainments',5.36,1174.34,1.80 |
| 'AAAAAAAACIDAAAAA','Millions might answer. Attractive rules might beat coloured volunteers. Scottis','Books','entertainments',3.51,4097.70,6.29 |
| 'AAAAAAAADCOAAAAA','Silly acres shall belong alike following, similar pairs. Respectively lucky newspapers shall dare. Also labour requirements can leave; pounds used to stay even only solicitors. Silver systems may de','Books','entertainments',75.74,613.76,0.94 |
| 'AAAAAAAADGKAAAAA','However small values ','Books','entertainments',1.49,3795.87,5.82 |
| ---- TYPES |
| STRING, STRING, STRING, STRING, DECIMAL, DECIMAL, DECIMAL |
| ==== |