sqlite> select sum(downloads) from fakeapps;
3339953

sqlite> select category, sum(downloads) from fakeapps group by category;
Books   160864
Business        178726
Catalogs        186158
Education       184724
Entertainment   95168
Finance 178163
Food & Drink    90950
Games   256083
Health & Fitness        165555
Lifestyle       166832
Medical 77191
Music   59367
Navigation      152114
News    103259
Photo & Video   184848
Productivity    135004
Reference       162032
Social Networking       126549
Sports  176988
Travel  242116
Utilities       96099
Weather 161163