Question: 3. Create a query using the F_Staffs table to display the Staff_Type in capital letters with the column name SType, Create a new column with

3. Create a query using the F_Staffs table to display the Staff_Type in capital letters with the column name "SType", Create a new column with the name "SType" by combining of the column First_Name by replacing letter 'e' with '#' and first 3 characters of Staff_Type, Size of Last_Name with the column name "LNLength". Restrict the output to whose ID is more than [6 Marks) 10 and size of the Last_Name is more than 3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
