Using Group By and Sum
State :
ID Company Name Country Phone Credit Limit
33 fghfgh     $ 0.00
Total $ 0.00
State : Alaska
ID Company Name Country Phone Credit Limit
FOLKO Folk och fa HB SE 0695-34 67 21 $ 5,645.33
Total $ 5,645.33
State : Alabama
ID Company Name Country Phone Credit Limit
SEVES Seven Seas Imports GB (171) 555-1717 $ 2,241.68
Total $ 2,241.68
State : Arkansas
ID Company Name Country Phone Credit Limit
ANTON Antonio Moreno Taqueriila AR 0055553932 $ 6,757.53
ERNSH Ernst Handel AT 7675-3425 $ 3,844.57
Total $ 10,602.10
State : Arizona
ID Company Name Country Phone Credit Limit
FRANK Frankenversand DE 089-0877310 $ 7,552.96
MAISD Maison Dewey BE (02) 201 24 67 $ 97.16
VICTE Victuailles en stock FR 78.32.54.86 $ 5,568.00
Total $ 13,218.12
State : California
ID Company Name Country Phone Credit Limit
GROSR GROSELLA-Restaurante VE (2) 283-2951 $ 1,072.60
LACOR La corne d'abondance FR 30.59.84.10 $ 4,918.43