package com.jevon.service;

import com.jevon.model.Student;

import java.util.List;

/**
 * @author chen
 * @version 1.0
 * @date 2019/10/18 0018 15:16
 */
public interface StudentService {

    int insertBatch(List<Student> list);

    List<Student> selectBySchoolName(int analyseId , String schoolName);

    List<Student> selectByClassName(int analyseId , String schoolName ,String className);

    int selectCountByScore(int analyseId , String schoolName , double begin , double end);

    int selectCountBySchoolScore(int analyseId , String schoolName ,String className , double begin , double end);

    List<String> selectClassNameBySchool(int analyseId , String schoolName);

    Double selectMaxScore(int analyseId , String schoolName);

    Double selectMinScore(int analyseId , String schoolName);

    Double selectAvgScore(int analyseId , String schoolName);
    //众数
    Double selectModeNumber(int analyseId , String schoolName);
    //中位数
    Double selectMedian(int analyseId , String schoolName);
    //标准差
    Double selectStdev(int analyseId , String schoolName);
}