Listing 2: Retrieving Data from the Inventory Database

USE Inventory;
GO
--BEGIN COMMENT
--Use a SELECT statement to retrieve the data.
--END COMMENT
SELECT bk.bkTitle AS Title, au.auLastName AS [Last Name],
  auFirstName AS [First Name]  
FROM inv.Books bk 
  INNER JOIN inv.BookAuthors ba ON bk.bkID = ba.bkID 
  INNER JOIN inv.Authors au ON ba.auID = au.auID
WHERE bk.bkInStock > 5
ORDER BY Title, [Last Name], [First Name];