Question
Select the entire grades table. Select all fields describing the courses offered in the College of Arts & Sciences (school code L). Select the names,
Select the entire grades table. Select all fields describing the courses offered in the College of Arts & Sciences (school code L).
Select the names, student IDs, and CSE330 grades of all students who are in CSE330S. Note: This query should involve joins. You don't need to use any aggregation functions.
Select the names, e-mails, and average grades of any student with an average below 50 so that the dean can send them an email notification that they are now on academic probation. You should be able to do this in only one query, without making any temporary tables. You will need to use aggregation functions and the HAVING keyword.
Select an individual report card for Jack Johnson, consisting of only his student ID, e-mail address, and average grade. Again, you should be able to do this in just one query, using the correct combination of aggregation functions and joins.Note: Your query must look for students with the name "Jack Johnson" instead of hard-coding the student ID.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started