List the first name and last name of all authors. Concatenate the first and last names so that the result set has only one column. Hint: CONCAT(). For example:+---------------+| Full Name |+---------------+| Mike Lance || Steve Smith || Anne Penny || Ron MacDonald || Sylvia Parry || Albert Jones |+---------------+ mysql> DESC author;mysql> DESC book;mysql> DESC bookauthor;| Field| Туре| Field| Typ| Field| Туре| author_idint(1varch| isbn| name| var| vartauthor_idisbntint(11| varchaauthor_order | int(11S5nlastname varch.| firstname | varchphoneaddress| type| varroyaltysharedecima.varchvarchvarch.| pub_id| int| dec| price| advance| decytd_sales | intI pubdate| city| state| zipvarch.| varch| datmysql> DESC bookeditor;| FieldI fypemysql> DESC editor;mysql> DESC publisher;| Field| editor_id | int(11)| isbn| varchar(1| editor_idssn| lastname| firstname| phoneeditor positionsalary| Field| ТуреI pub id | int(11)nameaddress | varchar(40)city| statevarchar(40)I varchar(20)I varchar(2)

Concat() function : This function in SQL joins string into one, maximum string which it can take as a input is 255 string and minimum it requires two strings to concate. If user passes any non-character value into the function then it implicitly convert it into string and concat the text. Syntax of sql query to concate with example: SELECT 'Johnson' + ' ' + 'Doe' AS full_name; Output : full_name---------------Johnson DoeSql Statement : SELECT CONCAT(firstname, ' ', lastname) Full_Name FROM author ORDER BY Full_Name; Running this it will display table by concating First name and Last name of all the authors. Output : Full_Name --------------- Mike Lance Steve Smith Anne Penny Ron MacDonald Sylvia Parry | Albert Jones |