MySQL : Student With Highest And Lowest marks

Database

Environment Specifications & Instructions

Type of Database

MySQL

Database Name to be used

StudentData

Problem Statement

Write an SQL query to find the name of the student with their highest and lowest scores.

The result should be in the increasing order of student$\_$name.

Column Name: student$\_$name, highest$\_$marks, lowest$\_$marks

Table Description:

students