I have a following table in my Oracle database:
How can I select the course which is done by most of the students?
I am trying multiple variations in following SQL query but it's not working -
select count(course) as pcourse, course
from studies
group by course
order by pcourse dec;
Aucun commentaire:
Enregistrer un commentaire