Question
Using Oracle SQL create the commands to achieve what is asked for each question. For all questions where you are asked to display a date,
Using Oracle SQL create the commands to achieve what is asked for each question.
For all questions where you are asked to display a date, please display like 2/8/2018 unless otherwise specified.
List the first name, last name and phone number for all students that registered on 2/13/2007. Arrange the list in order of last name and first name.
List course number, section ID and start date for all sections located in L509. Arrange by start date.
List the course number, section ID, start date, instructor ID and capacity for all courses with a start date in July 2007. Arrange the list by start date and course number. */
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
STUDENT DATABASE SCHEMAStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started