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
20634 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

Which software is used for pl sql programming?

986

Does oracle use sql?

926

what is foreign key? : Sql dba

1048

Why having clause is used in sql?

978

What type of database is cloud sql?

1101

what is the command used to fetch first 5 characters of the string? : Sql dba

1638

What is update query?

980

What is a parameter query?

1083

What is nvl?

1065

What is a schema? How is it useful in sql servers?

1120

Why are indexes and views important to an organization?

956

What are the advantages of pl sql over sql?

1025

How to set up sql*plus output format in oracle?

1037

What is difference between stored function and application function?

1200

What is the usage of nvl function?

1040