数据仓库服务 GAUSSDB(DWS)-SSB查询测试:Q2.3

时间:2024-10-22 11:41:47

Q2.3

1
2
3
4
5
6
7
8
9
SELECT
SUM(LO_REVENUE), div(LO_ORDERDATE,10000) AS YEAR,
P_BRAND
FROM lineorder_flat
WHERE
P_BRAND = 'MFGR#2239'
AND S_REGION = 'EUROPE'
GROUP BY YEAR, P_BRAND
ORDER BY YEAR, P_BRAND;
support.huaweicloud.com/pwp-910-dws/dws_13_00031.html