How to use Comparison Query Operators in MongoDB inside aggregation when joining multiple tables?
I tried to convert this SQL Query below to a MongoDB One for my college project.
select E.* from Employee E, Employee S, Job J where E.salary >1000 and E.supervisorSSN = S.SSN and E.jobID = J.ID and J.maxSalary >E.salary;
After 3 hours of being st...
dinaalaaahmed.hashnode.dev2 min read