Who can help me with a SQL program script. Requirements, the scores of the columns of STU_SCORE can be made 59 points, and the number of points in the score segments of 60-69, 70-79, 80-100 is statistically, respectively. And save the number of each scallet, stored in another data table, and STU_SCORE1 only one line! The first column is the number of people below 59, and the second column is the number of people in 60-69, and the number of people in the 80-100 score! !
Ask the master to point out! ! Thank you! !
