[Solved] DBS301 Lab 3 (Single-Line Functions)

This week’s lab continues using the SELECT command and learning the interfaces for both SQLDeveloper and introduces the use of single-line functions.Getting StartedYour submission will be a single text-based SQL file with appropriate header and commenting.Please ensure your file runs when the entire file is executed in SQL Developer.Create a new Worksheet in SQL Developer. Save the file as L03_ID#_LASTNAME.sqlYour submission needs to be commented and include the question, the solutions, and theresults. An example is provided!Tasks• Write a query to display the tomorrow’s date in the following format:January 10th of year 2019the result will depend on the day when you RUN/EXECUTE this query. Label the column“Tomorrow”.Advanced Option: Define an SQL variable called “tomorrow”, assign it a value oftomorrow’s date, use it in an SQL statement. Don’t forget to undefine it!• For each employee in departments 20, 50 and 60 display last name, first name, salary,and salary increased by 4% and expressed as a whole number. Label the column “GoodSalary”.Also add a column that subtracts the old salary from the new salary and multiplies by12. Label the column “Annual Pay Increase”.• Write a query that displays the employee’s Full Name and Job Title in the followingformat:DAVIES, CURTIS is ST_CLERKOnly employees whose last name ends with S and first name starts with C or K. Give thiscolumn an appropriate label like Person and Job. Sort the result by the employees’ lastnames.• For each employee hired before 1997, display the employee’s last name, hire date andcalculate the number of YEARS between TODAY and the date the employee was hired.• Label the column Years worked.• Order your results by the number of years employed. Round the number ofyears employed up to the closest whole number.• Create a query that displays the city names, country codes and state province names,but only for those cities that starts with S and has at least 8 characters in their name. Ifcity does not have a province name assigned, then put Unknown Province. Be cautiousof case sensitivity!• Display each employee’s last name, hire date, and salary review date, which is the firstThursday after a year of service, but only for those hired after 2017.• Label the column REVIEW DAY.• Format the dates to appear in the format like:THURSDAY, August the Thirty-First of year 2018• Sort by review dateExample Submission— ***********************— Name: Your Name— ID: #########— Date: The current date— Purpose: Lab 3 DBS301— ***********************— Question 1 – write a brief note about what thequestion is asking— Q1 SOLUTION —SELECT * FROM TABLE;— Question 2 – blah blah blah