Newbie SQL Working on a project for class

Hi there I am working on some class work I am trying to figure it out but having some issues here is the code i have been working on.
//
/
/
Date created: March 15, 2020 /
/
Last updated: March 17, 2020 /
/
Done by : /
/
Purpose:Learning to create and use database
/
/
*/

/* Dropping and Creating Tables with constraints */

DROP TABLE STUDENT;

CREATE TABLE STUDENT
( Student_ID NUMBER(5) PRIMARY KEY
, F_Name VARCHAR2(30)
, L_Name VARCHAR2(30)
, HomePhone_Number NUMBER(10)
, Home_Address VARCHAR2(35)
, City VARCHAR2(35)
, State VARCHAR2(2)
, Zip_Code NUMBER(5)
, Office_Number NUMBER(3)
, Office_Phone NUMBER(10)
, Spouse_FName VARCHAR2(25)
, Spouse_LName VARCHAR2(25)
, ThesisAdvisor_ID NUMBER(5)
, Date_Enrolled DATE
, Academic_Advisor_ID NUMBER(5)
);

DROP TABLE THESIS;

CREATE TABLE THESIS
( StudentThesis_ID NUMBER(5) PRIMARY KEY
, Student_ID NUMBER(5)
, Thesis_Title VARCHAR2(75)
);

DROP TABLE FACULTY;

CREATE TABLE FACULTY
( Faculty_ID NUMBER(5) PRIMARY KEY
, F_Name VARCHAR2(30)
, L_Name VARCHAR2(30)
, OfficePhone_Number NUMBER(10)
, Office_Number NUMBER(3)
);

DROP TABLE THESIS_COMMITTEE;

CREATE TABLE THESIS_COMMITTEE
( CommitteeMember_ID NUMBER(5) PRIMARY KEY
, StudentThesis_ID NUMBER(5)
, Faculty_ID NUMBER(5)
, Chair VARCHAR(3)
);

DROP TABLE ENROLLMENT;

CREATE TABLE ENROLLMENT
( Course_ID NUMBER(5)
, Student_ID NUMBER(5)
, Enrollment_Status VARCHAR2(30)
, CONSTRAINT enrollment_pk PRIMARY KEY (Course_ID,Student_ID)
);

DROP TABLE COURSE;

CREATE TABLE COURSE
( Course_ID NUMBER(5) PRIMARY KEY
, Course_Name VARCHAR2(30)
, Professor_Name_First VARCHAR2(30)
, Professor_Name_Last VARCHAR2(30)
, Prerequisite NUMBER(5)
, CONSTRAINT Course_Prereq_fk FOREIGN KEY (Prerequisite) REFERENCES course (Course_ID)
);

/* Inserting values into Student Table*/

INSERT INTO STUDENT VALUES
(99900,‘Emily’,‘Bronte’,9542403843,‘742 Evergreen Terrace’,‘Springfield’,‘IL’,34567,117,2144657894,‘Charlie’,‘Bronte’,11111,‘13-NOV-14’,11117);

INSERT INTO STUDENT VALUES
(99901,‘Alice’,‘Walker’,5481354795,‘3584 NW 29th St’,‘Mason’,‘FL’,17465,118,2413547854,‘Joe’,‘Walker’,11112,‘13-MAY-14’,11118);

INSERT INTO STUDENT VALUES
(99902,‘Kurt’,‘Vonnegut’,5481354796,‘14 Blanchfield’,‘Summer’,‘FL’,12444,119,2413547857,‘Jen’,‘Vonnegut’,11113,‘13-APR-14’,11119);

INSERT INTO STUDENT VALUES
(99903,‘Isaac’,‘Asimov’,5481354743,‘6754 N Riva Ridge Loop’,‘Evans Mills’,‘NY’,13602,120,2413547009,‘Lisa’,‘Asimov’,11114,‘13-FEB-13’,11120);

INSERT INTO STUDENT VALUES
(99904,‘Thomas’,‘Elliot’,5481354799,‘6754 W Riva Ridge Loop’,‘Evans Mills’,‘NY’,13602,121,2413546021,‘Jessica’,‘Elliot’,11115,‘19-MAR-13’,11121);

INSERT INTO STUDENT VALUES
(99905,‘Louisa’,‘Alcott’,5481357117,‘6754 S Riva Ridge Loop’,‘Evans Mills’,‘NY’,13602,122,2413547009,‘Joshua’,‘Alcott’,11116,‘13-JUN-14’,11122);

/* Inserting values into Faculty Table*/

INSERT INTO FACULTY VALUES
(11111,‘Fred’,‘Astaire’,3156540000,111);

INSERT INTO FACULTY VALUES
(11112,‘Mikhail’,‘Bary’,3156540001,112);

INSERT INTO FACULTY VALUES
(11113,‘Martha’,‘Graham’,3156540002,113);

INSERT INTO FACULTY VALUES
(11114,‘Gene’,‘Kelly’,3156540003,114);

INSERT INTO FACULTY VALUES
(11115,‘Agnes’,‘Mille’,3156540004,115);

