Make sure those querys can work in SQL SERVER

Q-6. Write An SQL Query To Print The FIRST_NAME From Worker Table After Removing White Spaces From The Right Side. Ans.

The required query is:

Select RTRIM(FIRST_NAME) from Worker;

Q-7. Write An SQL Query To Print The DEPARTMENT From Worker Table After Removing White Spaces From The Left Side. Ans.

The required query is:

Select LTRIM(DEPARTMENT) from Worker;

Q-8. Write An SQL Query That Fetches The Unique Values Of DEPARTMENT From Worker Table And Prints Its Length. Ans.

The required query is:

Select distinct length(DEPARTMENT) from Worker;