Question
-- 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
-- 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. */
/*2-- List course number, section ID and start date for all sections located in L509. Arrange by start date. */
/*3-- 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. */
/*4-- List Student ID, Section ID and final grade for all students who have a final grade and enrolled in January 2007. */
/*5-- 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.*/
/*6-- Provide a list of course numbers and locations for sections being taught in the even numbered rooms located in building L. */
/*7-- Provide a list of Students in zip code 11368 that registered 3 or more days after their student record was created. */
/*8-- 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. */
/*9-- Create a list of starting times for all course sections. Eliminate duplicates . */
/*10-- List the Student ID, Section ID and time enrolled for all students who enrolled at 10:19am. Arrange the list by student ID */
Step 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