Number of course Registered

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

First you show us your code, then we can help you; this is how Sololearn Q&A Discussions work. 🙂