Question: 1: 2 3 Question 37 (Mandatory) (2 points) Write a query that will use concatenation to list both FNAME and LNAME in the same column
1: 2 3 Question 37 (Mandatory) (2 points) Write a query that will use concatenation to list both FNAME and LNAME in the same column output. Use Author table to complete query (if you do not have a author table, you can use another table as a proxy to help you with the syntax) 5 6 ... 8 9 11 12 3 15 14 16 17 18 Question 38 (Mandatory) (2 points) Write the same query as above using the AUTHOR table and FNAME and LNAME fields to concat into one column, but this time add a literal string to put a blank space between the two fields to improve readability. 20 21 22 23 24
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
