Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. db.crimes.aggregate([
  2. { $match: {"CrimeLSOAName":/.*Bradford.*/} },
  3. {
  4. $group: {
  5. "_id": "$CrimeType",
  6. "count": {
  7. $sum: 1
  8. }
  9. }
  10. },
  11. {
  12. $sort: {
  13. "count": -1
  14. }
  15. },
  16. {
  17. $limit: 10
  18. }
  19. ])
  20.  
  21. $top10Crimes = array(
  22. array('$match') => array('CrimeLSOAName:/.*Bradford.*/'),
  23. array(('$group') => array('_id' => '$CrimeType',
  24. 'count' => '$sum: 1')),
  25. array('$sort') => array('count' => '-1')
  26. array('$limit' => '10')
  27. );
  28.  
  29. $result = $collection->aggregate($top10Crimes);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement