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

write a query to display each zip code and the total owed

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!