For our class project, we will be using the exercises from our SQL Joins and Subqueries topics. Please share your queries that you have created on the following questions below:

Get the last name, first name, classroom id, and grades of the students
Get the last name, first name, classroom name, and grades of the students
Get the first name, last name, average of all grades of each student
What is the average score of Donald Duck?
Which class of Mickey Mouse has the highest grade? (Give the class name)
Get the average score for each class (show the class name and average score)
Get the last name, first name, Class Name and weighted grade (weight * grade) of each student
What is the final grade of Donald Duck?
- To compute the final grade, sum all the weight * grade of each class
- Example: (Class #1 Weight * Class #1 Grade) + (Class #2 Weight * Class #2 Grade) and so on
What is the final grade of all of the students? Show FirstName, LastName and the Final Grade
Get the Average grade of each student for the Running and Acting classes. Show FirstName, LastName, and Average Grade of the 2 classes

What we want to see is the diversity of SQL solutions as each person has their own unique way of solving the problems. With this, we can learn on different approaches from each other and give constructive feedback as well on how we can improve our SQL queries. Good luck!

Eric Sagel

--

1