How do I write this in SQL view?

create a view called StudentListByCourse. The view should contain these columns from the following ER model and the output should be sorted by the course name:

Course name
Student name
Student age

This is what I have but im not sure if this is correct

CREATE VIEW StudentListByCourse
SELECT *
FROM student AS s
WHERE courses AS c
SORT BY c.coursename, s.studentname, s.studentage

from Recent Questions - Stack Overflow https://ift.tt/34sH5Wi
https://ift.tt/34sH6tk