CustomerID CompanyName City
ALFKI Alfreds Futterkiste Berlin
ANTON Antonio Moreno Taquerias Mexico D.F.
AROUT Around the Horn London
数据集也可能包含另一个含有订单信息的表。“Orders”表包含外键列形式的 Customer ID。只选择“Orders”表中的某些列,可能类似于以下内容:
OrderId CustomerID OrderDate
10692 ALFKI 10/03/1997
10702 ALFKI 10/13/1997
10365 ANTON 11/27/1996
10507 ANTON 4/15/1997