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.
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
Why do we use joins in sql?
Explain the difference between rename and alias?
How do you create a unique index?
What are sql queries used for?
In pl/sql, what is bulk binding, and when/how would it help performance?
explain access control lists. : Sql dba
Why cross join is used?
Why function is used in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
How many types of indexes are there in sql?
what is union, minus and interact commands? : Sql dba
How can I speed up sql query?
How do you change a value in sql?
What is view explain with example?
How do you modify a column in sql?