select count(student_id),course_name ,student

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

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

Answer Posted / guest

select count(student_id),course_name ,student_name
from student s, course c
where s.course_id = c.course_id
group by course_id
order by student_id desc

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rank function in sql?

1070

What is pl sql code?

1106

What are the most important characteristics of pl/sql?

1226

How can I speed up sql query?

1006

What does pl sql developer do?

980

what are the join types in tsql? : Transact sql

1101

How do I view stored procedures?

1023

What is latest version of sql?

1102

Does sql full backup truncate logs?

1078

What is the use of desc in sql?

1019

Can we group by two columns in sql?

1046

Define concurrency control. : Transact sql

1236

How delete all data from table in sql?

1071

Define SQL and state the differences between SQL and other conventional programming Languages?

1265

Can you have more than one trigger on a table?

1046