COUNT计数
课程:SQL · 编程练习
SQL编程练习 - COUNT计数
练习内容
-- 统计用户总数\nSELECT COUNT(*) AS total_users FROM users;\n\n-- 统计活跃用户数\nSELECT COUNT(*) AS active_users\nFROM users WHERE status = 'active';\n\n-- 统计不同状态的用户数\nSELECT status, COUNT(*) AS count\nFROM users
课程:SQL · 编程练习
SQL编程练习 - COUNT计数
-- 统计用户总数\nSELECT COUNT(*) AS total_users FROM users;\n\n-- 统计活跃用户数\nSELECT COUNT(*) AS active_users\nFROM users WHERE status = 'active';\n\n-- 统计不同状态的用户数\nSELECT status, COUNT(*) AS count\nFROM users