The result should be: Show activity on this post. Select all courses from your course Table, join the enrolment table and group by your course id. With count () you can select the number of Students To make it working not only in mySQL I added an aggregate function to the name column.
This C program is to store and display the information of a student using structure i.e. to store and display the roll number,name,age and fees of a student using structure. Basically one should know how to write the syntax of a structure and the rest is just implementation of the programs done so far.
You need a select statement with a join to the couse table (for the Course_name ). Group by 't_course'.name to use the COUNT (*) function Thanks for contributing an answer to Stack Overflow!
C program store and display information of an employee using structure | CODEDOST C program to store and display the name, id, age and salary of an employee using structure This C program is to store and display information of an employee using structure i.e. store and display the name, id, age and salary of an employee using structure.
Information for Roll Number: 1 Enter the first name: Student-1 Enter the last name: Test-1 Enter the marks: 50
In this program, we asked the user to enter the 10 number of students to add to the student structure variable.
This C program is to store and display information of an employee using structure i.e. store and display the name, id, age and salary of an employee using structure.
Flex program to check use of unput () function This flex program is to check use …