Having trouble with this sql question (bunch of separate queries not just one in the question). I have attached the schema Diagram below. Thanks in advance.

Using Oracle SQL create the commands to generate the different parts of this question.

1.

- List the names of instructors who have not used projects (PJ) as a basis for grading in their courses. Arrange by last name.

- Determine the number of students who received a below average grade on the final exam (FI) in section 86.

- List the city and state that have the highest number of students enrolled.

- Provide the student_id, name and final exam grade of the student(s) that received the lowest score on the final exam (FI) in course section 81.

- List the student id and name of students who have taken the same course more than once. Arrange by last name then first name.

GRADE CONVERSION GRADE TYPE LETTER GRA DE (PK) VARCHAR2(2) NOT NULL GRADE PONT MAX GRA DE MN GRADE CREATED BY CREATED DATE DATE MODIFED BY MODIFED DATE DATE NOT NULL VARCHAR2(50) NOT NULL VARCHAR2(30) NOT NULL NOT NULL VARCHAR2 (30) NOT NULL NOT NULL GRADE TYPE CODE (PK) CHAR(2) NUMBER(3,2 NOT NULL NUMBER(3,0) NOT NULL NUMBER(3,0) NOT NULL VARCHAR2(30) NOT NULL NOT NULL VARCHAR2(30) NOT NULL NOT NULL CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE DATE DATE GRTW_GRTYP FK GRADE STUDENT ID (PK)(FK) SECTION ID (PK) (FK) GRADE TYPE CODE (PK)(FK) CHAR(2) GRADE CODE OCCURRENCE (PK) NUMBER(38,0) NOT NULL NUMERIC GRADE GRADETYPE WEIGHT - NUMBER(8,0) NOT NULL NUMBER(8,0 NOT NULL NUMBER(8,0 NOT NULL NOT NULL NUMBER(3,0 NOT NULL NOT NULL NOT NULL VARCHAR2(30) NOTNULL NOT NULL VARCHAR2 (30) NOT NULL NOT NULL GRADE TYPE CODE (PK)(FK) CHAR(2) NUMBER PER SECTION NOT NULL GR GRTW FK PERCENT OF FINAL_GRADE NUMBER(3,0) 3 NUMBER(3,0) NOT NULL VARCHAR2(2000) NULL VARCHAR2(30) NOT NULL DATE VARCHAR2(30) NOT NULL DATE DROP LOWEST CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE CHAR(1) DATE DATE CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE 3 NOT NULL NOT NULL GRTW SECT FK GR ENR FK GRADE CONVERSION GRADE TYPE LETTER GRA DE (PK) VARCHAR2(2) NOT NULL GRADE PONT MAX GRA DE MN GRADE CREATED BY CREATED DATE DATE MODIFED BY MODIFED DATE DATE NOT NULL VARCHAR2(50) NOT NULL VARCHAR2(30) NOT NULL NOT NULL VARCHAR2 (30) NOT NULL NOT NULL GRADE TYPE CODE (PK) CHAR(2) NUMBER(3,2 NOT NULL NUMBER(3,0) NOT NULL NUMBER(3,0) NOT NULL VARCHAR2(30) NOT NULL NOT NULL VARCHAR2(30) NOT NULL NOT NULL CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE DATE DATE GRTW_GRTYP FK GRADE STUDENT ID (PK)(FK) SECTION ID (PK) (FK) GRADE TYPE CODE (PK)(FK) CHAR(2) GRADE CODE OCCURRENCE (PK) NUMBER(38,0) NOT NULL NUMERIC GRADE GRADETYPE WEIGHT - NUMBER(8,0) NOT NULL NUMBER(8,0 NOT NULL NUMBER(8,0 NOT NULL NOT NULL NUMBER(3,0 NOT NULL NOT NULL NOT NULL VARCHAR2(30) NOTNULL NOT NULL VARCHAR2 (30) NOT NULL NOT NULL GRADE TYPE CODE (PK)(FK) CHAR(2) NUMBER PER SECTION NOT NULL GR GRTW FK PERCENT OF FINAL_GRADE NUMBER(3,0) 3 NUMBER(3,0) NOT NULL VARCHAR2(2000) NULL VARCHAR2(30) NOT NULL DATE VARCHAR2(30) NOT NULL DATE DROP LOWEST CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE CHAR(1) DATE DATE CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE 3 NOT NULL NOT NULL GRTW SECT FK GR ENR FK