qry11
Total Savings on Orders and Price Break per Book
SELECT (tblBook.tblBook_RetailPrice-tblOrder.tblOrder_DiscountPrice)*tblOrder.tblOrder_NumberOfBooksOrdered
AS 'TotalSavings',
tblBook.tblBook_Title,
(tblBook.tblBook_RetailPrice - tblOrder.tblOrder_DiscountPrice)
AS 'PriceBreak',
tblOrder_NumberOfBooksOrdered
FROM tblBook
INNER JOIN tblOrder ON tblBook.tblBook_ID = tblOrder.tblOrder_tblBook_ID
ORDER BY tblBook_Title ASC
| Total Savings |
Title |
Price Break |
Number Ordered |
| $ 80.00 |
American Dynasty: Aristocracy, Fortune, and the Politics of Deceit in the House of Bush |
$ 4.00 |
20 |
| $ 180.00 |
Arming America |
$ 6.00 |
30 |
| $ 540.00 |
Art of War: War and Military Thought |
$ 6.00 |
90 |
| $ 42.00 |
Collapse at Meuse-Argonne: The Failure of the Missouri-Kansas Division |
$ 2.00 |
21 |
| $ 560.00 |
Die vergifteten Pralinen |
$ 8.00 |
70 |
| $ 200.00 |
Great New York Conspiracy of 1741: Slavery, Crime, and Colonial Law |
$ 4.00 |
50 |
| $ 140.00 |
Origins of Christian Morality: The First Two Centuries |
$ 7.00 |
20 |
| $ 105.00 |
Preface to Mark: Notes on the Gospel in its Literary and Cultural Settings |
$ 3.00 |
35 |
| $ 490.00 |
Satan und das Dolce Vita |
$ 7.00 |
70 |
| $ 160.00 |
Strategy; its theory and application: the wars for German unification, 1866-1871 |
$ 5.00 |
32 |