city, and state. Display "N/A" for zip, city, and state if an instructor does not havea zipcode. (HINT: left join INSTRUCTOR and ZIPCODE; use NVL function)Q4. Show the number of instructors who live in NY state and has a street numberof 518. (HINT: use string functions such as SUBSTR and INSTR)Q5. Display the lowest, highest, and average numeric grade of Project grade type. (HINT: use the MIN, MAX, and AVG function; join GRADE and GRADE_TYPE)-- LEFT JOIN, DATEQ6. List all students (display student_id, first name, last name, and registration date) who registered on or before 2/15/2007 but have not enrolled in any course.(HINT: left outer join STUDENT and ENROLLMENT; use the TO_DATE function)-- COUNT WITH 3-TABLE JOINQ7. Find how many students are enrolled in sections taught by Todd Smythe. (HINT: join INSTRUCTOR, SECTION, and ENROLLMENT)-- 4-TABLE JOINQ8. Show all students who are taking, or have taken the course "Advanced Java Programming course". List student name, enrollment date, and section location.