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

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 / monalisa.dalbehera

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

Answer Posted / monalisa.dalbehera

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

Is This Answer Correct ?

48 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you know that statistics should be updated?

1025

What is sql injection vulnerability?

870

What is difference between procedure and trigger?

915

Can we connect to postgresql using sql developer?

935

How to start oracle sql developer?

984

How to pronounce postgresql?

1006

Is sql an operating system?

961

What is Histogram?

1504

How to convert comma separated string to array in pl/sql?

1111

How do I enable sql encryption?

966

What is sql profiler in oracle?

1013

Why is sharding used?

940

What is a ddl command?

1006

How global cursor can be declare with dynamic trigger ?

2146

what are set operators in sql? : Sql dba

983