(活动手册-第二章-练习题中英文对照.docVIP

活动手册-练习题 Activity Book-Exercises Chapter2 Display the details of all the customers Diplay the ID,type,number and expiry year of all the credit cards in the following format 以下面的格式（参考活动手册）显示所有信用卡的编号，类型，卡号和到期年份 Display the customerID and the account number of all the customers who live in the TerritoryID 4 显示所有住在TerritoryID为4的地区的客户的客户编号和账号 Display all the details of the sales orders that have a cost exceeding $2000 显示所有成本（LineTotal）超过2000的销售订单的详细信息 Display the sales order details of the product named ‘Cable Lock’ for which the ProductID is 843 显示产品编号为843的产品的订单信息，不用考虑名称Cable Lock Display the list of all the orders placed on June.06,2004 显示所有2004年6月6日下的订单的信息 Display a report of all the orders in the following format 以下面的格式（参考活动手册）显示所有订单的报告/信息 Display a list of all the sales orders in the price range of $2000 and $2100 显示价格（LineTotal）在2000到2100之间的销售订单的信息 Note:LineTotal computes the subtotal of each product,Computed as UnitPrice*(1-UnitPriceDiscount)*OrderQty、 备注：LineTotal是每个产品的小计，计算方式为单价（1-单价折扣）*订单数量 Display the name,country region code,and sales year to date for the territory with Territory ID as 1 显示地区编号为1的地区的名称，国家地区代码和至今的销售记录 Display the details fo the orders that have a tax amount of more than $10,000 显示税额超过10000的订单的信息 Display the sales territory details of Canada,France, and Germany 显示加拿大，法国和德国的销售区域信息 Display a report that contains the IDs of sales persons living in the territory with TerritoryID as 2 or 4,.The report is required in the following format. 显示包含居住在TerritoryID为2或4的地区的销售人员的ID的报告。报告显示格式如下（参考活动手册）。 Display the details of the Vista credit cards that are expiring in the year 2006. 显示2006年即将到期的Vista信用卡的详细信息 Display the details of all the orders that were shipped after July 12,2004. 显示2004年7月12日后装运的所有订单的详细信息 Display the orders placed on July 01,2001 that have a total cost of more than $10,000 in the following format. 用以下格式（参考活动手册）显示2001年7月1日所下的，总成本（TotalDue）超过10000的订单的信息。 Display the details of the orders that hav