Counting Records

I need a report created on a SQL database query that must subtotal records per call rep based on a date perimeter (this part is done). The report needs two columns added that will count the records based on a specific type, orders and estimates. In addition, a new report needs to be created that will list additional information on which records this total count contains. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site). ## Platform SQL Server 7.0, Active Server Pages