Serial number, cno course sno students student number; How to find out students' course selection rate

CodePudding user response:

The SELECT cno,
COUNT (1)/(SELECT COUNT (1) the FROM table) AS elective rate
FROM table
GROUP BY cno;