IN ORACLE SQL LIVE

$2.$ Create a list of employees names who have the job$\_$id of AD$\_$VP$,$ use the UPPER function in the WHERE statement

$3.$ Create a list that includes the first initial of every

employee's first name, a space, and the last name of

the employee, call it $$Employee Names$$

$4.$ Create a list of weekly salaries from the employees

table where the weekly salary is between $700$ and

$3000.$ The salaries should be formatted to include a $$-$sign

and be rounded to two decimal points like: $$9999\mathrm{.}99$

$5.$ Create a list of last$\_$names and hire$\_$dates for

employees with dates formatted as $$April $10$th$,2018,$

call date $$Hire Date$$

$6.$ Create Convert the string $$March $20,2018$ to a date

field with the column heading $$First Day of Spring$$

$7.$ Calculate the number of months between today and Christmas, rounded to a whole number

$8.$ Display each employee$$s name and a calculation of the

date a year from their hire$\_$date call it $$First Anniversary$$

$9.$ Create a list of every employee's first initial and last name, salary, and commission, if they don$$t make a commission substitute $0,$ call the column $$Commission$$

$10.$ Show the $$First$$ last name and the $$Last$$ last name from the employees table

$11.$ Produce a list of the earliest hire date as $$Highest$$ the latest hire date as $$Lowest$,$ and the number of employees as $$No of Employees$$ from the employees table

$12.$ Show the highest average salary for the departments in

the employees table

$$ Round the result to the nearest whole number $($Run for

solution$)$ SELECT ROUND$($MAX$($AVG$($salary$)),0)$ AS "Highest Avg Sal for

Depts" FROM employees GROUP BY department$\_$id;

$13.$ Create list of departments and the number of employees in them but only for departments with $3$ or more employees