Question

我在此问:

WITH Ase AS 
(
    SELECT CAST(AVG(percent_water AS w) AS DECIMAL(10,2))
    FROM dbo.countries
)
SELECT un_continential_region, un_subregion, Ase
FROM dbo.countries
WHERE percent_water > 0
GROUP BY un_continential_region, un_subregion
ORDER BY Ase DESC;

我正在发现的错误是

AVG不是公认的固定功能名称

问题在于,我要把水平均百分比作为ci,然后按不连续的-区域以及非次区域分类。

在什么地方我错了?

Answer 1

您不需要一种计算方法,而只是要在选定条款中进行想要的计算:

SELECT
      un_continential_region
    , un_subregion
    , CAST(AVG(percent_water) AS DECIMAL(10,2)) AS Ase
FROM dbo.countries
WHERE percent_water > 0
GROUP BY
      un_continential_region
    , un_subregion
ORDER BY
      Ase DESC;

Also note AVG(percent_water AS w) isn t valid the "as w" does not belong inside those parentheses. Also, it may be that you wanted to force the data into a decimal before averaging, in that case then use:

    , AVG(CAST(percent_water AS DECIMAL(10,2))) AS Ase

友情链接