INSERT INTO FACULTY VALUES
(11116,‘Gaetano’,‘Vestris’,3156540005,116);

INSERT INTO FACULTY VALUES
(11117,‘Rudolf’,‘Nureyev’,3156540006,117);

INSERT INTO FACULTY VALUES
(11118,‘Jerome’,‘Robbins’,3156540007,118);

INSERT INTO FACULTY VALUES
(11119,‘Katherine’,‘Dunham’,3156540008,119);

INSERT INTO FACULTY VALUES
(11120,‘Dame’,‘Fonteyn’,3156540009,120);

INSERT INTO FACULTY VALUES
(11121,‘Hayna’,‘Holm’,3156540010,121);

INSERT INTO FACULTY VALUES
(11122,‘Kir’,‘Jooss’,3156540011,122);

INSERT INTO FACULTY VALUES
(11123,‘Alicia’,‘Alonso’,3156540012,123);

INSERT INTO FACULTY VALUES
(11124,‘Arthur’,‘Mitchel’,3156540013,124);

INSERT INTO FACULTY VALUES
(11125,‘John’,‘Combs’,3156540014,125);

INSERT INTO FACULTY VALUES
(11126,‘Rachel’,‘Barrett’,3156540015,126);

INSERT INTO FACULTY VALUES
(11127,‘Bob’,‘Atkins’,3156540016,127);

INSERT INTO FACULTY VALUES
(11128,‘Steven’,‘Coin’,3156540017,128);

INSERT INTO FACULTY VALUES
(11129,‘Andrew’,‘Richmond’,3156540018,129);

INSERT INTO FACULTY VALUES
(11130,‘Julio’,‘Ceasar’,3156540019,130);

/* Inserting values into Thesis Table*/

INSERT INTO THESIS VALUES
(55501,99900,‘Little Women’,‘No’);

INSERT INTO THESIS VALUES
(55502,99901,‘Frankenstein’,‘No’);

INSERT INTO THESIS VALUES
(55503,99902,‘Warlords’,‘No’);

INSERT INTO THESIS VALUES
(55504,99903,‘Chasing Andy’,‘No’);

INSERT INTO THESIS VALUES
(55505,99904,‘Robots’,‘No’);

INSERT INTO THESIS VALUES
(55506,99905,‘The Killing’,‘No’);

/* Inserting values into Thesis_Committee Table*/

INSERT INTO THESIS_COMMITTEE VALUES
(22200,55501,11111,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22201,55502,11112,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22202,55503,11113,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22203,55504,11114,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22204,55505,11115,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22205,55506,11116,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22206,55501,11117,‘Yes’);

INSERT INTO THESIS_COMMITTEE VALUES
(22207,55502,11118,‘Yes’);

INSERT INTO THESIS_COMMITTEE VALUES
(22208,55503,11119,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22209,55504,11120,‘Yes’);

INSERT INTO THESIS_COMMITTEE VALUES
(22210,55505,11121,‘Yes’);

INSERT INTO THESIS_COMMITTEE VALUES
(22211,55506,11122,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22212,55501,11123,‘Yes’);

INSERT INTO THESIS_COMMITTEE VALUES
(22213,55502,11124,‘Yes’);

INSERT INTO THESIS_COMMITTEE VALUES
(22214,55503,11125,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22215,55504,11126,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22216,55505,11127,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22217,55506,11128,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22218,55501,11129,‘No’);

INSERT INTO THESIS_COMMITTEE VALUES
(22219,55502,11130,‘No’);

/* Inserting values into Enrollment Table*/

INSERT INTO ENROLLMENT VALUES
(33301,99900,‘In Progress’);

INSERT INTO ENROLLMENT VALUES
(33302,99901,‘Waived’);

INSERT INTO ENROLLMENT VALUES
(33303,99902,‘In Progress’);

INSERT INTO ENROLLMENT VALUES
(33304,99903,‘Incomplete’);

INSERT INTO ENROLLMENT VALUES
(33305,99904,‘A-’);

INSERT INTO ENROLLMENT VALUES
(33306,99905,‘In progress’);

/* Inserting values into Course Table*/

INSERT INTO COURSE VALUES
(33301,‘Microeconomics’,‘Alicia’,‘Alonso’,NULL);

INSERT INTO COURSE VALUES
(33302,‘Statistics I’,‘Arthur’,‘Mitchel’,NULL);

INSERT INTO COURSE VALUES
(33303,‘International Business’,‘John’,‘Combs’,NULL);

INSERT INTO COURSE VALUES
(33304,‘Research Apprenticeship I’,‘Rachel’,‘Barrett’,NULL);

INSERT INTO COURSE VALUES
(33305,‘Statistics II’,‘Bob’,‘Atkins’,33302);

INSERT INTO COURSE VALUES
(33306,‘Research Apprenticeship II’,‘Steven’,‘Coin’,33304);

/* Adding Foreign Keys */

