You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-03 17:13:17 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
164 lines
5.3 KiB
Plaintext
164 lines
5.3 KiB
Plaintext
USE ssb1;
|
|
select c_nation, s_nation, d_year,
|
|
sum(lo_revenue) as revenue
|
|
from customer, supplier, dateinfo, lineorder # changed order
|
|
where lo_custkey = c_custkey
|
|
and lo_suppkey = s_suppkey
|
|
and lo_orderdate = d_datekey
|
|
and c_region = 'ASIA'
|
|
and s_region = 'ASIA'
|
|
and d_year >= 1992 and d_year <= 1997
|
|
group by c_nation, s_nation, d_year
|
|
order by d_year asc, revenue desc;
|
|
c_nation s_nation d_year revenue
|
|
CHINA CHINA 1992 5865326028.00
|
|
CHINA INDIA 1992 5836044371.00
|
|
INDONESIA INDIA 1992 5683083056.00
|
|
CHINA JAPAN 1992 5666348203.00
|
|
INDONESIA INDONESIA 1992 5581264145.00
|
|
CHINA INDONESIA 1992 5571475447.00
|
|
INDONESIA CHINA 1992 5546728973.00
|
|
JAPAN INDONESIA 1992 5543493878.00
|
|
VIETNAM INDIA 1992 5540772926.00
|
|
JAPAN INDIA 1992 5534663720.00
|
|
CHINA VIETNAM 1992 5405589911.00
|
|
VIETNAM VIETNAM 1992 5371084096.00
|
|
INDIA INDIA 1992 5323752117.00
|
|
INDONESIA VIETNAM 1992 5315384583.00
|
|
JAPAN CHINA 1992 5281441012.00
|
|
JAPAN VIETNAM 1992 5272777224.00
|
|
VIETNAM INDONESIA 1992 5264306806.00
|
|
INDIA VIETNAM 1992 5226478095.00
|
|
VIETNAM CHINA 1992 5205125647.00
|
|
INDIA INDONESIA 1992 5098586940.00
|
|
INDONESIA JAPAN 1992 4967191018.00
|
|
VIETNAM JAPAN 1992 4966877541.00
|
|
JAPAN JAPAN 1992 4947849356.00
|
|
INDIA JAPAN 1992 4938295762.00
|
|
INDIA CHINA 1992 4844271066.00
|
|
CHINA CHINA 1993 5863753554.00
|
|
VIETNAM CHINA 1993 5777334741.00
|
|
INDONESIA INDIA 1993 5771228907.00
|
|
CHINA INDIA 1993 5724200755.00
|
|
VIETNAM INDIA 1993 5671476120.00
|
|
INDONESIA INDONESIA 1993 5616525931.00
|
|
VIETNAM VIETNAM 1993 5533490227.00
|
|
INDONESIA CHINA 1993 5492294437.00
|
|
INDIA INDONESIA 1993 5474417580.00
|
|
CHINA VIETNAM 1993 5438780979.00
|
|
INDIA INDIA 1993 5435588775.00
|
|
CHINA INDONESIA 1993 5417257893.00
|
|
JAPAN INDIA 1993 5406825792.00
|
|
JAPAN CHINA 1993 5400618311.00
|
|
INDIA CHINA 1993 5375501546.00
|
|
VIETNAM INDONESIA 1993 5357009976.00
|
|
CHINA JAPAN 1993 5310178425.00
|
|
INDONESIA VIETNAM 1993 5266401087.00
|
|
JAPAN VIETNAM 1993 5213173470.00
|
|
INDONESIA JAPAN 1993 5195659613.00
|
|
INDIA VIETNAM 1993 5068459425.00
|
|
VIETNAM JAPAN 1993 5036454839.00
|
|
JAPAN INDONESIA 1993 5020701644.00
|
|
INDIA JAPAN 1993 4812718222.00
|
|
JAPAN JAPAN 1993 4734379983.00
|
|
CHINA INDIA 1994 6153902380.00
|
|
INDONESIA INDIA 1994 5807377881.00
|
|
CHINA INDONESIA 1994 5784009260.00
|
|
VIETNAM INDIA 1994 5754364546.00
|
|
CHINA CHINA 1994 5724449660.00
|
|
INDONESIA CHINA 1994 5672121691.00
|
|
INDONESIA VIETNAM 1994 5635804676.00
|
|
VIETNAM CHINA 1994 5560991163.00
|
|
INDONESIA INDONESIA 1994 5555626607.00
|
|
VIETNAM VIETNAM 1994 5549746165.00
|
|
JAPAN INDIA 1994 5532442193.00
|
|
VIETNAM INDONESIA 1994 5524493865.00
|
|
CHINA VIETNAM 1994 5424435371.00
|
|
INDIA INDONESIA 1994 5189648024.00
|
|
JAPAN CHINA 1994 5155984591.00
|
|
INDONESIA JAPAN 1994 5133961023.00
|
|
INDIA CHINA 1994 5110567889.00
|
|
JAPAN VIETNAM 1994 5105949148.00
|
|
JAPAN INDONESIA 1994 5105376375.00
|
|
VIETNAM JAPAN 1994 5095588238.00
|
|
INDIA INDIA 1994 5085574649.00
|
|
CHINA JAPAN 1994 5006833062.00
|
|
INDIA VIETNAM 1994 4781884170.00
|
|
JAPAN JAPAN 1994 4778248286.00
|
|
INDIA JAPAN 1994 4373161766.00
|
|
CHINA INDIA 1995 5956460131.00
|
|
CHINA INDONESIA 1995 5887840224.00
|
|
JAPAN CHINA 1995 5796866639.00
|
|
INDONESIA CHINA 1995 5765163319.00
|
|
CHINA VIETNAM 1995 5717261695.00
|
|
VIETNAM CHINA 1995 5657544031.00
|
|
CHINA CHINA 1995 5541367020.00
|
|
VIETNAM INDONESIA 1995 5531153115.00
|
|
CHINA JAPAN 1995 5518544960.00
|
|
INDONESIA INDIA 1995 5506610013.00
|
|
INDIA INDIA 1995 5502159002.00
|
|
INDONESIA VIETNAM 1995 5445328758.00
|
|
VIETNAM INDIA 1995 5413431950.00
|
|
INDONESIA INDONESIA 1995 5399888402.00
|
|
JAPAN INDONESIA 1995 5348151974.00
|
|
JAPAN INDIA 1995 5299466788.00
|
|
INDONESIA JAPAN 1995 5155833527.00
|
|
JAPAN VIETNAM 1995 5145511089.00
|
|
VIETNAM VIETNAM 1995 5135186237.00
|
|
VIETNAM JAPAN 1995 5121394995.00
|
|
INDIA INDONESIA 1995 5087747945.00
|
|
INDIA CHINA 1995 4956688228.00
|
|
INDIA JAPAN 1995 4930117340.00
|
|
JAPAN JAPAN 1995 4846394233.00
|
|
INDIA VIETNAM 1995 4775375962.00
|
|
INDONESIA INDIA 1996 6167554594.00
|
|
CHINA INDIA 1996 6015076942.00
|
|
CHINA CHINA 1996 5905106936.00
|
|
VIETNAM INDIA 1996 5876225747.00
|
|
INDONESIA CHINA 1996 5781296582.00
|
|
CHINA VIETNAM 1996 5781225646.00
|
|
INDONESIA VIETNAM 1996 5691462744.00
|
|
VIETNAM CHINA 1996 5573448091.00
|
|
JAPAN INDIA 1996 5411028669.00
|
|
CHINA INDONESIA 1996 5403502008.00
|
|
CHINA JAPAN 1996 5366361943.00
|
|
INDONESIA INDONESIA 1996 5364727507.00
|
|
VIETNAM VIETNAM 1996 5334388617.00
|
|
VIETNAM INDONESIA 1996 5290610888.00
|
|
INDIA INDONESIA 1996 5285637119.00
|
|
INDIA CHINA 1996 5257405740.00
|
|
INDONESIA JAPAN 1996 5228327841.00
|
|
VIETNAM JAPAN 1996 5189832272.00
|
|
JAPAN INDONESIA 1996 5166230020.00
|
|
JAPAN CHINA 1996 5114471604.00
|
|
INDIA INDIA 1996 5090685836.00
|
|
JAPAN VIETNAM 1996 5045284384.00
|
|
INDIA VIETNAM 1996 4930867545.00
|
|
JAPAN JAPAN 1996 4832292243.00
|
|
INDIA JAPAN 1996 4789615103.00
|
|
CHINA CHINA 1997 5681094494.00
|
|
CHINA INDIA 1997 5622818836.00
|
|
INDONESIA CHINA 1997 5556510015.00
|
|
VIETNAM INDIA 1997 5540116400.00
|
|
CHINA INDONESIA 1997 5534145605.00
|
|
INDONESIA INDIA 1997 5495317545.00
|
|
VIETNAM VIETNAM 1997 5495096222.00
|
|
INDIA INDIA 1997 5493828418.00
|
|
JAPAN INDIA 1997 5473719258.00
|
|
INDONESIA VIETNAM 1997 5455652177.00
|
|
VIETNAM CHINA 1997 5433687139.00
|
|
INDIA CHINA 1997 5352818362.00
|
|
INDONESIA INDONESIA 1997 5348307384.00
|
|
INDIA INDONESIA 1997 5258362587.00
|
|
CHINA VIETNAM 1997 5227785019.00
|
|
VIETNAM INDONESIA 1997 5220582796.00
|
|
JAPAN CHINA 1997 5186854481.00
|
|
INDONESIA JAPAN 1997 5099356527.00
|
|
JAPAN INDONESIA 1997 5086681543.00
|
|
CHINA JAPAN 1997 5070461845.00
|
|
JAPAN JAPAN 1997 5057334536.00
|
|
JAPAN VIETNAM 1997 4990708459.00
|
|
INDIA VIETNAM 1997 4889035192.00
|
|
VIETNAM JAPAN 1997 4848526481.00
|
|
INDIA JAPAN 1997 4744223416.00
|