Database

public class Teacher
{
        public string Id{ get; set; }
        public string Name{ get; set; }
        public string TeacherFilter{ get; set; }
        ...
}

public class Student
{
        public string Id{ get; set; }
        public string Name{ get; set; }
        public string StudentFilter{ get; set; }
        public string TeacherId{ get; set; }
        ...
}

public class TeacherStudents
{
        public string Id{ get; set; } -- from teacher
        public string Name{ get; set; } -- from teacher
        public IEnumerable<Student> Students{get;set;}
}

public class TeacherStudents
{
        public string Id{ get; set; } -- from teacher
        public string Name{ get; set; } -- from teacher
        public IEnumerable<Student> Student{get;set;}
}

public class TeacherStudent
{
        public string Id{ get; set; } -- from teacher
        public string Name{ get; set; } -- from teacher
        ...
        public Student Student{get;set;}
}

Get(string TeacherFilter,string StudentFilter).

var query = teacherCollection.Aggregate().Match(x => x.TeacherFilter== TeacherFilter); //filter teach
var query1 = query
.Lookup<Teacher, Student, TeacherStudent>(studentCollection, t => t.Id, s => s.TeacherId, l => l.Student)
.Unwind(x => x.Student, new AggregateUnwindOptions<TeacherStudent>())
.Match(x => x.StudentFilter== StudentFilter) //filter student   

mysql> SELECT username,score,level, FIND_IN_SET(score,(SELECT GROUP_CONCAT(score ORDER BY score ASC)FROM highscore WHERE game = 0 AND level = 4 AND user = 10 )) AS rank FROM highscore WHERE game = 0 AND level = 4 AND user = 1 ORDER BY rank LIMIT 10;

SELECT datname FROM pg_database  WHERE datistemplate = false

mydb1
mydb2
postgres