5.1.1数据处理初相见.pptxVIP

5.1.1数据处理初相见

Id_PLastNameFirstNameAddressCity1AdamsJohnOxfordStreetLondon2BushGeorgeFifthAvenueNewYork3JoshTanPinganRoadBeijing4KevinCCTiantanRoadBeijing5CarterThomasChanganStreetBeijingPersons:O_IdOrderDateOrderPriceCustomer12008/12/291000Bush22008/11/231600Carter32008/10/05700Bush42008/09/28300Bush52008/08/062000Adams62008/07/21100CarterOrders:Q:计算客户表里的客户总数。计算订单表里的订购总金额。计算各城市的客户总数和订购总金额。数据采集单元作业点评

SELECTCOUNT(DISTINCTLastName)asCust#FROMPersons;SELECTCOUNT(DISTINCTFirstName)asCust#FROMPersons;SELECTCOUNT(DISTINCTFirstName||LastName)asCust#FROMPersons;A:计算客户表里的客户总数。