Question

Write a query to display the course name registered by at least two students.Sort the result based on Course name.
using sql join & subquery

Answer 1

Answer:

Explanation:

select coursename from course

inner join registration on course.courseid=registration.courseid group by coursename

having count(studid)>1

order by coursename;