Case Study Powerpoint
| providerID | CompanyName | Contact_FirstName | Contact_LastNAme | BillingAddress | City | State | ZipCode | AreaCode | PhoneNumber | YTDORDERS | PreferredProvider |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Best Buy | June | Hillary | 86731 | New York | NY | 32435 | 358 | 000-0000 | ¤ 4,676,000.00 | true |
| 2 | CDW | Jane | April | 87565 | Chigago | CH | 35543 | 353 | 457-3222 | ¤ 4,565.00 | true |
| 3 | CompUSa | Kelly | Betty | 4563 | Arizona | AR | 54665 | 345 | 006-7676 | ¤ 678,700.00 | false |
| 4 | Sony | Hudson | Jacobs | 46423 | Olando | OL | 34546 | 254 | 888-7649 | ¤ 574,213.00 | false |
| 5 | HP | Mary | Jane | 54456 | Florida | FL | 43546 | 576 | 986-8866 | ¤ 4,657.00 | false |
| 6 | SAMSUNG | Kevin | Song | 32456 | Georgia | Ge | 09868 | 345 | 675-7585 | ¤ 2,441,232.00 | true |
| 7 | APPLE | Vincent | Nelly | 62132 | Alaska | AL | 09877 | 453 | 876-5994 | ¤ 45,657.00 | true |
| 8 | MOTOROLA | John | weeland | 56354 | Michigan | Mi | 02145 | 457 | 777-5758 | ¤ 76,779.00 | false |
| 9 | PHILIPHS | Kennedy | Zinc | 85407 | Arizona | AR | 67768 | 787 | 665-6565 | ¤ 4,088,765.00 | false |
SELECT DISTINCTROW *
FROM ProviderInformationTable;
SELECT DISTINCTROW *
FROM ProviderInformationTable;
SELECT DISTINCTROW *
FROM ProviderInformationTable;