select count(student_name),course_name from student,course where course.co

Table Student has 3 columns,Student_id,Student_Name &
Course_Id. Table Course has 2 columns, Course_Id &
Course_Name.Write a query to listdown all the Courses and
number of student in each course.

Question Posted / pradip d

10 Answers
20242 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / pradip d

select count(student_name),course_name from student,course
where course.course_id=student.course_id group by course_name;

Is This Answer Correct ?

18 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does varchar include?

905

Is sql the best database?

913

Can a view be mutating? If yes, then how?

960

What are % type and % rowtype?

978

Is mariadb nosql?

989

What is recursive stored procedure?

1045

What is partition in sql query?

946

What is percent sign in sql?

1212

Which is better stored procedure or query?

918

what is sql server agent? : Sql dba

1027

what are the 'mysql' command line arguments? : Sql dba

1087

What is execution plan in sql?

978

what are properties of a transaction? : Sql dba

1017

What is the difference between sql and isql*plus?

1007

How do I order by ascending in sql?

956