How to use Comparison Query Operators in MongoDB inside aggregation when joining multiple tables?

Mar 12, 2022 · 2 min read · 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...