Question: write a query to display each zip code and the total owed by customers in that zip code. Only include zip codes for the total
write a query to display each zip code and the total owed by customers in that zip code. Only include zip codes for the total owed is above 1000

SalesRep Customer PK ReplD int PK CustomerlD int LastName FirstName CommissionRatedecimal(10,2) varchar(20) varchar(20) LastName varchar(20) FirstName varchar(20) Street City State Zipcode Balance varchar(20) varchar(20) char(2) Order char(5) decimal(10,2) int PK OrderID int FK1ReplD FK1 CustomerlD int OrderDate date ShipDate date Part PK PartID int OrderLine Description varchar(20) UnitsOnHandint ItemClass Retail Cost PK,FK1OrderlD int PK,FK2 PartlDint char(4) decimal(10,2) decimal(10,2) Quantity int
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
