Company: Media_Net_Product_Analysis
Difficulty: medium
Problem Description You are given a table Students containing student information and their test marks (out of 100). For students who missed the test, the Marks column contains the exact word 'Absent' . Write an SQL query to retrieve the students' names arranged according to the following sorting rules: Valid Marks First: Students with numeric marks must appear before absent students. Sort by Marks (Descending): Students with numeric marks must be ordered from highest to lowest score. Tie-Breaker for Marks: If multiple students have the same numeric score, sort them by their Name in ascending alphabetical order . Absent Students at the Bottom: Students who were 'Absent' must be placed at the very end of the output list. Sort Absent Students: Absent students must also be sorted amongst themselves by Name in ascending alphabetical order . Schema The Students table has the following schema: +-------+---------+ | Field | Type | +-------+---------+ | Id | INT | | Name | VARCHAR | | Marks |