Count with WHERE condition
I have the following T-SQL query :
SELECT year, COUNT(*) FROM publis
WHERE publisher LIKE ‘%Springer%’
I made this query :
db.publis.aggregate([{"$group" : {_id:"$year", count:{$sum:1}}}])
How can I include the WHERE …