需求:计算湿地面积,各种类型湿地数量
SELECT
CAST(
sum( area )/ 10000 AS DECIMAL ( 10, 2 )) AS area,
sum( CASE WHEN type = 2 THEN 1 ELSE 0 END ) AS wetlandPark,
sum( CASE WHEN type = 1 THEN 1 ELSE 0 END ) AS importWetland
FROM
`bio_wetland`
WHERE
is_deleted = 0