database SQL query need in 3 hours
moh333moh
BITSDatabase.accdb| ClientNum | ClientName | City | State | ZipCode | Balance | CreditLimit | ConsltNum | Street |
|---|---|---|---|---|---|---|---|---|
| 143 | Hershey, Jarrod | Easton | FL | 33998 | ¤ 1,904.55 | ¤ 2,500.00 | 19 | 135 E. Mill Street |
| 175 | Goduto, Sean | Tri City | FL | 32889 | ¤ 2,814.55 | ¤ 5,000.00 | 19 | 12 Saratoga Parkway |
| 299 | Two Crafty Cousins | Sunland | FL | 39876 | ¤ 8,354.00 | ¤ 10,000.00 | 22 | 9787 NCR 350 West |
| 322 | Prichard's Pizza & Pasta | Lizton | FL | 34344 | ¤ 7,335.55 | ¤ 10,000.00 | 35 | 501 Air Parkway |
| 363 | Salazar, Jason | Easton | FL | 33998 | ¤ 900.75 | ¤ 2,500.00 | 35 | 56473 Cherry Tree Dr. |
| 405 | Fisherman's Spot Shop | Harpersburg | FL | 31234 | ¤ 4,113.40 | ¤ 7,500.00 | 19 | 49 Elwood Ave. |
| 449 | Seymour, Lindsey | Amo | FL | 34466 | ¤ 557.70 | ¤ 5,000.00 | 22 | 4091 Brentwood Ln |
| 458 | Bonnie's Beautiful Boutique | Tri City | FL | 32889 | ¤ 4,053.80 | ¤ 7,500.00 | 22 | 9565 Ridge Rd. |
| 677 | Yates, Nick | Sunland | FL | 39876 | ¤ 2,523.80 | ¤ 2,500.00 | 35 | 231 Day Rd. |
| 733 | Howler, Laura | Lizton | FL | 34344 | ¤ 3,658.05 | ¤ 5,000.00 | 22 | 1368 E. 1000 S. |
| 826 | Harpersburg Bank | Harpersburg | FL | 31234 | ¤ 6,824.55 | ¤ 10,000.00 | 19 | 65 Forrest Blvd. |
| 867 | MarketPoint Sales | Easton | FL | 33998 | ¤ 3,089.00 | ¤ 5,000.00 | 19 | 826 Host St. |
| ConsltNum | LastName | FirstName | Street | City | State | ZipCode | Hours | Rate |
|---|---|---|---|---|---|---|---|---|
| 19 | Turner | Christopher | 554 Brown Dr. | Tri City | FL | 32889 | 40 | ¤ 22.50 |
| 22 | Jordan | Patrick | 2287 Port Rd. | Easton | FL | 33998 | 40 | ¤ 22.50 |
| 35 | Allen | Sarah | 82 Elliott St. | Lizton | FL | 34344 | 35 | ¤ 20.00 |
| 51 | Shields | Tom | 373 Lincoln Ln. | Sunland | FL | 39876 | 10 | ¤ 15.00 |
| OrderNum | TaskID | ScheduledDate | QuotedPrice |
|---|---|---|---|
| 67101 | SI77 | 9/10/18 | ¤ 144.00 |
| 67313 | LA81 | 9/12/18 | ¤ 104.00 |
| 67424 | MO49 | 9/14/18 | ¤ 65.00 |
| 67424 | UP38 | 9/14/18 | ¤ 185.00 |
| 67838 | LA81 | 9/20/18 | ¤ 104.00 |
| 67949 | PI54 | 9/21/18 | ¤ 50.00 |
| 67949 | VR39 | 9/21/18 | ¤ 88.00 |
| 67949 | WA33 | 9/21/18 | ¤ 126.00 |
| 68252 | DI85 | 9/24/18 | ¤ 50.00 |
| 68868 | SA44 | 9/24/18 | ¤ 200.00 |
| 68979 | AC65 | 9/27/18 | ¤ 77.00 |
| 68979 | DA11 | 9/27/18 | ¤ 970.00 |
| TaskID | Description | Category | Price |
|---|---|---|---|
| AC65 | Accessories | ACC | ¤ 80.00 |
| DA11 | Data recovery major | DRM | ¤ 175.00 |
| DI85 | Data recovery minor | DRM | ¤ 50.00 |
| HA63 | Hardware major | HAM | ¤ 225.00 |
| HI31 | Hardware minor | HAM | ¤ 165.00 |
| LA81 | Local area networking (LAN) | LAN | ¤ 104.00 |
| MO49 | Mobility | MOB | ¤ 65.00 |
| PI54 | Printing issues | PRI | ¤ 50.00 |
| SA44 | Software major | SOM | ¤ 200.00 |
| SI77 | Software minor | SOM | ¤ 144.00 |
| SI91 | Security install/repair | SIR | ¤ 126.00 |
| UP38 | Upgrades | UPG | ¤ 185.00 |
| VR39 | Virus removal | VIR | ¤ 90.00 |
| WA33 | Wide area networking (WAN) | WAN | ¤ 130.00 |
| WC19 | Web connectivity | WEC | ¤ 75.00 |
| OT99 | Other work | OTH | ¤ 99.99 |
| OrderNum | OrderDate | ClientNum |
|---|---|---|
| 67101 | 9/6/18 | 733 |
| 67313 | 9/7/18 | 458 |
| 67424 | 9/10/18 | 322 |
| 67838 | 9/10/18 | 867 |
| 67949 | 9/10/18 | 322 |
| 68252 | 9/12/18 | 363 |
| 68868 | 9/14/18 | 867 |
| 68979 | 9/17/18 | 826 |
