基于学生工作管理系统的奖学金评定方案——以海口为例

SELECT student_id, AVG(score) AS avg_score, moral_score

FROM grades

WHERE year = '2023' AND department = 'Computer Science'

GROUP BY student_id;

]]>

def calculate_total_score(avg_score, moral_score):

return avg_score * 0.8 + moral_score * 0.2

# 示例调用

total_score = calculate_total_score(85.0, 90)

print("Total Score:", total_score)

]]>

import pandas as pd

data = {'student_id': [1001, 1002], 'total_score': [86.4, 87.2]}

df = pd.DataFrame(data)

sorted_df = df.sort_values(by='total_score', ascending=False)

print(sorted_df)

]]>