select course_id,count(*) from student where course_id in (select course

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

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

Answer Posted / dinakar

select course_id,count(*) from student where course_id in
(select course_id From course)
GROUP BY COURSE_ID

Is This Answer Correct ?

2 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I create a sql script?

1096

What is the difference between the conventional and direct path loader? : aql loader

1152

what are the limitations of identity column? : Transact sql

1104

what is 'mysqlimport'? : Sql dba

1044

What is a design view?

920

What is the use of %rowtype?

1032

If a cursor is open, how can we find in a pl/sql block?

1163

What is sql constant?

1025

What is meaning of <> in sql?

1065

What is difference between mysql and postgresql?

1145

What are three advantages to using sql?

1008

Can we insert data in view?

955

What is a table?

1007

explain advantages of myisam over innodb? : Sql dba

1064

What is crud stand for?

996