select c.course_id, count(s.student_id) from student s, course c where s

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 / iamanocp

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

Answer Posted / iamanocp

select c.course_id, count(s.student_id)
from student s, course c
where s.course_id = c.course_id
group by c.course_id;

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by <> in sql?

895

Is sql open source?

917

Is pl sql and postgresql same?

1058

Why is the cursor important?

979

What are instead of triggers?

997

Does sap use sql?

933

what is unique key constraint? : Sql dba

993

What is clustered index in sql?

1003

Explain the the update statement in sql?

990

What is out parameter used for eventhough return statement can also be used in pl/sql?

1016

Why is pl sql used?

938

How delete all data from table in sql?

951

Explain mutating table error.

1131

how to run 'mysql' commands from a batch file? : Sql dba

1063

What is a database? Explain

1053