Complete the following exercise:

Before you start developing your SQL$,$ review the following video: Week $11$ Helpful SQL Homework Video.

Using a subquery, select student first name where the student is in the student course table.

Using a subquery, select the students that have not taken any courses.

Using a subquery, select all students that have a GPA less than the student with the maximum GPA. Example, if the maximum GPA is $3\mathrm{.}4$ you would return all students with a GPA that is less than $3\mathrm{.}4.$

Using a subquery, select all students that have a GPA less than the top two students GPAs. Example, if the top two GPAs are $3\mathrm{.}4$ and $3\mathrm{.}2$ then return all students that have GPAs less than $3\mathrm{.}2.$

Once you have completed your assignment, copy and paste the script into a Word document and submit it to the link above