数值计算 score1,score2,score3=input().split(" ") total_score=float(score1)+float(score2)+float(score3) avg_score=total_score/3 print("{:.2f} {:.2f}".format(total_score,avg_score))

数值计算 time=input() hour=int(time)//3600 minute=int(time)//60-hour*60 second=int(time)%60 print("{} {} {}".format(hour,minute,second))

两次split获取ab值，换位输出 line=input() list=line.split(",") a=list[0].split("=")[1] b=list[1].split("=")[1] print("a={},b={}".format(b,a))

字符串截取 birth=input() print("year={}\nmonth={:02d}\ndate={:02d}".format(birth[:4],int(birth[4:6]),int(birth[-2:])))

chr(int())取ASCII转换字符 line="73,32,99,97,110,32,100,111,32,105,116,33" for i in line.split(","): print(chr(int(i)),end="")

固定行数遍历输出字符 def tri_pyramid(char): for i in range(1,6): print(" "*(5-i),end="") print((char+" ")*i,end="") print() char=input() tri_pyramid(char)

re.split拆分输入字符，round取四舍五入 import re line=input() list=re.split("[;,]",line) score1=round(float(list[1])+0.0001,2) score2=round(float(list[2])+0.0001,2) score3=round(float(list[3])+0.0001,2) print("The each subject score of No. {} is {:.2f}, {:.2f}, {:.2f}.".format(list[0],score1,score2,score3))

双重select聚合函数取max select a.emp_no,b.salary,a.last_name,a.first_name from employees a,salaries b where a.emp_no=b.emp_no and b.salary=( select max(salary) from salaries where salary not in ( select max(salary) from salaries ) );

device_id去重，模糊匹配日期，2个字段聚合count select count(distinct device_id去重，模糊匹配日期，2个字段聚合count) as did_cnt,count(question_id) as question_cnt from question_practice_detail where date like '2021-08-%';