Question: write a sql statement to retrieve the ID and full name of all students who got a grade of B in the class cs101 PK

write a sql statement to retrieve the ID and full name of all students who got a grade of "B" in the class "cs101"
 write a sql statement to retrieve the ID and full name

PK STUDENT_ID FIRST_NAME LAST_NAME MIDDLE_INITIAL STREET_1 STREET_2 CITY POSTAL_CODE STUDENTS BIGINT VARCHAR(50) VARCHAR(50) CHAR(1) VARCHAR(50) VARCHAR(50) VARCHAR(30) VARCHAR(10) NOT NULL NOT NULL NOT NULL NULL NOT NULL NULL NOT NULL NOT NULL PK CLASS_ID CLASS_CODE CLASS_NAME CLASSES BIGINT VARCHAR(5) VARCHAR(50) NOT NULL NOT NULL NOT NULL FK CLASS_GRADES PK CLASS_GRADES_ID BIGINT CLASSID BIGINT FK STUDENT ID BIGINT FK INSTRUCTOR_ID BIGINT GRADE VARCHAR(50) NOT NULL NOT NULL NOT NULL NOT NULL NULL INSTRUCTORS INSTRUCTOR ID BIGINT FIRST_NAME VARCHAR(50) MIDDLE INITIAL CHAR(1) LAST_NAME VARCHAR(50) NOT NULL NOT NULL NOT NULL NOT NULL to the date

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!