These statements are not working in Oracle SQL Developer mySQL

Write $10$ SQL statements against the STUDENT schema. Your statements should run error$-$free and should be valid. Submit two separate files: one plain text file $(.$txt or $.$sql file$)$ with your statements only $($non$-$code should be properly commented$)$; and the other document $($doc$/$docx$/$pdf$)$ include both your statements and your query results $($copy and paste text or screen shots$).$ The instructor should be able to run your plain text source file as script and generate the same output as shown in your result document.

Q$1.$ Show all students who has a registration date of $1/25/2007.$ Display salutation, first name inital, and full last name in all upper cases in one column labeld "Student List". $($HINT: use functions such as UPPER and SUBSTR$)$

Sample Result:

Student List

Mr$.$ R SHI

Ms$.$ H LOPEZ

Q$2.$ Display the number of students who live on the $40$th St in Brooklyn, NY$.($HINT: use the COUNT function and join table STUDENT with ZIPCODE$)$

Q$3.$ Show section information for all Programming related courses $($description has "Programming"$),$ excluding "Intro to Programming" or any Java related programming courses. Dispaly Course$\_$No$,$ course description, Section$\_$No$,$ section location, and section capacity. If a course has no section, then display $"$N$/$A$"$ for section location and leave other section related columns blank. $($HINT: left join COURSE and SECTION; use the NVL function$)$

Q$4.$ Show the address information for all Flushing, NY students who live in an apartment $($if address contains $"$#$").$ Display student first name, last name, street information $($number and street name$),$ and apartment number. $($HINT: use string functions such as SUBSTR and INSTR$)$

Sample Result:

FIRST$\_$NAME LAST$\_$NAME STREET$\_$INFORMATION APARTMENT$\_$NUMBER

Mary Axch $144-7041$st Ave. #$4$T

Q$5.$ For sections offered for Intro To Programming, calculate and display number of sections offered, total capacity, lowest capacity, highest capacity, and average capacity. $($HINT: use functions such as COUNT, SUM, MIN, MAX, and AVG$)$

Q$6.$ List all course sections that have a start date on or after $6/1/1999$ and have not been enrolled by any student. Display section ID$,$ course No$,$ start$\_$date$\_$time. $($HINT: use left join and TO$\_$DATE function$)$

Q$7.$ For all Programming related course sections taught by Anita Morris, calculate and list total number of sections and total capacity. $($HINT: join INSTRUCTOR, SECTION, and COURSE$)$

Q$8.$ List all students who took a course from Anita Morris and who enrolled $90$ days or more before section start date. Display student first name, last name, enroll date, section start date, and instructor phone number. $($HINT: join STUDENT, ENROLLMENT, SECTION, and INSTRUCTOR; use section.start$\_$date$\_$time $-$ enrollment.enroll$\_$date to calculate number of days in between$)$

q$9.$ For all sections taught by Anita Morris, calculate the average of the Final grade $($HINT: join INSTRUCTOR, SECTION, ENROLLMENT, and GRADE; use FI as grade$\_$type$\_$code$)$

q$10.$ Find any student$/$instructor pairs so that the student has taken a course taught by the instructor and they live in the same zipcode. Display student first and last name, instructor first and last name, and their zipcode