mysql - 我想将简单的 SQL 查询转换为 mongo 查询

Question

1. 询问：

Select quiz_name, qty, count, report FROM quizzes INNER JOIN reports ON quizzes.id=reports.quiz_id  WHERE reports.report IS NOT NULL

2. 询问：

Select username,question,report_desc FROM reports INNER JOIN question ON reports.questoion_id quesitons.id INNER JOIN users ON reports.user_id = users.id INNER JOIN quizzes ON reports.quiz_id=quizzes.id Where quizzes.id = 123

问题是我不知道如何应用存在的聚合查找以及如何使用存在的字段查找第三级是真的，

标签： mysqlmongodbaggregation-frameworknosql-aggregation