HP 3000 Manuals HP 3000 Manuals
The Data You Need
In Lesson 2, the first report, you used the CUSTOMERS data set from the
TOYDB database. For this second report, you will use the following data
sets:
CUSTOMERS To find the customer name, sales area, and turnover
for the last month.
ORDERS To find the orders, if any, for a customer.
ORDER-DETAILS To find the product number and the quantity ordered
for each order.
PRODUCTS To find the price of a product.
The calculations required are:
* total sales in each sales area
* total sales in all sales areas
* total value of each order
You have already defined the first two calculations in the previous
report. You can easily calculate the total value of each order, by
having BRW multiply the price of the order by the quantity ordered for
each order.