mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +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>
69 lines
1.9 KiB
Plaintext
69 lines
1.9 KiB
Plaintext
USE ssb1;
|
|
select sum(lo_revenue), d_year, p_brand1
|
|
from part, supplier, dateinfo, lineorder # changed order
|
|
where lo_orderdate = d_datekey
|
|
and lo_partkey = p_partkey
|
|
and lo_suppkey = s_suppkey
|
|
and p_brand1 between 'MFGR#2221'
|
|
and 'MFGR#2228'
|
|
and s_region = 'ASIA'
|
|
group by d_year, p_brand1
|
|
order by d_year, p_brand1;
|
|
sum(lo_revenue) d_year p_brand1
|
|
735058274.00 1992 MFGR#2221
|
|
687393527.00 1992 MFGR#2222
|
|
715750616.00 1992 MFGR#2223
|
|
597475488.00 1992 MFGR#2224
|
|
649638844.00 1992 MFGR#2225
|
|
692588847.00 1992 MFGR#2226
|
|
582212634.00 1992 MFGR#2227
|
|
709837552.00 1992 MFGR#2228
|
|
658768732.00 1993 MFGR#2221
|
|
648149924.00 1993 MFGR#2222
|
|
672855456.00 1993 MFGR#2223
|
|
551254470.00 1993 MFGR#2224
|
|
632783667.00 1993 MFGR#2225
|
|
583815471.00 1993 MFGR#2226
|
|
668627784.00 1993 MFGR#2227
|
|
674142054.00 1993 MFGR#2228
|
|
652754136.00 1994 MFGR#2221
|
|
640405904.00 1994 MFGR#2222
|
|
670533507.00 1994 MFGR#2223
|
|
645762362.00 1994 MFGR#2224
|
|
568882128.00 1994 MFGR#2225
|
|
666982693.00 1994 MFGR#2226
|
|
690715810.00 1994 MFGR#2227
|
|
681861796.00 1994 MFGR#2228
|
|
737420920.00 1995 MFGR#2221
|
|
678158729.00 1995 MFGR#2222
|
|
603779778.00 1995 MFGR#2223
|
|
670685110.00 1995 MFGR#2224
|
|
581360183.00 1995 MFGR#2225
|
|
643158084.00 1995 MFGR#2226
|
|
552230421.00 1995 MFGR#2227
|
|
805996209.00 1995 MFGR#2228
|
|
669224031.00 1996 MFGR#2221
|
|
566473453.00 1996 MFGR#2222
|
|
684106475.00 1996 MFGR#2223
|
|
619772735.00 1996 MFGR#2224
|
|
517155379.00 1996 MFGR#2225
|
|
724647972.00 1996 MFGR#2226
|
|
674084882.00 1996 MFGR#2227
|
|
720393950.00 1996 MFGR#2228
|
|
565275008.00 1997 MFGR#2221
|
|
643440534.00 1997 MFGR#2222
|
|
701112228.00 1997 MFGR#2223
|
|
559706196.00 1997 MFGR#2224
|
|
711128429.00 1997 MFGR#2225
|
|
718138884.00 1997 MFGR#2226
|
|
721043656.00 1997 MFGR#2227
|
|
728568195.00 1997 MFGR#2228
|
|
369906728.00 1998 MFGR#2221
|
|
354590096.00 1998 MFGR#2222
|
|
373862502.00 1998 MFGR#2223
|
|
328962938.00 1998 MFGR#2224
|
|
390503576.00 1998 MFGR#2225
|
|
363691851.00 1998 MFGR#2226
|
|
318736487.00 1998 MFGR#2227
|
|
401003580.00 1998 MFGR#2228
|