Using Group By and Sum
   Summary
Customer ID Company Name Country Birth Date Credit Limit
State : Alagoas
$ 2,823.51
BLONP Blondesddsl pere et fils France 07 Mar, 1978 $ 2,823.51
 
State : Buenos Aires
$ 19,100.08
GOURL Gourmet Lanchonetes Brazil 16 Apr, 1978 $ 1,223.51
LEHMS Lehmanns Marktstand Germany 02 Dec, 1977 $ 700.31
QUEEN Queen Cozinha Brazil 27 Dec, 1974 $ 158.35
RICAR Ricardo Associcados Brazil 26 May, 1973 $ 6,339.47
TOMSP Toms Spezialitaten Germany 04 Jun, 1977 $ 9,901.89
TORTU Tortuga Restaurante Mexico 06 Dec, 1977 $ 776.55
 
State : Bern
$ 12,864.80
KOENE Koniglich Essen Germany 24 Jan, 1977 $ 4,073.46
WANDK Die Wandernde Kuh Germany 08 Aug, 1976 $ 8,791.34
 
State : Bornholm
$ 892.11
SIMOB Simons bistro Denmark 10 Dec, 1975 $ 892.11
 
Grand Summary(91) $ 413,248.57
1 2 3 4 5