[!INCLUDESQL Server] You can use the results of one query as the input for another. You can use the results of a subquery as a statement that uses the IN( ) function, the EXISTS operator, or the FROM ...
-- The subquery (math_score + science_score + english_score) calculates the total score for each student. This result is then used in the main query to order the students by their total score and ...