query
RESULTSET
query
  NUM PHONE_CARRIER
1 3090 Sprint Spectrum LP
2 1211 New Cingular Wireless PCS LLC - GA
3 1037 New Cingular Wireless PCS LLC - IL
4 757 New Cingular Wireless PCS LLC
5 654 T-Mobile USA Inc
6 582 Metro PCS Inc
7 438 New Cingular Wireless PCS LLC - DC
8 367 Cellco Partnership dba Verizon Wireless - CA
9 314 Cellco Partnership dba Verizon Wireless - FL
10 278 Cellco Partnership dba Verizon Wireless - NC
11 270 Aerial Communications Inc
12 235 Cellco Partnership dba Verizon Wireless - TX
13 183 Cellco Partnership dba Verizon Wireless - GA
14 174 Cellco Partnership dba Verizon Wireless - WA
15 165 Cellco Partnership dba Verizon Wireless - OH
16 158 Omnipoint Miami E License LLC
17 140 Cellco Partnership dba Verizon Wireless - NY
18 135 Cellco Partnership dba Verizon Wireless - VA
19 131 Cellco Partnership dba Verizon Wireless - TN
20 123 Cellco Partnership dba Verizon Wireless - SC
21 111 Cellco Partnership dba Verizon Wireless - PA
22 102 Cellco Partnership dba Verizon Wireless - NJ
23 102 Cellco Partnership dba Verizon Wireless - OR
24 95 SunCom dba T-Mobile USA
25 94 MetroPCS Networks LLC
26 93 Cellco Partnership dba Verizon Wireless - AL
27 90 Powertel Atlanta Licenses Inc
28 77 Cellco Partnership dba Verizon Wireless - IL
29 71 Cellco Partnership dba Verizon Wireless - MI
30 69 Cellco Partnership dba Verizon Wireless - CO
31 67 Cellco Partnership dba Verizon Wireless - MA
32 65 Cellco Partnership dba Verizon Wireless - NE
33 61 Omnipoint Communications Cap Operations LLC
34 57 Cellco Partnership dba Verizon Wireless - LA
35 56 Cellco Partnership dba Verizon Wireless - MD
36 56 Cellco Partnership dba Verizon Wireless - AZ
37 52 Cellco Partnership dba Verizon Wireless - IN
38 52 United States Cellular - WI
39 49 Cellco Partnership dba Verizon Wireless - MO
40 48 Cellco Partnership dba Verizon Wireless - CT
41 45 Cellular South Inc
42 45 Cellco Partnership dba Verizon Wireless - MN
43 41 Omnipoint Communications Inc - NY
44 39 United States Cellular - NC
45 38 United States Cellular - IA
46 37 Cellco Partnership dba Verizon Wireless - WI
47 34 Bell Atlantic NYNEX Mobile
48 31 Cellco Partnership dba Verizon Wireless - KS
49 30 Powertel Birmingham Licenses Inc
50 29 Cellco Partnership dba Verizon Wireless - MT
51 29 Cellco Partnership dba Verizon Wireless - UT
52 28 Omnipoint Communications Inc - NJ
53 28 Cellco Partnership dba Verizon Wireless - IA
54 27 Cellco Partnership dba Verizon Wireless - AR
55 27 Cellco Partnership dba Verizon Wireless - ND
56 27 Cellco Partnership dba Verizon Wireless - ID
57 25 Omnipoint Communications Enterprises LP
58 23 Cellco Partnership dba Verizon Wireless - KY
59 23 Powertel Nashville Licenses Inc
60 21 Cellco Partnership dba Verizon Wireless - DE
61 21 Omnipoint Communications Midwest Operations LLC
62 21 United States Cellular - IL
63 19 Sprint Spectrum LP - VA
64 18 Powertel Jacksonville Licenses Inc
65 18 Cellco Partnership dba Verizon Wireless - MS
66 16 United States Cellular - OK
67 16 Cellco Partnership dba Verizon Wireless - SD
68 16 United States Cellular - OR
69 15 Cellco Partnership dba Verizon Wireless - NV
70 15 Powertel Kentucky Licenses Inc
71 15 Cellco Partnership dba Verizon Wireless - NM
72 14 Eliska Wireless Ventures Subsidiary I LLC
73 11 Voicestream GSM I LLC
74 11 STPCS Joint Venture LLC
75 11 Cellco Partnership dba Verizon Wireless - OK
76 10 Powertel Memphis Licenses Inc
77 10 Omnipoint Communications Inc - CT
78 9 GCI Communication Corporation dba General Communication Inc
79 9 Sprint Spectrum LP - PA
80 8 USA Mobility Wireless Inc
81 8 United States Cellular - TN
82 8 United States Cellular - NE
83 6 New Cell dba Cellcom
84 6 United States Cellular - ME
85 6 Sprint Spectrum LP - WV
86 6 Cellco Partnership dba Verizon Wireless - VT
87 6 Cellco Partnership dba Verizon Wireless - WY
88 5 Southern Communications Services Inc
89 5 MTPCS LLC
90 4 United States Cellular - VA
91 4 United States Cellular - MO
92 4 Cellco Partnership dba Verizon Wireless - DC
93 4 Cellco Partnership dba Verizon Wireless - RI
94 4 D&E/Omnipoint Wireless Joint Venture LP dba PCS One
95 3 United States Cellular - NH
96 3 Cellco Partnership dba Verizon Wireless - WV
97 3 Sprint Spectrum LP - KY
98 3 United States Cellular - KS
99 3 Illinois Valley Cellular RSA 2-I Partnership
100 2 United States Cellular - TX
101 2 United States Cellular - CA
102 2 Washington RSA No. 8 Limited Partnership
103 2 Kentucky RSA 4 Cellular General Partnership
104 2 United States Cellular - WA
105 2 American Messaging Services LLC
106 2 Northwest Missouri Cellular Limited Partnership
107 1 N.E. Colorado Cellular Inc
108 1 SI Wireless LLC
109 1 Cellular Network Partnership
110 1 Nex-Tech Wireless LLC
111 1 Halo Wireless Inc
112 1 Gold Star Communications LLC
113 1 Brookings Municipal Utilities
114 1 USCOC of Cumberland Inc dba United States Cellular - MD
115 1 Limitless Mobile LLC
116 1 Cumberland Cellular Partnership
117 1 United States Cellular - WV
118 1 Metro Southwest PCS LLP
119 1 United Wireless Communications Inc
120 1 Buffalo-Lake Erie Wireless Systems Company LLC
121 1 Carolina West Wireless Inc
122 1 Digicel Cayman Limited
123 1 Sprint Spectrum LP - MD
124 1 Wisconsin RSA #10 Limited Partnership
CACHED false
EXECUTIONTIME 343
SQL select phone_carrier, COUNT(*) as num FROM businessleads WHERE phone_type LIKE "C" GROUP BY phone_carrier ORDER BY count(*) DESC