Write the SQL statement to find all students (first name, last name, phone, registration month and year) who are not currently enrolled. (This must be done using a JOIN and not a subquery).

Write the SQL query that returns the number of students receiving a particular final grade by section. Only include those sections with at least 5 students with that grade. The output will contain two columns (Number of Students and Grade).

Write the SQL statement to display vendor details (vendor name and total balance owed) whose IDs are within the range 300 and 400 (inclusively) and balance owed is more than 1000. The output should contain the vendor name, total balance owed and the number of invoices.

STUDENT ENROLLMENT STUDENT STUDENT PF STUDENT ID PF SECTION ID NUMBER (8) NUMBER (8) PSTUDENT ID NUMBER (8) VARCHAR2 (5 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (50 BYTE VARCHAR2 (5 BYTE) VARCHAR2 (15 BYTE) VARCHAR2 (50 BYTE SALUTATION FIRST_NAME ENROLL DATE DATE FINAL_GRADE CREATED BY CREATED_DATE DATE MODIFIED_BY MODIFIED DATE DATE NUMBER (3) VARCHAR2 (30 BYTE) LAST_NAME STREETADDRESS F ZIP VARCHAR2 (30 BYTE) PHONE EMPLOYER REGISTRATION DATE DATE CREATED_BY CREATED_DATE MODIFIED_BY MODIFIED DATE ENR_PK (STUDENT ID, SECTION ID) VARCHAR2 (30 BYTE DATE VARCHAR2 (30 BYTE DATE ENR_SECT_FK (SECTION_ID) ENR-STU-FK (STUDENT-ID) STU_PK (STUDENT_ID)