Answer Happy

Write a statement that displays student ID, the first and lastname, and enrollment date and time of enrollment of the studentsthat was the first to enroll. List each student only once. Sort thelist by student ID
STUDENT_ID FIRST_NAME LAST_NAME DATEENROLLED ---------- ------------------------- ------------------------------------------------------ 102 Fred Crocitto Jan 30 200710:18 AM
*****
DESCRIPTION COST CAPACITY SECTION_NO SECTION_ID-------------------------------------------------- -------------------- ---------- ----------Intro to the BASIC Language 1095 10 1 101Intro to the Internet 1095 12 1 99Intro to the Internet 1095 15 2 100Intro to the BASIC Language 1095 15 2 102Unix Tips and Techniques 1095 15 2 113Unix Tips and Techniques 1095 15 4 115
6 rows selected.
*****
COURSE_NODESCRIPTION TOTAL_CAPACITY
---------- ----------------------------------------------------------------
144 DatabaseDesign 15
10 TechnologyConcepts 15
****
STUDENT_IDFIRST_NAME LAST_NAME MOST_SECTIONS
---------- ------------------------- -------------------------------------
124Daniel Wicelinski 4
214Yvonne Williams 4
*****
FIRST_NAME LAST_NAME ZIP ------------------------- ------------------------- -----Jeffrey Citron 07024Jeffrey Delbrun 07024Julius Kwong 07024Roy Limate 07024Angel Moskowitz 07024Hedy Naso 07024Donna Walston 07024
7 rows selected.
APPENDIX D STUDENT DATABASE GRADE_CONVERSION LETTER GRADE (PK) VARCHAR2(2) NOT NULL GRADE POINT NUMBER(3,2) NOT NULL MAX_GRADE MIN GRADE CREATED BY CREATED_DATE MODIFIED BY MODIFIED_DATE GRADE STUDENT ID (PK) (FK) SECTION_ID (PK)(FK) CREATED BY CREATED DATE MODIFIED BY MODIFIED_DATE GRADE_TYPE_CODE (PK) (FK) GRADE CODE OCCURRENCE (PK) NUMERIC GRADE COMMENTS CREATED BY CREATED DATE MODIFIED BY MODIFIED_DATE STUDENT ENR STU FK SALUTATION FIRST NAME LAST NAME ZIP (FK) PHONE ENROLLMENT STUDENT D (PK) (FK) NUMBER(8,0) SECTION_ID (PKK(FK) NUMBER(8,0) ENROLL DATE FINAL GRADE NUMBER(3,0) NOT NULL NUMBER(3.0) NOT NULL VARCHAR2(30) NOT NULL NOT NULL NOT NULL NOT NULL DATE EMPLOYER VARCHAR2(30) DATE CREATED BY SCHEMA NUMBER(8,0) NUMBER(8,0) CHAR(2) NUMBER(38,0) NUMBER(3,0) REGISTRATION DATE DATE DATE VARCHAR2(2000) VARCHAR2(30) NOT NULL NOT NULL VARCHAR2(30) DATE CREATED DATE DATE MODIFIED BY MODIFIED DATE GR_ENR FK NOT NULL NULL DATE NUMBER(3,0) VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL NOT NULL DATE VARCHAR2(5) NOT NULL NOT NULL CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE VARCHAR2(15) VARCHAR2(50) NOT NULL NOT NULL NULL COURSE COURSE NO (PK) NUMBER(8,0) NOT NULL DESCRIPTION VARCHAR2(50) NOT NULL COST NUMBER(9,2) NULL PREREQUISITE (FK) NUMBER(8,0) NOT NULL NOT NULL NOT NULL GR GRTW FK NUMBER PER SECTION NOT NULL NOT NULL SECT_CRSE FK GRADE_TYPE GRADE TYPE CODE (PK) CHAR(2) DESCRIPTION CREATED BY CREATED_DATE NULL VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL MODIFIED BY MODIFIED DATE ORSE_CRSE_FK - ENR SECT FK GRADE_TYPE_WEIGHT SECTION_ID (PK)(FK) GRADE_TYPE_CODE (PK)(FK) CHAR(2) STUDENT D (PK) NUMBER(8,0) NOT NULL NULL VARCHAR2(25) NULL VARCHAR2(25) NOT NULL 11-19 STREET_ADDRESS VARCHAR2(50) NULL VARCHAR2(5) NOT NULL NULL NULL STU_ZP FK NOT NULL VARCHAR2(30) NOT NULL NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL GRTW_SECT_FK SECTION SECTION ID (PK) COURSE NO (FK) SECTION NO START DATE TIME LOCATION NUMBER(3,0) PERCENT_OF_FINAL_GRADE NUMBER(3,0) DROP LOWEST CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE FIRST NAME LAST NAME STREET ADDRESS ZP (FK) PHONE CREATED BY CREATED_DATE MODIFIED BY MODIFIED_DATE NOT NULL VARCHAR2(50) NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL NOT NULL NOT NULL NUMBER(8,0) NUMBER(8,0) NUMBER(3,0) NOT NULL NULL DATE NULL VARCHAR2(50) NOT NULL INSTRUCTOR_ID (FK) NUMBER(8,0) CAPACITY CREATED BY CREATED DATE MODIFIED BY MODIFIED_DATE NULL NUMBER(3,0) VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL ZIPCODE GRTW_GRTYP_FK NUMBER(8,0) NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL CHAR(1) VARCHAR2(30) NOT NULL NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL ZIP (PK) INSTRUCTOR SALUTATION NULL INSTRUCTOR_ID (PK) NUMBER(8,0) NOT NULL NULL VARCHAR2(5) VARCHAR2(25) NULL VARCHAR2(25) NULL VARCHAR2(50) VARCHAR2(5) VARCHAR2(15) NULL VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL NULL NOT NULL CITY STATE DATE DATE VARCHAR2(5) NOT NULL VARCHAR2(25) NULL NULL CREATED BY VARCHAR2(30) NOT NULL SECT INST FK CREATED DATE DATE INST ZIP FK VARCHAR2(2) MODIFIED_DATE DATE NOT NULL MODIFIED BY VARCHAR2(30) NOT NULL NOT NULL