Question

how to display the information of student with marks greater than 75?

Answer 1

Use if/else conditional statements or switch case.

Answer 2

SELECT First_Name, Last_Name, City from Student_Info_Table
WHERE Mark > 75
ORDER BY Last_Name;