Select the entire grades table. Select all fields describing the courses offered

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, 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.

Explanation / Answer

SELECT * FROM GRADE WHERE SCHOOL_CODE="L";

SELECT A.NAMES AS NAMES, A.STUDENT_ID AS STUDENT,B.GRADES,A.SEC FROM STUDENT AS A,GRADE AS B WHERE B.GRADES="CSE330" AND A.SEC="CSE330S";

SELECT NAMES,E_MAILS,AVG(GRADE) FROM STUDENT WHERE AVG(GRADE)<50;

SELECT STUDENT_ID,E_MAIL,AVG(GRADE) FROM STUDENT WHERE NAME="JACK JOHNSON";

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.