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
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
Get step-by-step solutions from verified subject matter experts
