List the students who have received any numeric grade score of at least 95 in an

Question

List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade type code, and the numeric grade.

tables in the database:

Name              Null     Type        

----------------- -------- ------------STUDENT TABLE

STUDENT_ID        NOT NULL NUMBER(8)   

SALUTATION                 VARCHAR2(5)

FIRST_NAME                 VARCHAR2(25)

LAST_NAME         NOT NULL VARCHAR2(25)

STREET_ADDRESS             VARCHAR2(50)

ZIP               NOT NULL VARCHAR2(5)

PHONE                      VARCHAR2(15)

EMPLOYER                   VARCHAR2(50)

REGISTRATION_DATE NOT NULL DATE        

CREATED_BY        NOT NULL VARCHAR2(30)

CREATED_DATE      NOT NULL DATE        

MODIFIED_BY       NOT NULL VARCHAR2(30)

MODIFIED_DATE     NOT NULL DATE        

Name          Null     Type        

------------- -------- ------------ENROLLMENT TABLE

STUDENT_ID    NOT NULL NUMBER(8)   

SECTION_ID    NOT NULL NUMBER(8)   

ENROLL_DATE   NOT NULL DATE        

FINAL_GRADE            NUMBER(3)   

CREATED_BY    NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE        

MODIFIED_BY   NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE        

Name            Null     Type        

--------------- -------- ------------SECTION TABLE

SECTION_ID      NOT NULL NUMBER(8)   

COURSE_NO       NOT NULL NUMBER(8)   

SECTION_NO      NOT NULL NUMBER(3)   

START_DATE_TIME          DATE        

LOCATION                 VARCHAR2(50)

INSTRUCTOR_ID   NOT NULL NUMBER(8)   

CAPACITY                 NUMBER(3)   

CREATED_BY      NOT NULL VARCHAR2(30)

CREATED_DATE    NOT NULL DATE        

MODIFIED_BY     NOT NULL VARCHAR2(30)

MODIFIED_DATE   NOT NULL DATE        

Name          Null     Type        

------------- -------- ------------COURSE TABLE

COURSE_NO     NOT NULL NUMBER(8)   

DESCRIPTION   NOT NULL VARCHAR2(50)

COST                   NUMBER(9,2)

PREREQUISITE           NUMBER(8)   

CREATED_BY    NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE        

MODIFIED_BY   NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE        

--------------------- -------- --------------GRADE TABLE

STUDENT_ID            NOT NULL NUMBER(8)     

SECTION_ID            NOT NULL NUMBER(8)     

GRADE_TYPE_CODE       NOT NULL CHAR(2)       

GRADE_CODE_OCCURRENCE NOT NULL NUMBER(38)    

NUMERIC_GRADE         NOT NULL NUMBER(3)     

COMMENTS                       VARCHAR2(2000)

CREATED_BY            NOT NULL VARCHAR2(30)  

CREATED_DATE          NOT NULL DATE          

MODIFIED_BY           NOT NULL VARCHAR2(30)  

MODIFIED_DATE         NOT NULL DATE          

Explanation / Answer

Q) List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade type code, and the numeric grade.

SELECT STUDENT_ID, FIRST_NAME ||' '|| LAST_NAME, GRADE_TYPE_CODE, NUMERIC_GRADE

FROM STUDENT JOIN ENROLLMENT ON STUDENT.STUDENT_ID = ENROLLMENT.STUDENT_ID

JOIN SECTION ON ENROLLMENT.SECTION_ID = SECTION.SECTION_ID

JOIN COURSE ON SECTION.COURSE_NO = COURSE.COURSE_NO

JOIN GRADE ON STUDENT.STUDENT_ID = GRADE.STUDENT_ID

WHERE GRADE.NUMERIC_GRADE > 95 AND COURSE.DESCRIPTION = 'Advanced Java Programming';

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

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