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

Is primary key an index?

991

How much does a sql dba make? : SQL DBA

942

Explain the difference between 'between' & 'and' operators in sql

998

Is sqlite free?

970

is mysql query is case sensitive? : Sql dba

1100

Explain spool.

1178

what is self-join? : Sql dba

1162

What is the purpose of a sql?

977

What are the different ways to optimize a sql query?

946

what is isam? : Sql dba

1004

what is the syntax used for partition in tsql? : Transact sql

1014

What is the purpose of a secondary key?

975

What will you get by the cursor attribute sql%notfound?

1068

What are all the different types of indexes?

1147

What is sql and its types?

1185