title: SQL select statement targeting multiple specific areas of a table
body: <p>I was able to get this far but what I can't figure is how list the name of the branch before the results of the count().</p>
  
  <p>I also need a way to show all branches and the amount of loaned books to that specific branch all at the same time. If anyone could help me with this that would be amazing, thank you!</p>
  
  <p>Results looking like
  "Branch Name".. "Number of loaned books"
  "Next Branch".. "Number of loaned books"</p>
  
  <p>Code: </p>
  
  <pre><code>select count(bookLoans.bookID) from bookLoans
  inner join libraryBranches on bookLoans.lbID = libraryBranches.lbID
  where libraryBranches.branchName = 'Sharpstown'
  </code></pre>