1. using salesman table, write a query that will display the first name, department and a column ”user id” that will combine the first three letters of gender column in capital letters and the day of birth_date in words in capital letters as well. display also another column which is “temporary password” by combining the following in order:
• get the department, but exclude the letter “a” and it should be in small letters.
• get the number of characters of family name.
• get the last digit of their manager