Question

1 Approved Answer

Posted on Sep 22, 2024

Show the section ID, the course description, and the number of different grade types for sections with a section ID less than 100 and having

Show the section ID, the course description, and the number of different grade types for sections with a section ID less than 100 and having at least 3 different grade types. Arrange the list by course description, number of different grade codes and then the section ID. IN ORCALE SQL image text in transcribed

APPENDIX D STUDENT DATABASE SCHEMA GRADE CONVERSION LETTER GRADE (FK) VARCHAR2(2) NOT NULL GRADE POINT NUMBER/3.2) NOT NULL MAX GRADE NUMBER(3.0) NOT NULL MN GRADE NUMBER(3.0) NOT NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODFED BY VARCHAR2(30) NOT NULL MODFED DATE DATE NOT NULL GRADE TYPE GRADE TYPE CODE (PN) CHAR2) NOT NULL DESCRPTION VARCHAR2(50) NOT NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODFED BY VARCHAR2(30) NOT NULL MODFED DATE DATE NOT NULL GRTW_GRTYP_PK OR W GRADE STUDENT D (PK) (FK) NUMBER/80) NOT NULL SECTION ID (PKK ) NUMBER(80) NOT NULL GRADE TYPE CODE (PRK) CHAR2) NOTNI GRADE CODE OCCURRENCE (FR) NUMBER 1.0) NOT NULL NUMERIC GRADE NUMBER(3.0) NOT NULL COMMENTS VARCHAR2(2000) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODFED_BY VARCHAR2(30) NOT NULL MODFED_DATE DATE NOT NULL GRADE TYPE WEIGHT SECTION D (PK (FK NUMBER(8,0) NOT NULL V GRADE TYPE CODE (PKK ) CHAR/2) NOT NULL NUMBER PER SECTION NUMBER/3.0) NOT NULL PERCENT OF FINAL GRADE NUMBER(3.0) NOT NULL DROP LOWEST CHAR(1) NOT NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DA TE NOT NULL MODIFED BY VARCHAR2(30) NOT NULL MODIFIED DATE DATE NOT NULL GRTW_SECT_FK GR_ENR_FK ENROLLMENT STUDENT DIP)(EK) NUMBER 8.0) NOT NULL SECTION_ID (PKMFK) NUMBER(80) NOT NULL DATE NOT NULL FINAL GRADE NUMBER(30) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL PNR SECT FK SECTION SECTION D(PK) NUMBER 0) NOT NULL COURSE NO (FK) NUMBER 8,0) NOT NULL SECTION NO NUMBER3.0) NOT NULL START DATE TIME DATE NULL LOCATION VARCHAR2(50) NULL INSTRUCTOR D (FK) NUMBER(8,0) NOT NULL CAPACITY NUMBER 30) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED_DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL SECT_ORSE FK SECT NST FK COURSE COURSE NO (PK) NUMBER(8,0) NOT NULL DESCRPTION VARCHAR2(50) NOT NULL COST NUMBER/92) NULL PREREQUISITE (FK) NUMBER(80) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL BNR STU FK NULL INSTRUCTOR INSTRUCTOR D(PNO NUMBER80) NOT NULL SALUTATION VARO AR215) NULL FIRST NAME VAROR225) NULL LAST NAME VARCHAR2(25) STREET ADDRESS VARCHAR2150) NULL ZP (FK) VARCHAR2(5) NULL PHONE VARCHAR2(15) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFIED BY VARCHAR2(30) NOT NULL MOOFIED DA TEDATE NOT NULL CRSE CRSE FK INST ZP FK STUDENT STUDENT D (PK) NUMBER(80) NOT NULL SALUTATION VARCHAROS) NULL FIRST NAME VARCHAROL25) NULL LAST NAME VARCHAR2(25) NOT NULL STREET ADDRESS VARCHAR2/50) NULL ZIP (FK) VARCHAR2(5) NOT NULL PHONE VARCHAR2(15) NULL BMPLOYER VARCHAR2(50) NULL REGISTRATION DATE DATE NOT NULLO CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL STU ZP FK ZIPCODE ZPN) VARCHAR2/5) NOT NULL CITY VARCHAR2/25) NULL STATE VARCHAR2/2) CREATED_BY VARCHAR2/30) NOT NULL CREATED DATE DATE NOT NULL MOOFED_BY VARCHAR2/30) NOT NULL MOOFED DATE DA TE NOT NULL APPENDIX D STUDENT DATABASE SCHEMA GRADE CONVERSION LETTER GRADE (FK) VARCHAR2(2) NOT NULL GRADE POINT NUMBER/3.2) NOT NULL MAX GRADE NUMBER(3.0) NOT NULL MN GRADE NUMBER(3.0) NOT NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODFED BY VARCHAR2(30) NOT NULL MODFED DATE DATE NOT NULL GRADE TYPE GRADE TYPE CODE (PN) CHAR2) NOT NULL DESCRPTION VARCHAR2(50) NOT NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODFED BY VARCHAR2(30) NOT NULL MODFED DATE DATE NOT NULL GRTW_GRTYP_PK OR W GRADE STUDENT D (PK) (FK) NUMBER/80) NOT NULL SECTION ID (PKK ) NUMBER(80) NOT NULL GRADE TYPE CODE (PRK) CHAR2) NOTNI GRADE CODE OCCURRENCE (FR) NUMBER 1.0) NOT NULL NUMERIC GRADE NUMBER(3.0) NOT NULL COMMENTS VARCHAR2(2000) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODFED_BY VARCHAR2(30) NOT NULL MODFED_DATE DATE NOT NULL GRADE TYPE WEIGHT SECTION D (PK (FK NUMBER(8,0) NOT NULL V GRADE TYPE CODE (PKK ) CHAR/2) NOT NULL NUMBER PER SECTION NUMBER/3.0) NOT NULL PERCENT OF FINAL GRADE NUMBER(3.0) NOT NULL DROP LOWEST CHAR(1) NOT NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DA TE NOT NULL MODIFED BY VARCHAR2(30) NOT NULL MODIFIED DATE DATE NOT NULL GRTW_SECT_FK GR_ENR_FK ENROLLMENT STUDENT DIP)(EK) NUMBER 8.0) NOT NULL SECTION_ID (PKMFK) NUMBER(80) NOT NULL DATE NOT NULL FINAL GRADE NUMBER(30) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL PNR SECT FK SECTION SECTION D(PK) NUMBER 0) NOT NULL COURSE NO (FK) NUMBER 8,0) NOT NULL SECTION NO NUMBER3.0) NOT NULL START DATE TIME DATE NULL LOCATION VARCHAR2(50) NULL INSTRUCTOR D (FK) NUMBER(8,0) NOT NULL CAPACITY NUMBER 30) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED_DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL SECT_ORSE FK SECT NST FK COURSE COURSE NO (PK) NUMBER(8,0) NOT NULL DESCRPTION VARCHAR2(50) NOT NULL COST NUMBER/92) NULL PREREQUISITE (FK) NUMBER(80) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL BNR STU FK NULL INSTRUCTOR INSTRUCTOR D(PNO NUMBER80) NOT NULL SALUTATION VARO AR215) NULL FIRST NAME VAROR225) NULL LAST NAME VARCHAR2(25) STREET ADDRESS VARCHAR2150) NULL ZP (FK) VARCHAR2(5) NULL PHONE VARCHAR2(15) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFIED BY VARCHAR2(30) NOT NULL MOOFIED DA TEDATE NOT NULL CRSE CRSE FK INST ZP FK STUDENT STUDENT D (PK) NUMBER(80) NOT NULL SALUTATION VARCHAROS) NULL FIRST NAME VARCHAROL25) NULL LAST NAME VARCHAR2(25) NOT NULL STREET ADDRESS VARCHAR2/50) NULL ZIP (FK) VARCHAR2(5) NOT NULL PHONE VARCHAR2(15) NULL BMPLOYER VARCHAR2(50) NULL REGISTRATION DATE DATE NOT NULLO CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MOOFED BY VARCHAR2(30) NOT NULL MOOFED DATE DATE NOT NULL STU ZP FK ZIPCODE ZPN) VARCHAR2/5) NOT NULL CITY VARCHAR2/25) NULL STATE VARCHAR2/2) CREATED_BY VARCHAR2/30) NOT NULL CREATED DATE DATE NOT NULL MOOFED_BY VARCHAR2/30) NOT NULL MOOFED DATE DA TE NOT NULL