我是 SQL 新手,我尝试创建 CTE,但在 AS 下出现红色曲线,并且在执行语法的过程中收到错误消息:
消息 102,级别 15,状态 1,第 117 行“)”附近的语法不正确。
这是 SQL 语法,任何帮助都会很棒:
WITH CTE_Grand_Harvest_Total AS (
SELECT
zardi, COUNT(zardi) AS Count_ZARDI, SUM(Weight) AS Sum_Weight, Total_Harvest, Total_Harvest*COUNT(zardi)*SUM(Weight) AS Grand_Total
FROM
S1_PH_CROPS_clean_final_minus_money_matters
WHERE
Work.dbo.S1_PH_CROPS_clean_final_minus_money_matters.cropNamePH = 'Maize'
GROUP BY
Total_Harvest, zardi
)