Mongodb group by having

#It's the equivalent of the following SQL instruction:
# SELECT COUNT(*) FROM Table
# GROUP BY your_field
# HAVING COUNT(*) > N
query = db.collection.aggregate([

    { 
      "$group": { "_id": "$your_field", #GROUP BY your_field
    			"count": {"$sum":1} }   #COUNT(*)
    },
    
    { "$match": { "count": { "$gt": N } } } #HAVING COUNT(*) > N
])

Similar codes

0 vote176 views1 answer
Xlabel not showing matplotlib
Python
3 votes204 views2 answers
Python element wise multiplication list
Python
5 votes191 views3 answers
How to make window pygame
Python
0 vote225 views1 answer
Element assignment numpy matrix
Python
1 vote186 views1 answer
Sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied.
Python
0 vote191 views1 answer
Python find closest date
Python
0 vote182 views1 answer
Pandas nat to null?
Python
0 vote184 views1 answer
Python get part of jason from string
Python
-1 vote284 views2 answers
How to declare tuple in python
Python
0 vote255 views2 answers
How to download a .xlsx file from google colab
Python