多少人选修这门课程可以用这条SQL命令来查询:SELECT Course_No, COUNT(*) AS Count_of_Students FROM Enrollments GROUP BY Course_No;
SQL命令如何查询每个课程号和相应的选课人数
最新推荐文章于 2024-02-24 21:24:32 发布
多少人选修这门课程可以用这条SQL命令来查询:SELECT Course_No, COUNT(*) AS Count_of_Students FROM Enrollments GROUP BY Course_No;