title: Concatenation - First Name and Last Name Same Column (Oracle SQL)
body: <p>Completely new to Oracle SQL, with that being said:</p>
  
  <p>Trying to display author first and last name in the same column as "Author" along with the number of books written by that author (results in ascending order by author first name).</p>
  
  <pre><code>SELECT AUTHOR.FNAME || ' ' || AUTHOR.LNAME AS "Author",
  COUNT(BOOKAUTHOR.AUTHORID) AS "Books written"
  FROM BOOKS
  INNER JOIN BOOKAUTHOR ON BOOKS.ISBN = BOOKAUTHOR.ISBN
  INNER JOIN AUTHOR ON BOOKAUTHOR.AuthorID = AUTHOR.AuthorID
  ORDER BY AUTHOR.FNAME ASC
  </code></pre>
  
  <p>Concatenation doesn't seem to be working and having issues with the overall query.</p>
  
  <p>Here are the tables that relate:</p>
  
  <p><strong>Books</strong>: ISBN, TITLE</p>
  
  <p><strong>Author</strong>: AUTHORID, LNAME, FNAME</p>
  
  <p><strong>BookAuthor</strong>: ISBN, AUTHORID</p>
  
  <p>Even when I try and do a simple concatenation with just using SELECT and FROM it does not show any results.</p>
  
  <p>Like for example:</p>
  
  <pre><code>SELECT FNAME || ' ' || LNAME "AUTHOR NAME"
  FROM AUTHOR
  </code></pre>