SELECT ps$.$first$\_$name $||\text{'}\text{'}||$ ps$.$last$\_$name AS student, cs$.$grade,

pt$.$first$\_$name $||\text{'}\text{'}||$ pt$.$last$\_$name AS teacher,

s$.$subject, c$.$semester, c$.$year

FROM people ps

JOIN students s ON ps$.$person$\_$id $=$ s$.$person$\_$id

JOIN classroom$\_$students cs ON s$.$student$\_$id $=$ cs$.$student$\_$id

JOIN classrooms c ON c$.$classroom$\_$id $=$ cs$.$classroom$\_$id

JOIN subjects s ON s$.$subject$\_$id $=$ c$.$subject$\_$id

JOIN teachers t ON t$.$teacher$\_$id $=$ c$.$teacher$\_$id

JOIN people pt ON pt$.$person$\_$id $=$ t$.$person$\_$id;

$(3\%)$ Using the view you just created, write a query that outputs all the students in Megan Gray's spring, $2021$ Science class. It should include the student's name and grade and should be ordered so that the students with the highest grades show up first.

$(5\%)$ Write a query that gets the full name of the teacher who teaches Science at Fayetteville$-$Manlius School in the spring of $2021.$