Using Oracle SQL created the commands used to achieve what is asked below.

Schema is below

List the full name (first and last name) and phone number for students that live in Newark, NJ. Sort on last name and first name.

For all 300 level courses (300-399), list the course number, prerequisite course number and prerequisite course description. Sort by course number.

List the course number and description for all 100-level courses taught by Charles Lowry. Arrange the list in order of course number.

List the grade type code, description and number per section (a column in the grade_type_weight table) of all grades in course 144. Arrange by description.

Provide an alphabetic list of students (student last name followed by first name) who have an overall grade average of 93 or higher. The name should be one column, last name first and sorted on last name then first name.

List the names (first name and last name) and address (including city and state) for all faculty who have taught less than 10 course sections.

List the course number and number of students enrolled in courses that dont have a prerequisite. Sort the list by number of students enrolled from highest to lowest.

Provide a distinct alphabetic list of students (first and last name and phone number) from Flushing, NY who enrolled prior to 10:20am on February 2, 2007.

Provide a listing of courses (course number and course name) that include projects as a part of their grading criteria.

List the highest grade on the final exam that was given to a student in course 145

A PPENDIX D STUDENT DATABASE SCHEMA LETTER GRADE IPO VARCHAR2 NOTNULL CREATED CATE CATE GRADE-CO E-OOCLRRENCEPON.AEEN 38es NDTN.AL GHTW SECT FK START DATEL TME CATE MOOFED DATE CATE CPEATED DATE CATE MCOFED DATE CATE REATID DATE DATI GREATED CATE DATE STUDENT DOK NUMBER NOT NULL STREET ADDRESS VARDAR250NULL CREATED By OREATEDoATEDATE CREATED DATE CATE MOOFED DATE DATE MCOFED DATE DATE A PPENDIX D STUDENT DATABASE SCHEMA LETTER GRADE IPO VARCHAR2 NOTNULL CREATED CATE CATE GRADE-CO E-OOCLRRENCEPON.AEEN 38es NDTN.AL GHTW SECT FK START DATEL TME CATE MOOFED DATE CATE CPEATED DATE CATE MCOFED DATE CATE REATID DATE DATI GREATED CATE DATE STUDENT DOK NUMBER NOT NULL STREET ADDRESS VARDAR250NULL CREATED By OREATEDoATEDATE CREATED DATE CATE MOOFED DATE DATE MCOFED DATE DATE