a simple query

i am new at thisn abd i need to write an SQL query which gets

the names and major of all straight A students that is students

with grade A in all courses from the following tables

table student: StudentID, major

table Sgrades: studentID, section , Grade

so for a student name and major to be displayed he has to

have grade A in all sections he finished


  • Select Student.Name, Student.Major

    From Student

    JOIN Sgrades On Student.StudentId = Sgrades.StudentId

    Where Sgrades.Grade = 'A'

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!