Retrieve all courses that have the letters a$,$ e$,$ i in THAT order in their names

Retrieve all courses that have the letters a$,$ e$,$ i i ANY order in their names

Retrieve the names of all students who failed a course $($grade of F$)$ along with the name of the course that they failed.

Retrieve the percentage of solid A grades compared to all courses, and rename that column "Percent$\_$A$"$

Retrieve the names and numbers of all courses that do not have prerequisites.

Retrieves the names of all students and their advisors if they have one.