Id ItemId Price PriceRating
1 100 34.5 EXPENSIVE
2 145 2.3 CHEAP
3 100 34.5 EXPENSIVE
4 100 34.5 EXPENSIVE
5 145 10 AFFORDABLE
Query
SELECT
COUNT(Id) AS ItemsCount,
SUM ( CASE WHEN PriceRating = 'Expensive'
THEN 1
ELSE 0
END
) AS ExpensiveItemsCount
FROM ItemSales
Results:
ItemsCount ExpensiveItemsCount
5 3
数据库 case例子
最新推荐文章于 2023-07-24 18:18:15 发布