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.
- 10 Answers
- 18272 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / iamanocp
select c.course_id, count(s.student_id)
from student s, course c
where s.course_id = c.course_id
group by c.course_id;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How does sql developer connect to oracle database?
Can a foreign key be a duplicate?
What is a sql profiler?
Is sql a case sensitive language?
What program will open a mdb file?
Where do we use pl sql?
Explain the rollback statement?
Can we call a function containing dml statements in a select query?
What does select count (*) mean in sql?
What is number function in sql?
What is lookup table in sql?
What are aggregate functions in sql?
Which is faster union or join?
Is sql database free?
What is error ora-12154: tns:could not resolve the connect identifier specified?
