sqlite> select amount,area,name from gold where area = "The Hive" order by amount desc limit 15;
1133752.0|The Hive|a gigantic bee drone
630131.0|The Hive|a gigantic bee worker
572418.0|The Hive|a gigantic bee fighter
528376.0|The Hive|a gigantic bee worker
391026.0|The Hive|a gigantic bee worker
183424.0|The Hive|a gigantic bee fighter
96603.0|The Hive|a gigantic bee worker
85448.0|The Hive|a gigantic bee drone
43748.0|The Hive|a gigantic bee fighter
34820.0|The Hive|a gigantic bee drone
16700.0|The Hive|the princess bee
9086.0|The Hive|a gigantic bee drone
8255.0|The Hive|a gigantic bee drone
7500.0|The Hive|a gigantic bee guard
7500.0|The Hive|a gigantic bee guard
sqlite>
sqlite> select sum(amount) from gold where area = "The Hive";
3975799.0
sqlite>