Python与sqlite简单习题及答案

第1部分 Python 1. 编程求一个数组的次大值、次小值、均值和中值。import mathstr=input(Please input list:)a=list(eval(str)print(a)max=a0secondmax=a0min=a0secondmin=a0for e in a: if(e=max): secondmax=max max=e elif max=secondmax: secondmax=e elif esecondmax: secondmax=efor e in a: if(e=min): secondmin=min min=e elif min=secondmin: secondmin=e elif esecondmin: secondmin=eavg=0for e in a: avg=avg+eavg=avg/len(a)meanvalue=a0for e in a: if math.fabs(e-avg)=1: print(repeatword0,repeatword1)3. 编程求以下算式中括号里的值：76( )5+( )47=( )21( )for a in range(0,10): for b in range(0,10): for c in range(0,10): for d in range(0,10): if (7605+a*10+b*100+47=210+c*1000+d): print(,a,b,c,d,)4. 编程求下列不定方程的根：X1+X2+X3+X4+X5=20, 其中：1=X1=6,0=X2=7,4=X3=8,2=X4=85 GROUP BY std_id HAVING COUNT(*)=3;); (6) 查询选了三门课并且平均成绩在85分以上的学生都选了哪些课（选作）。SELECT crs_id FROM xk WHERE stdid IN( SELECT * FROM student WHERE id IN( SELECT std_id FROM xk WHERE score=85 GROUP BY std_id HAVING COUNT(*)=3; );实验55-8:W=1,7,3,8,5,10,11,4list=exit=Falsedef Load(Total,n): global W global list global exit if exit=True: return True if Total=0: #print(list) exit=True return True if Total0 and n0 and n=1: if Total=W0: list.append(1) return True else: return False if Total0 and n1: no_nSelect=Load(Total,n-1) nSelect=Load(Total-Wn-1,n-1) if(no_nSelect=True): return True if(nSelect=True): list.append(n) return True return False if _n