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

what are null values? : Sql dba

951

What is sql catalog?

1018

What is secondary key?

933

How do I write a cron which will run a sql query and mail the results to agroup?

974

Why should I use postgresql?

1013

What are the parameter modes supported by pl/sql?

1108

Explain cursor types?

1022

What is the best sql course?

983

What if we write return in procedure?

1427

What is data modelling in sql?

1017

Can a table contain multiple foreign key’s?

995

explain what is mysql? : Sql dba

1080

How do I save a stored procedure?

1008

Is sql dba a good career? : SQL DBA

991

What are the types of keys?

996