yilvi的博客

问：已知student表有姓名-name,分数-grade,课程-course，它们多对多对多，一条sql语句查询每门课程都大于80分的学生姓名？①每门课程，涉及到课程数量统计SELECT COUNT(DISTINCT(s.course),s.course) courseCount FROM student s②课程大于80分的学生select s1.name,count(grade) from student s1 where s1.grade>80 group by s1.name③

目的：考察数组的下标定义，String类的常用方法public class Main { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); String s = scanner.nextLine(); System.out.println(recursion(s)); } static String recursion(