Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Upgrading Oracle Databases Oracle Database New Features

Authors: Charles Kim, Gary Gordhamer, Sean Scott

1st Edition

B0BL12WFP6, 979-8359657501

More Books

Students also viewed these Databases questions