SELECT COURSE_NAME,COUNT(B.STUDENT_ID) NO_OF

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

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

Answer Posted / kalyan

SELECT COURSE_NAME,COUNT(B.STUDENT_ID) NO_OF_STUDENTS
FROM COURSE A LEFT OUTER JOIN STUDENT B
USING (COURSE_ID)
GROUP BY A.COURSE_NAME

OR

SELECT COURSE_NAME,COUNT(B.STUDENT_ID) NO_OF_STUDENTS
FROM COURSE A , STUDENT B
WHERE A.COURSE_ID = B.COURSE_ID(+)
GROUP BY A.COURSE_NAME

This will list all the courses with no of students

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the purpose of design view?

952

What are the different types of constraints?

1074

Explain what is a database?

1039

how many groups of data types? : Sql dba

973

how to check server status with 'mysqladmin'? : Sql dba

1018

How do you update a value in sql?

988

How can we link a sql database to an existing android app?

983

What is left join in postgresql?

998

What is the difference between inner join and outer join?

931

How many sql commands are there?

1073

What is function and procedure in pl sql?

975

How to combine two stored procedures in sql?

1124

What is db journal file?

956

What is data control language?

949

What are the different datatypes available in PL/SQL?

1029