lsubmission = session.query(submissions.autor, func.sum(submissions.score).label("score")).group_by(submissions.autor).having(func.sum(submissions.score)>1000).order_by(func.sum(submissions.score).desc()).limit(100)
for lposts in lsubmission:
    print(lposts.autor, lposts.score)