Tables for the Zion Bookstore database are created and populated below. Run a query that joins the Sale, Customer, and Book tables:
SELECT C.State, S.BookID, B.Title, S.Quantity, S.UnitPrice * S.Quantity
FROM Sale S
INNER JOIN Customer C ON C.ID = S.CustID
INNER JOIN Book AS B ON B.ID = S.BookID;
