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.

2.

- List the first and last names of the students who have enrolled in the fewest Sophomore (200 level) classes. Order by last name of the student

- List the course number and course description of the courses with the highest number of enrolled students. Arrange the list on course description.

- List the names of the students who are taking a course that begins at 10:30 AM. Sort by last name.

- List the first and last names of students are in trouble of failing section 87 because they received a score on the final exam that was below the average of the rest of the class for that final exam. Order the list by last name

- Provide an alphabetic list containing the full names of students (order by last name) and phone number who have taken at least one of the database courses. (Intro to SQL, Oracle Tools, PL/SQL Programming, Database Design, Database System Principles, DB Programming with Java). Your query must call the class by the description.

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