Using Oracle SQL create the commands needed to achieve what is asked in the questions below.

1 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