1.SELECT Students.LastName, Students.FirstName, StudentEnrollments.ClassroomId, StudentEnrollments.Grade
FROM Students
JOIN StudentEnrollments ON Students.StudentId = StudentEnrollments.StudentId;

2.SELECT Students.LastName, Students.FirstName, Classrooms.ClassName, StudentEnrollments.Grade
FROM Students
JOIN StudentEnrollments ON Students.StudentId = StudentEnrollments.StudentId
JOIN Classrooms ON StudentEnrollments.ClassroomId = Classrooms.ClassroomId;
3.SELECT Students.FirstName, Students.LastName, AVG(StudentEnrollments.Grade) AS AverageGrade
FROM Students
JOIN StudentEnrollments ON Students.StudentId = StudentEnrollments.StudentId
GROUP BY Students.FirstName, Students.LastName;
4.SELECT AVG(StudentEnrollments.Grade) AS AverageGrade
FROM Students
JOIN StudentEnrollments ON Students.StudentId = StudentEnrollments.StudentId
WHERE Students.FirstName = 'Donald' AND Students.LastName = 'Duck';
5.SELECT Classrooms.ClassName
FROM Students
JOIN StudentEnrollments ON Students.StudentId = StudentEnrollments.StudentId
JOIN Classrooms ON StudentEnrollments.ClassroomId = Classrooms.ClassroomId
WHERE Students.FirstName = 'Mickey' AND Students.LastName = 'Mouse'
GROUP BY Classrooms.ClassName
ORDER BY AVG(StudentEnrollments.Grade) DESC
LIMIT 1;
6.SELECT Classrooms.ClassName, AVG(StudentEnrollments.Grade) AS AverageGrade
FROM Classrooms
JOIN StudentEnrollments ON Classrooms.ClassroomId = StudentEnrollments.ClassroomId
GROUP BY Classrooms.ClassName;
7.SELECT Students.LastName, Students.FirstName, Classrooms.ClassName, (Classrooms.Weight * StudentEnrollments.Grade) AS WeightedGrade
FROM Students
JOIN StudentEnrollments ON Students.StudentId = StudentEnrollments.StudentId
JOIN Classrooms ON StudentEnrollments.ClassroomId = Classrooms.ClassroomId;
8.SELECT SUM(Classrooms.Weight * StudentEnrollments.Grade) AS FinalGrade
FROM Students
JOIN StudentEnrollments ON Students.StudentId = StudentEnrollments.StudentId
JOIN Classrooms ON StudentEnrollments.ClassroomId = Classrooms.ClassroomId
WHERE Students.FirstName = 'Donald' AND Students.LastName = 'Duck';
9.SELECT Students.FirstName, Students.LastName, SUM(Classrooms.Weight * StudentEnrollments.Grade) AS FinalGrade
FROM Students
JOIN StudentEnrollments ON Students.StudentId = StudentEnrollments.StudentId
JOIN Classrooms ON StudentEnrollments.ClassroomId = Classrooms.ClassroomId
GROUP BY Students.FirstName, Students