SQL developer

Date & Aggregate functions 1. Determine the Start Time for all sections of the following courses 100,140,210,420. The time should be displayed as Month, Date, Year, Hour, Minute and Seconds, with a column alias of Lab4 Start Time. 2. Determine the difference in days between the first start time of a class and the last start time for a course when the course has one section. 3. Display the start time for the section id between 0 and 100, with the following format: Start Time MONDAY, 16th APRIL, 1999 9:30 AM 4. Write a SELECT statement to determine how many students enrolled in January 2007. 5. Show a list of course numbers, their description, and their prerequisites. If the prerequisite is null, substitute "None" using NVL and a data conversion function. 6. Using DECODE, write a query that checks the phone number of students. If the area code is 212, remove it. If it is anything else., put a 1- in front of the phone number. Display the student name and the phone number. If they have no phone number, display No Phone. 7. Display the courses where the COST is null or greater than 1500 8. For course numbers 430 and greater, show the course cost. Add another column, reflecting a discount of 10% of the cost and substitute any NULL values in the COST column with the number 1000. REPORT: 1. Source code 2. Output script (Screenshot)