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
20600 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 a ddl command?

1083

What does plv msg allows you to do?

1138

What is oracle sql developer?

1043

Explain the difference between rename and alias?

1010

What is sql in oracle?

1060

What is difference between left and right outer join?

983

What is an exception in PL/SQL? What are the two types of exceptions?

1309

How do I truncate a sql log file?

1069

What are sql data types?

1020

How is data stored in sql?

1058

Explain what is sql?

1111

What is crud sql?

977

What are the types of records?

988

What are the two types of periodical indexes?

936

Is pl sql and postgresql same?

1123