SQL示例: SELECT * FROM teacher_salary WHERE teacher_year=3 ORDER BY salary DESC;
Python示例: import pandas as pd df = pd.read_csv('teacher_salary.csv') df = df[df['teacher_year']==3] df = df.sort_values(by='salary', ascending=False)
下一篇:按工作区和月份查询活跃员工人数。