ALTER TABLE thesis_committee
ADD
( CONSTRAINT Thes_Commi_Faculty_ID_fk FOREIGN KEY
(faculty_id) REFERENCES faculty (faculty_id) );

ALTER TABLE thesis
ADD
( CONSTRAINT Thesis_Student_ID_fk FOREIGN KEY
(student_id) REFERENCES student (student_id) );

ALTER TABLE thesis_committee
ADD
( CONSTRAINT Thes_Commi_StudentThesis_ID_fk FOREIGN KEY
(studentthesis_id) REFERENCES thesis (studentthesis_id) );

ALTER TABLE student
ADD
( CONSTRAINT Student_ThesisAdvisor_ID_fk FOREIGN KEY
(thesisadvisor_id) REFERENCES faculty (faculty_id) );

ALTER TABLE student
ADD
( CONSTRAINT Student_Academic_Advisor_ID_fk FOREIGN KEY
(academic_advisor_id) REFERENCES faculty (faculty_id) );

ALTER TABLE enrollment
ADD
( CONSTRAINT Enroll_Course_ID_fk FOREIGN KEY
(Course_ID) REFERENCES course (Course_ID) );

ALTER TABLE enrollment
ADD
( CONSTRAINT Enroll_Student_ID_fk FOREIGN KEY
(Student_ID) REFERENCES student (Student_ID) );

/*********************************************************************************/

/* Reports */

/* Faculty: List of all Faculty Report

SELECT faculty.F_NAME AS “Faculty First Name”

FROM faculty

ORDER BY faculty.L_NAME;

*/

/* Advisors : List of all the students and their advisors

SELECT student.F_NAME AS “Student First Name”
, student.L_NAME AS “Student Last Name”
, faculty.F_NAME AS “Academic Advisor First Name”
, faculty.L_NAME AS “Academic Advisor Last Name”

FROM student

INNER JOIN faculty

ON student.ACADEMIC_ADVISOR_ID=faculty.FACULTY_ID

ORDER BY student.L_NAME;

*/

/* Student status: List of all students and their enrollment status

SELECT student.F_NAME AS “First Name”
, student.L_NAME AS “Last Name”
, enrollment.ENROLLMENT_STATUS AS “Enrollment Status”
, ROUND((SYSDATE-student.DATE_ENROLLED)/365) AS “Years Enrolled”
, faculty.F_NAME || ’ ’ || faculty.L_NAME “Academic Advisor”

FROM student

INNER JOIN enrollment

ON student.STUDENT_ID=enrollment.STUDENT_ID

INNER JOIN faculty

ON student.ACADEMIC_ADVISOR_ID=faculty.FACULTY_ID

ORDER BY student.DATE_ENROLLED DESC;

*/

/* Course Enrollment for Selected Term

SELECT enrollment.COURSE_ID || ’ '|| course.COURSE_NAME AS “Course Number/Name”
, course.PROFESSOR_NAME_LAST || ', ’ || course.PROFESSOR_NAME_FIRST AS “Professor”
, student.L_NAME || ', ’ || student.F_NAME AS “Student”

FROM enrollment

INNER JOIN course

ON course.COURSE_ID=enrollment.COURSE_ID

INNER JOIN student

ON student.STUDENT_ID=enrollment.STUDENT_ID

WHERE course.COURSE_NAME = ‘&&Enter_Course_Name’

ORDER BY enrollment.COURSE_ID
;

*/

/* Course Completion Status Report

SELECT student.L_NAME AS “Student Last Name”
, student.F_Name AS “Student First Name”
, enrollment.COURSE_ID AS “Course Number”
, course.COURSE_NAME AS “Course Name”
, enrollment.ENROLLMENT_STATUS AS “Status”

FROM student
, enrollment
, course

WHERE student.STUDENT_ID = enrollment.STUDENT_ID

AND enrollment.COURSE_ID = course.COURSE_ID

ORDER BY student.L_NAME, enrollment.COURSE_ID;

*/

/* Thesis Committee Report

SELECT student.L_NAME || ', ’ || student.F_NAME AS “Student Name”
, faculty.L_NAME || ', ’ || faculty.F_NAME AS “Committee Member Name”
, thesis_committee.CHAIR AS “Chair?”

FROM student
, faculty
, thesis_committee

WHERE faculty.FACULTY_ID = thesis_committee.FACULTY_ID

AND student.THESISADVISOR_ID = faculty.FACULTY_ID

ORDER BY student.L_NAME, faculty.L_NAME;

*/

/* Course Sequence Report

SELECT Cou1.COURSE_ID AS “Course Number”
, Cou1.COURSE_NAME AS “Course Name”
, Cou2.PREREQUISITE AS “Course Prerequisite Number”
, Cou3.COURSE_NAME AS “Course Prerequisite Name”

FROM course Cou1

LEFT JOIN course Cou2

ON Cou1.COURSE_ID = Cou2.COURSE_ID

LEFT JOIN course Cou3

ON Cou2.PREREQUISITE = Cou3.COURSE_ID

ORDER BY Cou1.COURSE_ID;

*/