| ==== |
| ---- QUERY: TPCDS-Q20 |
| select i_item_id |
| ,i_item_desc |
| ,i_category |
| ,i_class |
| ,i_current_price |
| ,sum(cs_ext_sales_price) as itemrevenue |
| ,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over |
| (partition by i_class) as revenueratio |
| from catalog_sales |
| ,item |
| ,date_dim |
| where cs_item_sk = i_item_sk |
| and i_category in ('Sports', 'Books', 'Home') |
| and cs_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,6478.75,3.22 |
| 'AAAAAAAAACKBAAAA','Clinical, inc initiatives make specially according to a activities.','Books','arts',6.92,1806.72,0.90 |
| 'AAAAAAAAAIJCAAAA','Simply small grounds use exactly effects. Services could kill especially aware, large observers. Civil, relevant years ensure regulations; clear drawings realize actors. Products employ a','Books','arts',1.76,14302.11,7.12 |
| 'AAAAAAAAAJIAAAAA','Joint, superior police would use through an restrictions. Buyers ought to contract generally in a efforts. Days cut also sure, frequent s','Books','arts',0.43,1094.80,0.54 |
| 'AAAAAAAABFHDAAAA','Little days answer in a emotions; players touch.','Books','arts',2.58,6331.08,3.15 |
| '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,2596.68,1.29 |
| 'AAAAAAAACBACAAAA','Remaining, main passengers go far sure men. ','Books','arts',4.78,700.70,0.34 |
| 'AAAAAAAACKDBAAAA','Positions can win increasingly entire units. Unions used to exclude fairly afraid fans. National fields appear also ways. Great lips print new teachers. Constant, primary deaths expect a little ','Books','arts',3.82,2828.38,1.40 |
| 'AAAAAAAACKEAAAAA','Legs appear eventually soci','Books','arts',35.27,438.70,0.21 |
| '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,6743.51,3.36 |
| 'AAAAAAAACNEDAAAA','Particularly labour stores get farmers. Hence true records see rel','Books','arts',6.89,9386.80,4.67 |
| '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,3375.52,1.68 |
| 'AAAAAAAADJFCAAAA','Significant, preliminary boys can remain lightly more pale discussion','Books','arts',2.74,3316.75,1.65 |
| '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,4567.89,2.27 |
| 'AAAAAAAAEDKDAAAA','Times live now to a sales. British years bring all financ','Books','arts',4.24,5014.90,2.49 |
| 'AAAAAAAAEGAEAAAA','Far injuries pay so various arms. Courses could go anywhere universal possibilities; talks stand since mean, colonial scho','Books','arts',9.57,17491.20,8.71 |
| 'AAAAAAAAEPDDAAAA','Services used to work most new provi','Books','arts',2.84,481.44,0.23 |
| 'AAAAAAAAEPKAAAAA','Here political studies give once at the qu','Books','arts',1.78,2562.67,1.27 |
| 'AAAAAAAAFBMBAAAA','Years light glasses. Contemporary members might detect even drawings. Private instructions ought to expect well main streets. Children will say well; usually young members ought to ensure enough. ','Books','arts',4.78,1718.83,0.85 |
| 'AAAAAAAAFCKCAAAA','Brilliant, acceptable resources might not pick as. Positive, married parties support only strongly impossible needs. Photogra','Books','arts',2.44,2958.33,1.47 |
| 'AAAAAAAAGAKAAAAA','Especially early girls glance however specific, relevant steps. Financial worlds telephone most dark gains. Warm, outdoor devices defend besides. Unions must not say narrow powers; individual ti','Books','arts',8.96,2310.78,1.15 |
| 'AAAAAAAAGFHBAAAA','Contemporary occasions provide she','Books','arts',1.75,11988.75,5.97 |
| 'AAAAAAAAGHOBAAAA','Fully existing proceedings could not tak','Books','arts',8.66,2402.76,1.19 |
| 'AAAAAAAAGOKBAAAA','Othe','Books','arts',60.94,2242.14,1.11 |
| 'AAAAAAAAHPNCAAAA','Correct, certain humans cut','Books','arts',37.98,6152.65,3.06 |
| 'AAAAAAAAIAOAAAAA','Professional circumstances could live else others. Symptoms can see very leaves. Just personal institutions used to go. Capable workers used to play then able police.','Books','arts',2.40,2219.11,1.10 |
| 'AAAAAAAAIEPCAAAA','New, popular years should think. Shareholders speak also friends; special members could not identify social eyes; indoors full ','Books','arts',0.91,5462.06,2.72 |
| 'AAAAAAAAIHKBAAAA','Very historic arms may happen even able exis','Books','arts',9.19,8280.09,4.12 |
| 'AAAAAAAAIIPDAAAA','Af','Books','arts',6.04,4695.48,2.34 |
| 'AAAAAAAAIJGAAAAA','Then western animals could teach somewhere. Today waiting servants confuse','Books','arts',4.10,1589.42,0.79 |
| 'AAAAAAAAJJDBAAAA','Problems compete with a sets. Interesting, automatic pounds tell complete hills. ','Books','arts',1.20,18501.43,9.22 |
| 'AAAAAAAAKGBAAAAA','Light moments cannot date following sy','Books','arts',5.60,9688.12,4.82 |
| 'AAAAAAAAKICDAAAA','Wet, concerned representatives get up to a owners. Necessary, like','Books','arts',1.89,10823.82,5.39 |
| 'AAAAAAAAMFFAAAAA','Communities used to relocate clearly strange, new walls; european, rich championships make current depths. Sure studies may reflect only instinctively old forces. Foreign, diverse','Books','arts',8.22,3557.07,1.77 |
| 'AAAAAAAANIBAAAAA','Beneath decent wives write t','Books','arts',2.72,2235.93,1.11 |
| 'AAAAAAAAOJJCAAAA','Troops take only, right dogs. Briefly genuine eyes used to provide mutually coming, just parents. Too social services shall feel only rec','Books','arts',6.40,2193.52,1.09 |
| '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,5632.64,2.80 |
| 'AAAAAAAAOPKCAAAA','Less imp','Books','arts',9.12,1511.60,0.75 |
| 'AAAAAAAAPIEBAAAA','Main cheeks must put ','Books','arts',0.45,13.44,0.00 |
| 'AAAAAAAAPLLDAAAA','Old eyes could not give later issues. Claims might','Books','arts',9.00,4957.73,2.47 |
| 'AAAAAAAAABMBAAAA','Situations retain; units might sit operations; girls shall make. Ca','Books','business',3.16,905.62,0.57 |
| 'AAAAAAAAACEBAAAA','Prese','Books','business',15.17,5628.92,3.58 |
| 'AAAAAAAAADFAAAAA','Satisfactory, technical shadows get. Lexical structures would not blame. Only hard ','Books','business',78.25,9249.55,5.89 |
| 'AAAAAAAAAKBDAAAA','Essential students change even despite a powers. General connections will not maximi','Books','business',3.10,1162.52,0.74 |
| 'AAAAAAAAANHCAAAA','High ministers should not remove for a stations. Certain, linear weeks might not ask so from a improvements. Lakes must not implement f','Books','business',4.80,504.32,0.32 |
| 'AAAAAAAABIPBAAAA','Ultimate, other objects might not install good ','Books','business',2.57,2399.32,1.52 |
| 'AAAAAAAABKACAAAA','Total pp. accept with a questions; able, generous a','Books','business',5.25,6380.42,4.06 |
| 'AAAAAAAACDBCAAAA','Tiny years could run too above tough volumes. New germans must not leave as possible sales; inj','Books','business',1.22,5339.66,3.40 |
| 'AAAAAAAACDIBAAAA','Small results would go colours; sexual agencies ought to assure moreover unique premises; then complex provisions use often normal windows. Better educational girls should not believe however struct','Books','business',9.78,566.04,0.36 |
| 'AAAAAAAACEACAAAA','Other, direct letters ought to make from a ways. British, large men could not work a','Books','business',0.48,9562.96,6.09 |
| 'AAAAAAAACPODAAAA','Cells stay economic, thin members. Soon special conservatives solve to the figu','Books','business',2.93,13212.32,8.41 |
| 'AAAAAAAADHNCAAAA','Originally major industries matter mediterranean bodies. Cases should not ','Books','business',45.06,303.70,0.19 |
| 'AAAAAAAADNDDAAAA','Clear, harsh police used to include large, appropriate plans. Prices could produce more. There white weapons expect directly free conclusions. Responsibl','Books','business',4.57,3220.52,2.05 |
| 'AAAAAAAAEICAAAAA','Cases include proudly without a columns. Solid, pre','Books','business',2.42,7199.25,4.58 |
| '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,1349.33,0.85 |
| '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,3655.68,2.32 |
| '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,1809.71,1.15 |
| 'AAAAAAAAGFDCAAAA','Particularly medieval blocks would not find slightly with a carers. Years respond about at a sec','Books','business',6.00,318.24,0.20 |
| 'AAAAAAAAGONBAAAA','Ever top offers might struggle far, automatic men. Long-term, long goods dare however; new, other gr','Books','business',2.30,1639.26,1.04 |
| '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,1490.85,0.94 |
| 'AAAAAAAAIINDAAAA','Frames can park highly parents. White ma','Books','business',6.97,4313.52,2.74 |
| 'AAAAAAAAIJECAAAA','Difficult, royal units put particularly significant, other plans. Essential, contemporary journals will need players. Alternatively parental','Books','business',4.34,2268.00,1.44 |
| 'AAAAAAAAIJJCAAAA','Euro','Books','business',3.01,4889.34,3.11 |
| 'AAAAAAAAIKEAAAAA','All ','Books','business',9.44,182.52,0.11 |
| 'AAAAAAAAIPADAAAA','Orders go into the documents. Social, existing specialists will seem twice associated wishes. Finally nation','Books','business',5.15,242.88,0.15 |
| 'AAAAAAAAJMEDAAAA','Personal, significant activities agree only by a couples. Elaborate aut','Books','business',3.06,85.26,0.05 |
| '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,4949.49,3.15 |
| 'AAAAAAAAKAKAAAAA','Still urban stages shall not take for a legs. Other, holy demands pay further young, positive numbers. A little criminal i','Books','business',7.68,9959.06,6.34 |
| '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,910.16,0.57 |
| '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,1816.45,1.15 |
| '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,1252.09,0.79 |
| 'AAAAAAAAMALDAAAA','Here final difficulties would not comply just legal good motives. Enough sensitive things could not spend obviously with a systems. In pu','Books','business',91.76,356.85,0.22 |
| 'AAAAAAAAMIGCAAAA','Carefully physical hotels must put together; similar details cannot appreciate by a standards. Rates can break m','Books','business',6.63,562.96,0.35 |
| '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,2889.22,1.84 |
| 'AAAAAAAAMKHAAAAA','Unions shall see enough over true attitudes; of course full variable','Books','business',8.90,15263.90,9.72 |
| '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,1069.76,0.68 |
| '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,3975.16,2.53 |
| 'AAAAAAAAPDNAAAAA','Local, unlikely bits sign completely. Areas feel only manufacturing legs. Amounts must go personal, very things; areas could take clo','Books','business',5.20,3545.37,2.25 |
| 'AAAAAAAAPEKCAAAA','Alone countries must use so old, international functions. Only public cases see in a words. Normal methods forget even communist changes; technical numbers convert either natu','Books','business',4.67,3899.62,2.48 |
| 'AAAAAAAAPGDBAAAA','Certainly remaining flowers can wonder then just significant papers; places secure below as a bombs. Other, domestic members must allow very polite thi','Books','business',0.60,12462.77,7.94 |
| 'AAAAAAAAPHJAAAAA','Possibly great customs suit close looks. Capable, frequent processes shall pass possible dangers; hard, private words act measures. Mysterious, acceptable fac','Books','business',6.64,6141.24,3.91 |
| 'AAAAAAAAAALDAAAA','Forward liable funds may not end from time to time local, domestic chiefs. Major, well-known newspapers can regain together new, white conclusions. Very vital employees can draw','Books','computers',17.54,588.01,0.31 |
| 'AAAAAAAAAHKDAAAA','Decisions play actually exclusive activities. Well assistant e','Books','computers',8.77,1619.66,0.85 |
| 'AAAAAAAAAKGDAAAA','Tonnes could use slowly off a servants. Initial letters must walk now companies; rapid, previous towns put here large, prime needs. Historical, negative grou','Books','computers',0.19,3319.10,1.75 |
| 'AAAAAAAAAOBCAAAA','Years should try in line with a conditions. Pp. spend well evenings. Other, afraid sides speculate at a years. Options ought to know leading, app','Books','computers',5.23,8468.08,4.47 |
| 'AAAAAAAABHEEAAAA','Subjects may remain officials. Forward, straight objects used to see wh','Books','computers',6.97,13658.40,7.22 |
| 'AAAAAAAABLMBAAAA','External improvements effect so tough words. Great roads cause quickly popular, black stories. Clearly white members might ask enough details. Min','Books','computers',31.74,4154.04,2.19 |
| 'AAAAAAAACHOCAAAA','Final governm','Books','computers',6.22,5102.98,2.69 |
| 'AAAAAAAACOHDAAAA','Left, important sports shall get on an specialists. Overall, e','Books','computers',3.56,14321.37,7.57 |
| 'AAAAAAAAEANCAAAA','Ye','Books','computers',9.75,1367.76,0.72 |
| '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,328.50,0.17 |
| 'AAAAAAAAEDMAAAAA','Books understand. Principles produce just at a premises. Years ','Books','computers',44.48,188.86,0.09 |
| 'AAAAAAAAFEEAAAAA','Capital, united feelings paint only things. Greatly financial economies should not pay somewhere soviet necessary armies; educational concepts mus','Books','computers',3.83,812.19,0.42 |
| 'AAAAAAAAFLFEAAAA','Social weeks may hope. However parental objects shall get just potential logical stations. Agreements attend on a arms; circa real reforms may interpret dogs. T','Books','computers',2.06,449.61,0.23 |
| 'AAAAAAAAGENAAAAA','Genera','Books','computers',2.84,950.58,0.50 |
| 'AAAAAAAAGHCBAAAA','Hundreds would meet regardless german, foreign scien','Books','computers',9.77,1969.60,1.04 |
| '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,377.26,0.19 |
| 'AAAAAAAAHPADAAAA','Used, young sizes take requirements. Electoral, standard stones worry still private scenes. Major, still bedrooms say all once effective years. Long new moments will own after the','Books','computers',9.19,690.90,0.36 |
| 'AAAAAAAAIAMAAAAA','Alone walls mus','Books','computers',2.00,4530.16,2.39 |
| 'AAAAAAAAIGCEAAAA','Concerned numbers can attempt now particular, white friends; un','Books','computers',3.38,14627.99,7.73 |
| ---- TYPES |
| STRING, STRING, STRING, STRING, DECIMAL, DECIMAL, DECIMAL |
| ==== |