import Select from "../../server/db/select";

const sql = "SELECT team_name, training_institution_team, name_team_coach, nominations, name_first_participant, name_second_participant,age_groups.name as classTeam, reg_time_add FROM members, age_groups WHERE ROUND((first_partial_class + second_class)/2) <= age_groups.class_max and ROUND((first_partial_class + second_class)/2) >= age_groups.class_min and compData='2023-05-27' ORDER BY reg_time_add DESC"; 

// eslint-disable-next-line @typescript-eslint/explicit-module-boundary-types
export default function handler(req, res)  {
    Select(sql, function(data){
        res.status(200).json(data);
    })
}