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

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

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!