I have one collection named users and second collection named videos. I want to perform left join with group by and having clause. I know how to do in mysql but not getting how to get it in Mongoose.
in mysql query can be like
"select u.id,u.masterid, count(v.vid) from users u left join videos v on u.id=v.uid group by u.id having u.masterid=1"
I have found few solutions related to group by or left join here but not with having clause. Any help is appreciated.
Thanks
