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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!