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
- 18976 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / monalisa.dalbehera
select count(s.student_id),c.cource_name
from student s,course c
where c.course_id=s.course_id
group by c.course_name;
| Is This Answer Correct ? | 48 Yes | 3 No |
Post New Answer View All Answers
Explain what is an index?
what is the difference difference between procedure and packages
explain commit and rollback in mysql : sql dba
What is record variable?
What is a system versioned table?
how to concatenate two character strings? : Sql dba
What is bind reference and how can it be created?
What are analytical functions in sql?
Can you skip header records while loading? : aql loader
What does sql stand for?
Is not equal in sql?
how to drop an existing view in mysql? : Sql dba
What is clustered index in sql?
What do you mean by table in sql?
Does mysql_real_escape_string prevent sql injection?
