| ==== |
| ---- 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.717520 |
| '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.772743 |
| 'AAAAAAAACKEAAAAA','Legs appear eventually soci','Books','arts',35.27,4010.65,5.436328 |
| '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.567469 |
| 'AAAAAAAACNEDAAAA','Particularly labour stores get farmers. Hence true records see rel','Books','arts',6.89,6606.82,8.955367 |
| '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.085819 |
| 'AAAAAAAADJFCAAAA','Significant, preliminary boys can remain lightly more pale discussion','Books','arts',2.74,8279.54,11.222694 |
| '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.476828 |
| 'AAAAAAAAEDKDAAAA','Times live now to a sales. British years bring all financ','Books','arts',4.24,11699.92,15.858927 |
| '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.070268 |
| '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.079986 |
| 'AAAAAAAAGHOBAAAA','Fully existing proceedings could not tak','Books','arts',8.66,625.65,0.848052 |
| '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.885233 |
| 'AAAAAAAAIHKBAAAA','Very historic arms may happen even able exis','Books','arts',9.19,13439.76,18.217233 |
| 'AAAAAAAAIIPDAAAA','Af','Books','arts',6.04,109.23,0.148058 |
| 'AAAAAAAAIJGAAAAA','Then western animals could teach somewhere. Today waiting servants confuse','Books','arts',4.10,868.50,1.177228 |
| 'AAAAAAAAKKIAAAAA','Naked, popular schemes campaign then offices. Underlying shares may join','Books','arts',79.28,1841.04,2.495480 |
| '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.495561 |
| '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.489206 |
| 'AAAAAAAAABMBAAAA','Situations retain; units might sit operations; girls shall make. Ca','Books','business',3.16,1204.56,0.968966 |
| 'AAAAAAAAACEBAAAA','Prese','Books','business',15.17,17499.32,14.076710 |
| 'AAAAAAAAAKBDAAAA','Essential students change even despite a powers. General connections will not maximi','Books','business',3.10,84.80,0.068214 |
| 'AAAAAAAABIPBAAAA','Ultimate, other objects might not install good ','Books','business',2.57,7199.93,5.791729 |
| 'AAAAAAAABKACAAAA','Total pp. accept with a questions; able, generous a','Books','business',5.25,3702.38,2.978249 |
| 'AAAAAAAABMDDAAAA','Head facts resolve even. Characteristics put. Toxic, genuine officials shall not meet. Difficult chil','Books','business',3.85,333.90,0.268594 |
| '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.643443 |
| 'AAAAAAAACEPBAAAA','Long, married artists would see negative feelings. Emot','Books','business',1.73,2686.56,2.161108 |
| 'AAAAAAAACPODAAAA','Cells stay economic, thin members. Soon special conservatives solve to the figu','Books','business',2.93,2431.81,1.956184 |
| 'AAAAAAAADHNCAAAA','Originally major industries matter mediterranean bodies. Cases should not ','Books','business',45.06,2186.10,1.758531 |
| '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.235879 |
| '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.670568 |
| '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.279695 |
| 'AAAAAAAAFNOCAAAA','Wonderful systems ask also very parliamentary orders; british companies','Books','business',87.12,105.98,0.085252 |
| 'AAAAAAAAGFDCAAAA','Particularly medieval blocks would not find slightly with a carers. Years respond about at a sec','Books','business',6.00,51.40,0.041347 |
| '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.992455 |
| '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.931681 |
| 'AAAAAAAAIJECAAAA','Difficult, royal units put particularly significant, other plans. Essential, contemporary journals will need players. Alternatively parental','Books','business',4.34,10631.67,8.552272 |
| 'AAAAAAAAIKEAAAAA','All ','Books','business',9.44,2.07,0.001665 |
| 'AAAAAAAAIPADAAAA','Orders go into the documents. Social, existing specialists will seem twice associated wishes. Finally nation','Books','business',5.15,1755.92,1.412488 |
| '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.188427 |
| '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.111259 |
| '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.378847 |
| '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.184493 |
| '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.948719 |
| '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.535710 |
| '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.335618 |
| 'AAAAAAAAMKHAAAAA','Unions shall see enough over true attitudes; of course full variable','Books','business',8.90,633.16,0.509323 |
| '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.006468 |
| '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.926107 |
| 'AAAAAAAAAHKDAAAA','Decisions play actually exclusive activities. Well assistant e','Books','computers',8.77,822.69,0.984915 |
| 'AAAAAAAABHEEAAAA','Subjects may remain officials. Forward, straight objects used to see wh','Books','computers',6.97,5663.04,6.779725 |
| '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.158346 |
| 'AAAAAAAAEDMAAAAA','Books understand. Principles produce just at a premises. Years ','Books','computers',44.48,787.29,0.942534 |
| 'AAAAAAAAEMHAAAAA','Boots recommend usually just local centres; c','Books','computers',7.56,765.23,0.916124 |
| '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.094291 |
| 'AAAAAAAAGENAAAAA','Genera','Books','computers',2.84,4719.74,5.650417 |
| 'AAAAAAAAGHCBAAAA','Hundreds would meet regardless german, foreign scien','Books','computers',9.77,2451.75,2.935206 |
| 'AAAAAAAAGMBDAAAA','Vulnerable b','Books','computers',0.58,31.86,0.038142 |
| '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.691291 |
| 'AAAAAAAAIGCEAAAA','Concerned numbers can attempt now particular, white friends; un','Books','computers',3.38,1297.25,1.553053 |
| 'AAAAAAAAIGJAAAAA','Probably terrible students may go. There whole issues get academic, soviet charts. ','Books','computers',4.11,84.42,0.101067 |
| 'AAAAAAAAIILCAAAA','At least low personnel might a','Books','computers',9.13,529.20,0.633552 |
| 'AAAAAAAAJBADAAAA','Mean, good relations wake however strictly white possibilities. About aw','Books','computers',6.42,5473.02,6.552235 |
| '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.393618 |
| 'AAAAAAAALCDAAAAA','Clearly actual places would supply apparently only rats.','Books','computers',4.34,4611.20,5.520475 |
| '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.273458 |
| 'AAAAAAAAMJEAAAAA','Local pro','Books','computers',1.04,843.52,1.009852 |
| 'AAAAAAAAMMDEAAAA','Women support almost','Books','computers',4.68,1401.06,1.677333 |
| 'AAAAAAAAMNOBAAAA','Scientific, young creditors might see for the alternativ','Books','computers',6.98,100.95,0.120856 |
| 'AAAAAAAAMOHBAAAA','Fortunately past rules mind respectively appropriate losses. Men must develop above the sources. Mere values lis','Books','computers',2.02,5603.38,6.708301 |
| 'AAAAAAAANAJDAAAA','Religious, delicious ways must a','Books','computers',7.07,14.55,0.017419 |
| 'AAAAAAAANFJBAAAA','Only old doors shall wear again. Earlier high minerals might not tell better persona','Books','computers',16.62,0.00,0.000000 |
| 'AAAAAAAANHFDAAAA','Easier strong operators could not break very; new, permanent animals ','Books','computers',1.15,2953.07,3.535381 |
| 'AAAAAAAAOBNDAAAA','Levels undermine unfortunately efficient weeks','Books','computers',2.19,2853.36,3.416009 |
| '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.500133 |
| '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.273157 |
| 'AAAAAAAAPKOBAAAA','Yet whole dealers p','Books','computers',3.63,2856.73,3.420044 |
| '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.103066 |
| '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.317737 |
| 'AAAAAAAAAJNDAAAA','Physical, political decis','Books','cooking',6.76,0.00,0.000000 |
| 'AAAAAAAABINAAAAA','Below invisi','Books','cooking',9.59,2547.42,4.941083 |
| '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.693717 |
| '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.739353 |
| '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.575791 |
| 'AAAAAAAAGMMCAAAA','Chief countries leave actually rural, other fathers. Women discover very otherwise large ministers. Slow, envi','Books','cooking',7.35,13258.98,25.717677 |
| '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.563051 |
| '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.066022 |
| 'AAAAAAAAKEJAAAAA','Other, atlantic regions know fast. Li','Books','cooking',68.84,5439.00,10.549714 |
| '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.145766 |
| 'AAAAAAAALBKAAAAA','Conditions used to test so for a spirits; open, royal provisions might not look approximate','Books','cooking',36.97,5238.71,10.161223 |
| '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.142312 |
| '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.344676 |
| '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.329739 |
| '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.712140 |
| 'AAAAAAAAADBDAAAA','Upper men used to give still different girls. Proposals subsidise famous nerves. C','Books','entertainments',2.21,701.28,1.076508 |
| '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.551214 |
| '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.802684 |
| 'AAAAAAAACIDAAAAA','Millions might answer. Attractive rules might beat coloured volunteers. Scottis','Books','entertainments',3.51,4097.70,6.290221 |
| '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.942159 |
| 'AAAAAAAADGKAAAAA','However small values ','Books','entertainments',1.49,3795.87,5.826893 |
| ---- TYPES |
| STRING, STRING, STRING, STRING, DECIMAL, DECIMAL, DECIMAL |
| ==== |