mysql> select c.client_id, c.client_nm, sum(b.b_total)/1073741824
from bandwidth b, client c where b.date>'2010-12-14' and b.client_id=c.client_id
group by b.client_id;

+-----------+------------------------------------+---------------------------+
| client_id | client_nm                          | sum(b.b_total)/1073741824 |
+-----------+------------------------------------+---------------------------+
|         1 | error                              |                    0.1533 |
|         3 | acore                              |                    5.8731 |
|         5 | altvnetwork                        |                    0.0001 |
|         7 | amber_ready                        |                    0.0000 |
|         8 | american_botanical                 |                    0.1499 |
|        10 | b_productions                      |                    0.2078 |
|        18 | broadwayworld                      |                    0.0001 |
|        19 | buglisi                            |                    0.0587 |
|        21 | caedmon                            |                    0.3991 |
|        26 | chicks_with_flicks                 |                    0.0001 |
|        30 | con-edison                         |                   22.0894 |
|        32 | cornerstone                        |                    1.2215 |
|        33 | cpg                                |                    0.0836 |
|        38 | dlf                                |                    0.0567 |
|        40 | eventhorizon                       |                    0.0039 |
|        41 | eventhorizons                      |                    0.3643 |
|        44 | flickeralley                       |                    0.0000 |
|        46 | freaks                             |                    0.0000 |
|        57 | hotel_belair                       |                    0.0000 |
|        62 | kenneth_cole                       |                    1.0398 |
|        64 | koch                               |                    0.0044 |
|        73 | marc_bouwer                        |                    0.0008 |
|        74 | michael_kors                       |                   10.9966 |
|        75 | moma                               |                    0.0108 |
|        76 | mta                                |                    0.0009 |
|        80 | new_filmmakers                     |                    0.0005 |
|        82 | nma                                |                    0.0000 |
|        88 | perez_hilton                       |                    0.0000 |
|        91 | phillips_de_pury                   |                    0.0000 |
|        92 | phillupsdepury                     |                    0.1481 |
|        97 | praetorian                         |                    0.0001 |
|        99 | risingstock                        |                    1.8983 |
|       105 | showcase                           |                    0.0002 |
|       109 | sullivan_hall                      |                    0.0021 |
|       110 | teachers_college                   |                    0.1165 |
|       114 | tight_media                        |                    0.0000 |
|       117 | toshi                              |                    0.0119 |
|       119 | tvhorsesource                      |                    2.4932 |
|       123 | webcast                            |                    0.1031 |
|       127 | yankelovich                        |                    1.6538 |
|       130 | zb_projects                        |                    0.2111 |
|       131 | zeitbyte                           |                   20.3386 |
|       135 | vivienne-tam                       |                    0.0003 |
|       138 | academy-of-art                     |                    0.0001 |
|       139 | isaac_mizrahi                      |                    0.0082 |
|       141 | zeitbyte-video-production          |                    0.7868 |
|       144 | gangaji                            |                    7.4157 |
|       156 | art-dealers-association-of-america |                    1.4111 |
|       157 | fgi-research                       |                    0.0139 |
|       161 | outmusic                           |                    1.2758 |
|       162 | applebees                          |                    0.0000 |
|       164 | hidrock                            |                    0.0518 |
|       166 | the-well                           |                    4.4787 |
|       168 | goldberger                         |                    0.0115 |
|       171 | alexander-wang                     |                    0.0000 |
|       173 | perry-ellis                        |                    3.7183 |
|       175 | tommy-hilfiger                     |                    4.0730 |
|       177 | mount-sinai                        |                    0.1331 |
|       179 | ports-1961                         |                    0.0267 |
|       180 | first-comes-fashion                |                    4.5684 |
|       181 | proenza-schouler                   |                   11.9084 |
|       182 | nobel-womens-iniative              |                    0.0002 |
|       183 | mhtco                              |                    0.7874 |
|       184 | nondor-nevai                       |                    0.3996 |
|       187 | neiman-marcus                      |                    0.4421 |
|       191 | mpi                                |                    0.1112 |
|       193 | slifter                            |                    0.0000 |
|       194 | ogilvy                             |                    0.6376 |
|       198 | iacono-productions                 |                    0.0000 |
|       199 | ap                                 |                    0.0001 |
|       200 | ti                                 |                    0.0719 |
|       203 | interchurch-center                 |                    0.0178 |
|       205 | e1-entertainment                   |                    0.6301 |
|       206 | weill-cornell                      |                    0.0799 |
|       207 | tdk                                |                  273.4851 |
|       213 | hmi-hypnosis-motivation-institue   |                  503.7212 |
|       214 | longaberger                        |                    0.1932 |
|       215 | jones-lang-lasalle                 |                    0.1596 |
|       220 | milk-studios                       |                    5.6109 |
|       222 | bcbg                               |                    0.0001 |
|       224 | lincoln-center                     |                    1.7501 |
|       225 | derek-lam                          |                    0.2065 |
|       226 | nanette-lepore                     |                    0.4349 |
|       227 | elle                               |                    0.0002 |
|       228 | 3.1-phillip-lim                    |                    0.0000 |
|       230 | simon-spurr                        |                    0.0009 |
|       234 | carmen-marc-valvo                  |                    0.0496 |
|       235 | jason-wu                           |                    0.0000 |
|       237 | neiman-marcus-jason-wu             |                    0.0713 |
|       238 | ports_1961                         |                    0.0000 |
|       240 | betsey-johnson                     |                    0.5095 |
|       241 | odd-molly                          |                  387.0650 |
|       242 | bagdley-mishka                     |                    0.0000 |
|       243 | matthew-ames                       |                    0.0000 |
|       245 | davidelfin                         |                   33.3354 |
|       247 | banana-republic                    |                    9.5162 |
|       248 | adrenalina                         |                   15.8411 |
|       249 | my-family-tv                       |                   57.4071 |
|       251 | natap                              |                    0.2141 |
|       252 | rachael-ray                        |                    0.0004 |
|       253 | sine-audio                         |                    3.9414 |
|       254 | summit-business-media              |                    0.0065 |
|       256 | production-glue                    |                   11.5643 |
|       257 | appnexus                           |                    1.8750 |
|       258 | release-3.0-test                   |                    0.0000 |
+-----------+------------------------------------+---------------------------+
105 rows in set (0.00 sec)