Databases and database objects

profileDarkGemini
Lab1-1Customer.xlsx

Sheet1

Customer Number Customer Name Address City State Postal Code Amount Paid Balance Due Sales Rep Number
AA30 All About Gardens 47 Berton St. Greer PA 19158 $1,190.00 $365.00 26
CT02 Christmas Tree Farm 483 Cantor Rd. Pleasantburg NJ 07025 $2,285.50 $825.35 29
GG01 Garden Gnome 10 Main St. Gossett PA 19157 $1,300.00 $297.50 29
GT34 Green Thumb Growers 26 Jefferson Hwy. Pleasantburg NJ 07025 $3,325.45 $865.50 32
LH15 Lawn & Home Store 33 Maple St. Chambers NJ 07037 $895.00 $515.00 26
ML25 Mum's Landscaping 196 Lincoln Ave. Quaker DE 19719 $0.00 $1,805.00 29
OA45 Outside Architects 234 Magnolia Rd. Gaston DE 19723 $4,205.50 $945.00 32
PL10 Pat's Landscaping 22 Main St. Chesnee NJ 07053 $1,165.00 $180.00 26
PN18 Pyke Nurseries 10 Grant Blvd. Adelphia PA 19159 $2,465.00 $530.00 32
SL25 Summit Lawn Service 345 Oaktree Rd. Chesnee NJ 07053 $3,225.45 $675.50 26
TG38 TriState Growers 24 Main St. Gaston DE 19723 $1,075.00 $0.00 29
TW34 TAL Wholesalers 234 Cantor Rd. Pleasantburg NJ 07025 $4,125.00 $350.00 26
TY03 TLC Yard Care 24 Berton St. Greer PA 19158 $1,845.00 $689.45 29
YS04 Yard Shoppe 124 Elm St. Quaker DE 19719 $445.00 $575.00 32
YW01 Young's Wholesalers 5239 Lancaster Hwy. Adelphia PA 19156 $1,785.50 $345.60 32