每行包含下订单的客户键、订单的总价值、下订单的日期、描述订单优先次序的代码。
Each row also contains the customer key that placed the order, the total value of the order, the date the order was placed, and a code describing its priority.
清单 5 的代码获取一个包含所有从商店订购产品的客户的列表,以及上个月的所有订单的总价值。
The code retrieves the list of all customers that ordered products from the store and the total value of all orders during last month.
图 3 中的 ProjectedBalance 作业从 ORDERS 表中获取上个月的订单,并为每个客户键计算订单总价值。
The ProjectedBalance job illustrated in Figure 3 retrieves last month's orders from the ORDERS table and calculates their total value for each customer key.
应用推荐