Use the Employees table (copy and paste the code in SQL command line)

Write the PL/SQL based on the requirement in each number.

Note: Sample output is just a guide, it does not necessarily that the value to your output should be equal to the sample output.

can someone help me with this question...thank you!

7. Write a query that display the firstname concatenated to salary with additional column salary that provides a computation of salary * 2. Rename the column as Increase of all employees whose lastname ends with N. Sample output: Increase Jennifer salary is 4400 if multiply by two then he/she got a new salary of 8800 8. Write a query that displays the salary leftpadded with 15 character long and '$' as special character and another column salary right padded with 10 character long with @'as special character used of all employees in 201, 176 and 144. 9. Write a query using SUBSTR function that returns the job id - 'REP Sample output: Job_id SA REP rds English (United States)