Refer the below listed schema diagram to develop the SQL query to display the names of all students who have secured more than 50 in all subjects that they have appeared in, ordered by student name in...

Extracted text: Refer the below listed schema diagram to develop the SQL query to display the names of all students who have secured more than 50 in all subjects that they have appeared in, ordered by student name in ascending order. College Management System(CMS) Department Student department_id number - PK department_name varchar(30) department_block_number number student_id number --> PK student_name varchar(30) address varchar(40) city varchar(30) department_id number --> FK PK-- Primary Key FK- Foreign Key Subject Staff staff_id number -> PK staff_name varchar(30) department_id number-> FK subject_id number-->PK subject_name varchar(30) subject_code varchar(10) staff_id number --> FK Mark value number subject_id number- PKFK student_id number-->PK,FK