QueryWrapperCoach queryWrapper = new QueryWrapper; queryWrappereqadmin_id admingetAdminId; queryWrapperlastorder by case when work_status = true then 1 else 2 end SUBSTRCONVERTreal_name

QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("admin_id", admin.getAdminId()); queryWrapper.orderByAsc("SUBSTR(CONVERT(real_name USING gbk), 1, 1)");

queryWrapper.orderByDesc("CASE WHEN work_status IS NULL THEN 1 ELSE 0 END");

List coaches = coachMapper.selectList(queryWrapper);