- #1
chrisalviola
- 80
- 0
Iam currently coding a database system for a school here, currently this is my database in MYSQL
I want to know what SQL code to use to count how many students has enrolled in every subjects in the subjects table
the new relation would appear as
idsubjects--code---desc---units--sched---NoStud
1----------cs111--------------------------10
2----------cs201--------------------------20
3----------cs202--------------------------14
I want to know what SQL code to use to count how many students has enrolled in every subjects in the subjects table
the new relation would appear as
idsubjects--code---desc---units--sched---NoStud
1----------cs111--------------------------10
2----------cs201--------------------------20
3----------cs202--------------------------14