TP6模型作业

1.查询平均成绩大于60分的同学的学号和平均成绩

public function getSc()
    {
        $result = Sc::field('sid,round(avg(score),2) as avg')
            ->group('sid')
            ->having('avg(score)>60')
            ->select()
            ->toArray();
        return $result;
    }

//调用Sc模型
 public function avgScore(){;
        $sc = new Sc();
        $result = $sc->getSc();
        dump($result);
    }

2.查询李姓老师的数量

 public function getCountTeacher(){
        $result = Teacher::whereLike('tname','李%')
            ->count();
        return $result;
    }

//调用Teacher模型
public function countTeacher(){
        $teacher = new Teacher();
        $result = $teacher->getCountTeacher();
        dump($result);
    }

3.查询所有同学的同学编号，学生姓名，选课总数，所有课程的总成绩

 public function getall(){