Question: This is all one question. Using oracle sql and the database below create the commands to answer the stuff below. List Student ID, Section ID
This is all one question. Using oracle sql and the database below create the commands to answer the stuff below.
List Student ID, Section ID and final grade for all students who have a final grade and enrolled in January 2007.
Create a query using the Oracle Dual Table that returns the date of the end of the semester for courses that begin on January 11, 2016. The semester is 109 days long.
Provide a list of course numbers and locations for sections being taught in the even numbered rooms located in building L.
Provide a list of Students in zip code 11368 that registered 3 or more days after their student record was created.
Create a list of student names (first name, last name) along with the number of years since they registered (round to 2 decimal places) for those students from area code 212. Sort the list on the number of years from highest to lowest.
Create a list of starting times for all course sections. Eliminate duplicates .
List the Student ID, Section ID and time enrolled for all students who enrolled at 10:19am. Arrange the list by student ID
A PPENDIX D STUDENT DATABASE SCHEMA LETTER GRADE IPO VARCHAR2 NOTNULL CREATED CATE CATE GRADE-CO E-OOCLRRENCEPON.AEEN 38es NDTN.AL GHTW SECT FK START DATEL TME CATE MOOFED DATE CATE CPEATED DATE CATE MCOFED DATE CATE REATID DATE DATI GREATED CATE DATE STUDENT DOK NUMBER NOT NULL STREET ADDRESS VARDAR250NULL CREATED By OREATEDoATEDATE CREATED DATE CATE MOOFED DATE DATE MCOFED DATE DATE A PPENDIX D STUDENT DATABASE SCHEMA LETTER GRADE IPO VARCHAR2 NOTNULL CREATED CATE CATE GRADE-CO E-OOCLRRENCEPON.AEEN 38es NDTN.AL GHTW SECT FK START DATEL TME CATE MOOFED DATE CATE CPEATED DATE CATE MCOFED DATE CATE REATID DATE DATI GREATED CATE DATE STUDENT DOK NUMBER NOT NULL STREET ADDRESS VARDAR250NULL CREATED By OREATEDoATEDATE CREATED DATE CATE MOOFED DATE DATE MCOFED DATE DATE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
