Select the score column and rename it to max_score.

Make sure to pick score, followed by AS, and finally max_score.