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

-1 vote260 views1 answer
How to convert pandas series to 2d numpy array
Python
0 vote265 views1 answer
TypeError: add() got an unexpected keyword argument 'kernel_regularizer'
Python
0 vote301 views10 answers
Sqlite3 with flask web application CRUD pdf
Python Flask
1 vote263 views1 answer
Extract image from pdf python
Python
0 vote280 views1 answer
How to check if object is of file type in python3
Python
3 votes276 views2 answers
How to change cursor on hover of button in tkinter
Python
1 vote258 views1 answer
Python find smallest value in 2d list
Python
0 vote309 views1 answer
Fastest clicker python
Python
0 vote278 views1 answer
Python input timeout
Python
0 vote342 views1 answer
Dev.to flask heroku
Python Flask