select count(stud_name),course_name from student s,course c where s.cours

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 / lova raju allumalla

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

Answer Posted / lova raju allumalla

select count(stud_name),course_name from student s,course c
where s.course_id = c.course_id group by course_name
/

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can I join the same table twice?

1042

what is the difference between join and union? : Sql dba

1111

How much does sqlite cost?

1033

Can you inner join the same table?

988

Is postgresql a nosql database?

1154

What are the sql versions?

940

what are date and time intervals? : Sql dba

1057

How do you write a subquery?

1023

what is the command used to fetch first 5 characters of the string? : Sql dba

1635

What is oracle and pl sql?

1118

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1066

explain mysql aggregate functions. : Sql dba

984

What is the most common sql injection tool?

1040

What is a behavioral trigger?

971

What are the types of join and explain each?

1032