SQL Assignment ‐ 2

1. Display the first name and last name of all employees in uppercase.

2.Display the first name of all employees in lowercase.

3.Display the first name and last name using INITCAP (capitalize first letter only).

4.Display the first name and its length.

5. Display the first name and show only the first three characters

6.Display the first name and the position of the letter ‘a’ in it

7.Display the first name and replace all occurrences of ‘a’ with ‘@’

8.Display the first name right-padded with * up to 15 characters

9.Display the first name left-padded with # up to 20 characters

10. Display the first name and last name concatenated as Full_Name

11.Display the employee name, salary, and the rounded salary to the nearest thousand

12.Display the employee name, salary, and the truncated salary to the nearest hundred

13.Display the employee name and salary raised to power 2.

14.Display the employee name and salary after adding 500 bonus

15.Display the employee name, commission_pct, and the total pay

16.Display the employee name and their hire date in the format DD-MON-YYYY

17.Display the employee name, hire_date, and next Monday after hire_date

18.Display the employee name, hire_date, and last day of the hire month

19.Display the employee name and the number of months worked till today

20.Display the employee name and the hire year

21.Display the employee name and hire_date + 30 days using date arithmetic.

22.Display the employee name, hire_date, and add 6 months to hire_date using ADD_MONTHS.

23.Display the employee name and the day name (e.g., Monday, Tuesday) of their hire_date