Grouping MYSQL query results base on sum of data in multiple column
I have a table with 10 columns (stdID, stdName, score1, score2..... Score8). The table has more than 100 student record (stdID) with different scores (score1.... score8). What I want is to make a query that will fetch all the students…