牛客673031368号

分类

/ 注册

全部文章（共2篇）

题解 | #统计所有课程参加培训人次#

SELECT SUM(CAST(course_number AS UNSIGNED)) AS staff_nums FROM( SELECT CASE WHEN course LIKE'course_,course_,course_' THEN '3' WHEN course LIKE'cours...

2024-08-26

8 145

题解 | #计算25岁以上和以下的用户数量#

SELECT '25岁以下' AS age_cut , COUNT(*) AS number FROM user_profile WHERE age<25 OR age IS NULL UNION SELECT '25岁及以上' AS age_cut , COUNT(*) AS numb...

2024-08-22

0 99