mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-06-10 17:41:44 +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>
40 lines
1.4 KiB
Plaintext
40 lines
1.4 KiB
Plaintext
USE ssb1;
|
|
select c_city, s_city, 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_city='UNITED KI1'
|
|
or c_city='UNITED KI5')
|
|
and (s_city='UNITED KI1'
|
|
or s_city='UNITED KI5')
|
|
and d_year >= 1992 and d_year <= 1997
|
|
group by c_city, s_city, d_year
|
|
order by d_year asc, revenue desc;
|
|
c_city s_city d_year revenue
|
|
UNITED KI5 UNITED KI1 1992 84293362.00
|
|
UNITED KI1 UNITED KI1 1992 72741495.00
|
|
UNITED KI1 UNITED KI5 1992 42449285.00
|
|
UNITED KI5 UNITED KI5 1992 15657728.00
|
|
UNITED KI1 UNITED KI1 1993 60059891.00
|
|
UNITED KI1 UNITED KI5 1993 45019842.00
|
|
UNITED KI5 UNITED KI1 1993 43557398.00
|
|
UNITED KI5 UNITED KI5 1993 14215902.00
|
|
UNITED KI1 UNITED KI1 1994 45666735.00
|
|
UNITED KI5 UNITED KI1 1994 41320177.00
|
|
UNITED KI1 UNITED KI5 1994 22983788.00
|
|
UNITED KI5 UNITED KI5 1994 17552356.00
|
|
UNITED KI1 UNITED KI5 1995 65307902.00
|
|
UNITED KI1 UNITED KI1 1995 62246006.00
|
|
UNITED KI5 UNITED KI5 1995 19844264.00
|
|
UNITED KI5 UNITED KI1 1995 19012729.00
|
|
UNITED KI1 UNITED KI1 1996 96017778.00
|
|
UNITED KI1 UNITED KI5 1996 51888711.00
|
|
UNITED KI5 UNITED KI1 1996 36318924.00
|
|
UNITED KI5 UNITED KI5 1996 25440455.00
|
|
UNITED KI1 UNITED KI1 1997 82062872.00
|
|
UNITED KI5 UNITED KI1 1997 63248422.00
|
|
UNITED KI5 UNITED KI5 1997 50277691.00
|
|
UNITED KI1 UNITED KI5 1997 32435415.00
|