第一题我的答案:
SELECT
temp.st_id AS st_id,
temp.st_name AS st_name
FROM
(
SELECT
st_name,
st_id,
sum( score ) AS sumSorce,
strftime ( '%s', max( start_time ) ) - strftime ( '%s', min( start_time ) ) AS user_time
FROM
S
GROUP BY
st_name,
st_id
) temp
ORDER BY
sumSorce DESC,
user_time
LIMIT 1
第二题答案:
public class Main {
public static void main(String[] args) {
Scanner scan=new Scanner(System.in);
String lines=scan.nextLine();
String[] arr=lines.split(",");
for(int i=0;i<arr.length;i++){
arr[i]=arr[i].trim();
}
long result=0;
StringBuffer sb=new StringBuffer();
for(int i=0;i<arr.length;i++){
for(int j=0;j<arr.length;j++){
if(Long.parseLong(arr[i])+Long.parseLong(arr[j])==0 && sb.indexOf(j+"")==-1 && sb.indexOf(i+"")==-1){
sb.append(i+"&"+j);
result++;
}
}
}
System.out.println(result);
/* for(String str:arr){
System.out.println(str);
}*/
}
}