You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-08-05 16:15:50 +03:00
19 lines
528 B
Plaintext
19 lines
528 B
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= 'MFGR#2239'
|
|
and s_region = 'EUROPE'
|
|
group by d_year, p_brand1
|
|
order by d_year, p_brand1;
|
|
sum(lo_revenue) d_year p_brand1
|
|
880724694.00 1992 MFGR#2239
|
|
663352977.00 1993 MFGR#2239
|
|
720870928.00 1994 MFGR#2239
|
|
692803702.00 1995 MFGR#2239
|
|
763065426.00 1996 MFGR#2239
|
|
714671963.00 1997 MFGR#2239
|
|
443345612.00 1998 MFGR#2239
|