Practicle Guide to Using SQL in Oracle. Chapter 5 exercises.

Develop and execute a query to find the names of students who had HERMANO as an instructor and earned a grade of B or better in the class.

Develop the query by first finding sections where HERMANO was the instructor.

Save this query, then recall (EDIT) it and modify the query to join the sctn table with the grdrpt table.

Then add the grade constraint. Save this query (with the REPLACE option).

Then, recall it and go from there. Show all the steps of your output.

Use the tables from the student data ta

stdnt

stno NOT NULL NUMBER (3)

PRIMARY KEY NOT NULL

sname VARCHAR2(20)

major CHAR(4)

class NUMBER(1)

bdate DATE

grdrpt

student_number NOT NULL NUMBER(3)

section_id NOT NULL NUMBER(6)

grade CHAR(1)

PRIMARY KEY (student_number, section_id)

sctn

section_id NOT NULL NUMBER(6)

PRIMARY KEY NOT NULL

course_num CHAR(8)

semester VARCHAR2(6)

year CHAR(2)

instructor CHAR(10)

bldg. NUMBER(3)

room NUMBER(3)

dptmaj

dcode NOT NULL CHAR(4)

PRIMARY KEY NOT NULL

dname CHAR(20)

crs

course_name CHAR(20)

course_number NOT NULL CHAR(8)

PRIMARY KEY NOT NULL

credit_hours NUMBER(2)

offering_dept CHAR(4)

rm

bldg NOT NULL NUMBER(3)

room NOT NULL NUMBER(3)

capacity NUMBER(4)

ohead CHAR(1)

PRIMARY KEY (bldg., room)

preq

course_number CHAR(8)

prereq CHAR(8)

PRIMARY KEY (course_number,prereq)

ble below: