- 博客(1)
- 收藏
- 关注
原创 自学SQL-Lesson11 难题4
SELECT role, count(*) AS quantity, '1' AS bn FROM employees WHERE building IS NOT NULL GROUP BY role UNION SELECT role, count(*) AS quantity, '0' AS bn FROM employees WHERE building IS NULL GROUP BY role 终于做出来了(┬_┬) ...
2021-11-09 19:40:02 526
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人