Question

Write a query to display student ID and number of course registered by students. Display student ID only if student has registered for a course. Give alias name for the count as NOOFCOURSES. Sort the result based on count in descending and student ID ascending.

Answer 1

Answer:

Explanation:

  select Studid, count(courseid) as NOOFCOURSES from REGISTRATION  

    group by Studid

    ORDER BY NOOFCOURSES DESC, Studid asc;