Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

-- 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

The background knowledge of the interpreter

Answered: 1 week ago

Question

socialist egalitarianism which resulted in wage levelling;

Answered: 1 week ago

Question

soyuznye (all-Union, controlling enterprises directly from Moscow);

Answered: 1 week ago