Please help with SQL!!

1. Write a query that displays the first name (with the first letter in uppercase and all the other letters in lowercase) and the length of the first name for all employees whose name starts with the letters S P or M salary. Give each column an appropriate label. Sort the results by the descending order of employees' salary. 2. Rewrite the query so that the user is prompted to enter a letter that the first name starts with. For example, if the user enters E (capitalized) when prompted for a letter, then the output should show all employees whose first name starts with the letter "E. 3. Modify the query such that the case of the entered letter does not affect the output. The entered letter must be capitalized before being processed by the SELECT query. 4. From the job...history table, the HR department wishes to find out the number of full years an employee has worked. Exclude any employees who have worked for less than a year. Display the employee id and the number of full years