CST285 week5 dis

profilebinghanem
Week5Database.accdb
Home>Computer Science homework help>CST285 week5 dis
ContractNum CustomerID ContractAmt SigningDate ContractType
3011 11001 ¤ 4,000.00 2/9/13 Residential landscape plan
3012 11027 ¤ 300.00 2/18/13 Consultation for backyard, residential
3015 11005 ¤ 1,500.00 3/1/13 Schematic plan for backyard, residential
3017 11012 ¤ 2,250.00 3/1/13 Peer plan review for town
3020 11055 ¤ 6,500.00 2/19/13 Landscape design for restaurant
3021 11040 ¤ 28,000.00 5/3/13 Landscape plans for multifamily housing site
3022 11043 ¤ 22,000.00 4/14/13 Landscape design for two entrances
3023 11070 ¤ 39,000.00 3/22/13 Renovation of large multifamily housing open space
3025 11083 ¤ 15,500.00 3/25/13 Landscape renovation for plaza
3026 11038 ¤ 165,000.00 3/11/13 Landscape plans for large-scale housing development
3027 11008 ¤ 1,250.00 4/7/13 Schematic plan for back yard, residential
3030 11042 ¤ 5,250.00 6/11/13 Landscape plan for residential site
3031 11070 ¤ 48,500.00 6/3/13 Landscape design for multi-family housing
3032 11014 ¤ 6,500.00 6/22/13 Residential landscape plan
3033 11005 ¤ 2,250.00 7/8/13 Residential landscape plan for front yard
3034 11088 ¤ 8,500.00 5/28/13 Neighborhood park, nonprofit developer
3035 11088 ¤ 10,500.00 5/28/13 Neighborhood park, nonprofit developer
3037 11045 ¤ 68,000.00 6/22/13 Renovation of an existing city park
3038 11045 ¤ 34,000.00 6/22/13 Renovation of an existing playground at a city park
3040 11068 ¤ 38,500.00 7/27/13 Renovation of open space around public housing site
3043 11083 ¤ 19,000.00 8/11/13 Landscape design of open space around new campus building
3044 11075 ¤ 25,500.00 8/19/13 Handicap accessibility upgrades to public housing site
3045 11064 ¤ 25,000.00 8/20/13 Open space corridor planning at new transit station
3046 11048 ¤ 300.00 9/2/13 Consultation for back yard, residential
3048 11030 ¤ 7,500.00 9/23/13 Landscape design for restaurant site
3050 11015 ¤ 1,000.00 8/27/13 Schematic plan for back yard, residential
3051 11032 ¤ 18,000.00 10/5/13 Site layout and landscape design for residential site
3053 11049 ¤ 375.00 9/15/13 Consultation for front yard, residential
3056 11075 ¤ 32,500.00 9/30/13 Handicap accessibility upgrades to public housing site
3057 11075 ¤ 15,500.00 9/30/13 Handicap accessibility upgrades to public housing site
3060 11005 ¤ 4,000.00 11/30/13 Front walk and drive design, residential
3061 11070 ¤ 30,800.00 12/28/13 Landscape design for multi-family housing development
3062 11053 ¤ 20,000.00 1/11/14 Site layout and landscape design for residential site
3063 11015 ¤ 1,750.00 1/20/14 Landscape plan for front yard, residential
3065 11079 ¤ 38,000.00 2/3/14 Renovation of playground at elementary school
3068 11049 ¤ 4,500.00 2/7/14 Front walk and drive design, residential
3069 11030 ¤ 15,750.00 2/24/14 Landscape design for restaurant site
3070 11079 ¤ 35,000.00 3/3/14 Renovation of playground at elementary school
3071 11059 ¤ 37,000.00 3/11/14 Landscape design for affordable housing site
3072 11059 ¤ 46,000.00 3/11/14 Landscape design for affordable housing site
3073 11072 ¤ 205,000.00 5/5/14 Landscape plans for large-scale housing development
3075 11067 ¤ 16,500.00 4/8/14 Design of a playground for a daycare center
3076 11065 ¤ 5,000.00 4/8/14 Peer plan review for town
3077 11058 ¤ 6,500.00 5/17/14 Schematic landscape design for senior center
3078 11020 ¤ 13,750.00 4/25/14 Landscape design for business property
3080 11030 ¤ 22,800.00 4/14/14 Landscape design and site plan for restaurant site
3081 11071 ¤ 21,000.00 5/10/14 Landscape design for business property
3082 11060 ¤ 5,000.00 6/1/14 Residential landscape plan
3085 11068 ¤ 52,500.00 6/23/14 Open space & playground design for public housing site
3086 11054 ¤ 17,250.00 7/11/14 Landscape design for commercial property
3090 11079 ¤ 25,500.00 6/14/14 Renovation of playground at elementary school
3093 11085 ¤ 5,000.00 7/25/14 Residential landscape plan
3094 11015 ¤ 5,000.00 7/26/14 Front walk and drive design, residential
3095 11045 ¤ 14,500.00 6/29/14 Handicap accessibility upgrades to public housing site
3097 11080 ¤ 8,500.00 8/2/14 Landscape design for renovation of restaurant front entry
3098 11065 ¤ 35,000.00 7/15/14 Design of a small town park
3099 11067 ¤ 6,500.00 7/25/14 Schematic landscape design for daycare center
3100 11031 ¤ 10,500.00 8/8/14 Schematic landscape design for daycare center
3101 11030 ¤ 9,500.00 8/24/14 Landscape design for renovation of a restaurant site
3103 11087 ¤ 252,000.00 8/17/14 Landscape plans for large-scale housing development
3104 11073 ¤ 6,500.00 7/28/14 Front walk and drive design, residential
3105 11084 ¤ 5,000.00 8/24/14 Residential landscape plan
3108 11045 ¤ 50,000.00 8/2/14 Design of a small city park
3109 11059 ¤ 41,000.00 8/18/14 Landscape design for affordable housing site
3110 11079 ¤ 38,000.00 8/25/14 Renovation of playground at elementary school
CustomerID Company First Last Phone Address City State Zip Email
11001 Student First Student Last 616-866-3901 49 Blackstone Dr Rockford MI 49341 [email protected]
11005 Owen Hawes 616-392-0622 102 Pineview Rd Holland MI 49423 [email protected]
11008 Melissa Caputo 269-985-1122 302 Main St Saint Joseph MI 49085 [email protected]
11012 Grand Rapids Engineering Dept. Anthony Rodriguez 616-454-9801 225 Summer St Grand Rapids MI 49503 [email protected]
11014 Amol Mehta 616-396-1972 54 Lakeshore Ave Holland MI 49424 [email protected]
11015 John Weiss 616-637-7783 456 Winchester St South Haven MI 49090 [email protected]
11020 Battle Creek Dental Partners Harry Billings 269-963-0808 587 Longmeadow Rd Battle Creek MI 49014 [email protected]
11027 Karen O'Brien 517-483-9244 38 Langley Rd Lansing MI 48933 [email protected]
11030 Finn's on the Waterfront Devin Finnerty 616-393-1228 78 East 8th St Holland MI 49423 [email protected]
11031 Happy Haven Day Care Kathy Rowe 616-842-4603 29 Graham's Ln Grand Haven MI 49417 [email protected]
11032 Pam Wallner 269-857-1276 80 Cedar St Saugatuck MI 49453 [email protected]
11038 M. Grant Investment Company Alex Engber 517-482-1400 505 Washington Ave Lansing MI 48901 [email protected]
11040 RiverView Development Company Charles Nowak 616-988-0777 144 E Tower Ave Grand Rapids MI 49503 [email protected]
11042 Michael Ingram 269-337-9208 10 Lincoln Dr Kalamazoo MI 49007 [email protected]
11043 Monroe State College Rachel Kirk 616-988-1320 40 Monroe St Grand Rapids MI 49503 [email protected]
11045 Kalamazoo Neighborhood Development James Blackhawk 269-343-7509 3047 Millbrook Ave Kalamazoo MI 49007 [email protected]
11048 Olivia Pappas 616-637-6591 4 N Orchard St South Haven MI 49090 [email protected]
11049 Claire Boucher 269-983-2255 828 Turner St Saint Joseph MI 49085 [email protected]
11053 Hwan Tang 616-396-8401 283 Cottrell St Holland MI 49423 [email protected]
11054 Gilded Goose Gift Shop Taylor Wilson 616-355-3989 258 Briar Ln Holland MI 49424 [email protected]
11055 Fox and Hound Grille Steve Gorski 269-979-2004 1440 Beadle Lake Rd Battle Creek MI 49014 [email protected]
11058 Cherrywood Senior Center Lisa Hall 269-857-1771 77 Forest Hill Rd Saugatuck MI 49453 [email protected]
11059 G.R. Neighborhood Development Corp. Matthew Fraser 616-392-0015 8045 Jefferson Ave Grand Rapids MI 49503 [email protected]
11060 Jerome Smith 616-949-3862 75 Hillcrest St East Grand Rapids MI 49506 [email protected]
11064 Northwest Transit Station Henry Goldberg 517-487-4700 3572 Clinton Ave Lansing MI 48917 [email protected]
11065 Town of Holland Amber Ward 616-393-0403 24 Prospect St Holland MI 49423 [email protected]
11067 Blossom Day Care Center Christina Garrett 269-985-1992 333 Empire Ave Saint Joseph MI 49085 [email protected]
11068 Grand Rapids Housing Authority Jessica Ropiak 616-454-4002 5230 Fulton St Grand Rapids MI 49504 [email protected]
11070 Legacy Companies, LTD. Michael Faraci 616-456-7093 250 Market Ave Grand Rapids MI 49503 [email protected]
11071 Blue Star Mini Golf Vanetta Walker 269-857-4424 82 Mason St Saugatuck MI 49453 [email protected]
11072 Sierra Investment Company Rodrigo Valencia 269-337-8200 5049 Red Arrow Hwy Kalamazoo MI 49007 [email protected]
11073 Connor Riley 269-983-1116 11 Pleasant St Saint Joseph MI 49085 [email protected]
11075 Kim Architects, Inc. An Kim 517-482-9932 1015 Williamston Rd Lansing MI 48933 [email protected]
11079 Dept. of Neighborhood Development Sarah Russell 616-940-3380 722 Beechwood Dr East Grand Rapids MI 49506 [email protected]
11080 Three Tulips Café Jan Van Dousen 616-392-4629 249 W 11th St Holland MI 49424 [email protected]
11083 Hopedale State College John Williams 517-337-0990 1003 Albert Ave East Lansing MI 48823 [email protected]
11084 Cathy DeSantis 616-866-4882 78 Spring St Rockford MI 49341 [email protected]
11085 Edward Phillips 616-637-5408 39 Water St South Haven MI 49090 [email protected]
11087 Walker Investment Company Nancy Belanger 616-456-2710 4031 Barclay St Grand Rapids MI 49503 [email protected]
11088 Weston Community Parks Foundation Sam Kervin 616-454-3327 333 Pearl St Grand Rapids MI 49503 [email protected]
InvoiceNum ContractNum InvoiceDate InvoiceItem InvoiceAmt InvoicePaid
2011 3011 3/23/13 Schematic Plan ¤ 1,500.00 true
2012 3011 5/10/13 Planting Plan ¤ 2,500.00 true
2021 3012 2/25/13 Consultation ¤ 300.00 true
2031 3020 4/19/13 Schematic Plan ¤ 1,500.00 true
2032 3020 8/19/13 Landscape Planting ¤ 2,000.00 true
2033 3020 9/20/13 Lighting Plan ¤ 2,000.00 true
2034 3020 10/20/13 Permitting ¤ 1,000.00 true
2041 3015 4/1/13 Schematic Plan ¤ 1,500.00 true
2051 3017 4/1/13 Peer Plan Review ¤ 2,250.00 true
2061 3026 3/11/14 Schematic Open Space Plan ¤ 35,000.00 true
2062 3026 9/12/14 Permitting ¤ 10,000.00 false
2063 3026 7/11/15 Construction Documents ¤ 70,000.00 false
2064 3026 4/4/17 Construction Admin. & Observation ¤ 50,000.00 false
2071 3023 11/22/13 Schematic Open Space Plan ¤ 9,000.00 true
2072 3023 7/22/14 Planting Plan ¤ 20,000.00 true
2073 3023 9/21/15 Construction Observation ¤ 10,000.00 false
2081 3025 7/23/13 Schematic Plan ¤ 4,000.00 true
2082 3025 12/20/13 Construction Documents ¤ 8,000.00 true
2083 3025 6/24/14 Construction Observation ¤ 3,500.00 true
2091 3027 6/7/13 Schematic Plan ¤ 1,250.00 true
2101 3022 7/14/13 Schematic Plan ¤ 4,500.00 true
2102 3022 11/15/13 Construction Documents ¤ 12,000.00 true
2103 3022 7/14/14 Construction Observation ¤ 5,500.00 true
2111 3021 10/12/13 Schematic Landscape Plan ¤ 4,500.00 true
2112 3021 11/12/13 Permitting ¤ 3,000.00 true
2113 3021 9/2/14 Construction Documents ¤ 12,000.00 false
2114 3021 9/5/15 Construction Observation ¤ 8,500.00 false
2121 3034 9/28/13 Community Meetings ¤ 3,500.00 true
2122 3034 12/28/13 Schematic Design ¤ 5,500.00 true
2131 3035 10/18/13 Community Meetings ¤ 4,500.00 true
2132 3035 3/28/14 Schematic Design ¤ 6,000.00 true
2141 3031 2/3/14 Schematic Open Space Plan ¤ 7,500.00 true
2142 3031 6/3/14 Planting Plans ¤ 16,000.00 true
2143 3031 10/3/14 Layout Plans ¤ 16,000.00 false
2144 3031 8/3/15 Construction Observation ¤ 9,000.00 false
2151 3030 8/11/13 Schematic Plan ¤ 1,500.00 true
2152 3030 10/15/13 Construction Documents ¤ 2,250.00 true
2153 3030 3/30/14 Construction Observation ¤ 1,500.00 true
2161 3032 9/10/13 Schematic Plan ¤ 2,500.00 true
2162 3032 10/12/13 Planting Plan ¤ 2,500.00 true
2163 3032 11/12/13 Construction Details ¤ 1,500.00 true
2171 3037 2/22/14 Community Meetings & Coordination ¤ 8,000.00 true
2172 3037 6/22/14 Schematic Plan ¤ 15,000.00 true
2173 3037 2/24/15 Construction Documents ¤ 30,000.00 false
2174 3037 3/20/16 Construction Admin. & Observation ¤ 15,000.00 false
2181 3038 10/22/13 Community Meetings ¤ 3,000.00 true
2182 3038 12/22/13 Schematic Plan ¤ 8,000.00 true
2183 3038 6/23/14 Construction Documents ¤ 15,000.00 true
2184 3038 4/27/15 Construction Admin. & Observation ¤ 8,000.00 false
2191 3033 9/29/13 Schematic Plan ¤ 2,250.00 true
2201 3040 1/12/14 Schematic Landscape Plan ¤ 8,500.00 true
2202 3040 8/26/14 Construction Documents ¤ 18,000.00 false
2203 3040 9/17/15 Construction Admin. & Observation ¤ 12,000.00 false
2211 3043 1/11/14 Schematic Landscape Plan ¤ 5,500.00 true
2212 3043 6/20/14 Construction Documents ¤ 10,500.00 true
2213 3043 3/30/15 Construction Observation ¤ 3,000.00 false
2221 3044 6/17/14 Construction Documents ¤ 15,500.00 true
2222 3044 5/1/15 Construction Admin. & Observation ¤ 10,000.00 false
2231 3045 12/22/14 Schematic Plans ¤ 18,000.00 false
2232 3045 8/15/15 Community Meetings ¤ 7,000.00 false
2241 3050 10/18/13 Schematic Plan ¤ 1,000.00 true
2251 3046 9/9/13 Consultation ¤ 300.00 true
2261 3053 9/22/13 Consultation ¤ 375.00 true
2271 3048 12/28/13 Schematic Design ¤ 1,500.00 true
2272 3048 2/28/14 Permitting ¤ 1,000.00 true
2273 3048 6/30/14 Landscape Planting & Lighting Plan ¤ 3,500.00 true
2274 3048 9/26/14 Construction Observation ¤ 1,500.00 false
2281 3056 9/30/14 Construction Documents ¤ 20,000.00 false
2282 3056 8/14/15 Construction Admin. & Observation ¤ 12,500.00 false
2291 3057 1/31/14 Schematic Design ¤ 4,000.00 true
2292 3057 6/30/14 Construction Documents ¤ 8,000.00 true
2293 3057 3/30/15 Construction Observation ¤ 3,500.00 false
2301 3051 3/7/14 Schematic Landscape Plan ¤ 5,500.00 true
2302 3051 7/7/14 Construction Documents ¤ 9,000.00 true
2303 3051 5/3/15 Construction Observation ¤ 3,500.00 false
2311 3060 12/21/13 Schematic Plan ¤ 1,500.00 true
2312 3060 5/27/14 Planting & Materials Plan ¤ 2,500.00 true
2321 3061 6/28/14 Schematic Open Space Plan ¤ 6,000.00 true
2322 3061 10/26/14 Permitting ¤ 3,000.00 false
2323 3061 4/25/15 Construction Documents ¤ 15,000.00 false
2324 3061 6/27/16 Construction Observation ¤ 6,800.00 false
2331 3062 6/10/14 Schematic Landscape Plan ¤ 6,000.00 true
2332 3062 11/14/14 Construction Documents ¤ 10,000.00 false
2333 3062 5/11/15 Construction Observation ¤ 4,000.00 false
2341 3063 3/21/14 Schematic Plan ¤ 1,750.00 true
2351 3065 6/3/14 Community Meetings ¤ 4,000.00 true
2352 3065 12/5/14 Schematic Plan ¤ 9,500.00 false
2353 3065 8/3/15 Construction Documents ¤ 15,000.00 false
2354 3065 8/1/16 Construction Admin. & Observation ¤ 9,500.00 false
2361 3068 4/21/14 Schematic Plan ¤ 1,500.00 true
2362 3068 7/7/14 Planting & Materials Plan ¤ 3,000.00 true
2371 3069 6/9/14 Schematic Plan ¤ 3,750.00 true
2372 3069 7/29/14 Permitting ¤ 2,500.00 true
2373 3069 9/23/14 Planting Plan ¤ 7,000.00 false
2374 3069 10/24/14 Lighting Plans ¤ 2,500.00 false
2381 3070 9/6/14 Community Meetings ¤ 3,500.00 false
2382 3070 1/3/14 Schematic Plan ¤ 8,500.00 false
2383 3070 11/5/15 Construction Documents ¤ 14,000.00 false
2384 3070 7/8/16 Construction Observation ¤ 9,000.00 false
2391 3071 12/9/14 Schematic Plan ¤ 8,500.00 false
2392 3071 3/12/15 Community Meetings & Permitting ¤ 4,500.00 false
2393 3071 3/11/15 Construction Documents ¤ 14,000.00 false
2394 3071 3/27/17 Construction Observation ¤ 10,000.00 false
2401 3072 11/10/14 Schematic Plan ¤ 12,000.00 false
2402 3072 9/13/15 Construction Documents ¤ 30,000.00 false
2403 3072 9/26/16 Construction Admin. & Observation ¤ 15,000.00 false
2411 3075 7/8/14 Schematic Plan ¤ 5,000.00 true
2412 3075 4/9/15 Construction Documents ¤ 8,000.00 false
2413 3075 9/27/15 Construction Observation ¤ 3,500.00 false
2421 3076 6/8/14 Peer Plan Review ¤ 5,000.00 true
2431 3080 8/3/14 Schematic Design ¤ 6,000.00 true
2432 3080 9/14/14 Permitting ¤ 1,500.00 false
2433 3080 2/15/15 Planting Plan ¤ 13,000.00 false
2434 3080 8/15/15 Lighting Plans ¤ 2,300.00 false
2441 3078 6/24/14 Schematic Landscape Plan ¤ 3,750.00 true
2442 3078 10/24/14 Construction Documents ¤ 7,500.00 false
2443 3078 6/25/15 Construction Observation ¤ 2,500.00 false
2451 3073 9/5/15 Schematic Open Space & Landscape Plan ¤ 45,000.00 false
2452 3073 5/6/16 Community Meetings & Permitting ¤ 25,000.00 false
2453 3073 5/5/17 Construction Documents ¤ 85,000.00 false
2454 3073 8/18/18 Construction Admin. & Observation ¤ 50,000.00 false
2461 3081 10/11/14 Schematic Landscape Plan ¤ 4,500.00 false
2462 3081 5/10/15 Construction Documents ¤ 12,000.00 false
2463 3081 10/18/15 Construction Observation ¤ 4,500.00 false
2471 3077 8/23/14 Schematic Landscape Plan ¤ 6,500.00 true
2481 3082 8/1/14 Schematic Plan ¤ 2,500.00 true
2482 3082 10/21/14 Planting Plan ¤ 2,500.00 false
2491 3090 10/14/14 Community Meetings ¤ 2,000.00 false
2492 3090 2/16/15 Schematic Plan ¤ 5,500.00 false
2493 3090 11/16/15 Construction Documents ¤ 12,000.00 false
2494 3090 9/9/16 Construction Observation ¤ 6,000.00 false
2501 3085 2/23/15 Schematic Landscape Plan ¤ 10,500.00 false
2502 3085 10/23/15 Construction Documents ¤ 26,000.00 false
2503 3085 8/26/16 Construction Observation ¤ 16,000.00 false
2511 3095 8/25/14 Schematic Design ¤ 3,000.00 true
2512 3095 3/29/15 Construction Documents ¤ 7,000.00 false
2513 3095 4/30/16 Construction Observation ¤ 4,500.00 false
2521 3086 10/11/14 Schematic Landscape Plan ¤ 4,750.00 false
2522 3086 3/12/15 Construction Documents ¤ 8,500.00 false
2523 3086 10/4/15 Construction Observation ¤ 4,000.00 false
2531 3098 12/15/14 Schematic Landscape Plan ¤ 8,000.00 false
2532 3098 3/15/15 Community Meetings ¤ 2,000.00 false
2533 3098 1/15/16 Construction Documents ¤ 17,000.00 false
2534 3098 7/15/16 Construction Observation ¤ 8,000.00 false
2541 3093 8/25/14 Schematic Plan ¤ 2,000.00 true
2542 3093 2/27/15 Planting Plan ¤ 3,000.00 false
2551 3099 12/23/14 Schematic Landscape Design ¤ 6,500.00 false
2561 3094 8/25/14 Schematic Plan ¤ 2,000.00 true
2562 3094 3/23/15 Planting Plan ¤ 3,000.00 false
2571 3104 9/28/14 Schematic Plan ¤ 2,000.00 false
2572 3104 1/27/15 Planting & Materials Plan ¤ 3,500.00 false
2581 3097 10/3/14 Schematic Plan ¤ 2,000.00 false
2582 3097 12/2/14 Landscape Layout & Planting Plan ¤ 4,000.00 false
2583 3097 4/20/15 Construction Observation ¤ 2,500.00 false
2591 3108 1/6/15 Schematic Landscape Plan ¤ 12,000.00 false
2592 3108 4/13/15 Community Meetings ¤ 3,000.00 false
2593 3108 2/15/16 Construction Documents ¤ 25,000.00 false
2594 3108 3/31/17 Construction Observation ¤ 10,000.00 false
2601 3100 3/8/15 Schematic Landscape Design ¤ 10,500.00 false
2611 3103 8/17/15 Schematic Open Space & Landscape Plan ¤ 45,000.00 false
2612 3103 8/16/16 Community Meetings & Permitting ¤ 25,000.00 false
2613 3103 12/17/17 Construction Documents ¤ 105,000.00 false
2614 3103 9/30/19 Construction Admin. & Observation ¤ 77,000.00 false
2621 3109 4/18/15 Schematic Plan ¤ 8,000.00 false
2622 3109 10/18/15 Construction Documents ¤ 18,000.00 false
2623 3109 9/23/16 Construction Admin. & Observation ¤ 15,000.00 false
2631 3101 11/28/14 Schematic Plan ¤ 2,500.00 false
2632 3101 12/28/14 Permitting ¤ 1,500.00 false
2633 3101 3/14/15 Planting Plan ¤ 4,000.00 false
2634 3101 5/15/15 Lighting Plans ¤ 1,500.00 false
2641 3105 10/24/14 Schematic Plan ¤ 2,000.00 false
2642 3105 5/25/15 Planting Plan ¤ 3,000.00 false
2651 3110 12/23/14 Community Meetings ¤ 4,000.00 false
2652 3110 2/24/15 Schematic Plan ¤ 9,500.00 false
2653 3110 12/21/15 Construction Documents ¤ 15,000.00 false
2654 3110 5/1/17 Construction Admin. & Observation ¤ 9,500.00 false
SELECT DISTINCTROW * FROM Contract;
SELECT DISTINCTROW * FROM Contract;
SELECT Contract.[ContractNum], Contract.[ContractAmt], Contract.[ContractType] FROM Contract;