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

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

Q2.1

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