Company: Meesho_1aug
Difficulty: medium
Problem Description A teacher has decided to felicitate intelligent students in a class by awarding them a "Genius" badge. A student qualifies for a "Genius" badge if they meet both of the following conditions: Their CGPA last year was strictly greater than 9.0 . Their CGPA this year is strictly greater than their CGPA last year (i.e., they have shown improvement). Write a query to evaluate all students and determine whether or not each student will receive a "Genius" badge. Order the final results in ascending order by roll_number . Schema The input table is named student_record and has the following columns: roll_number (INT): Represents the unique identifier of a student. student_name (VARCHAR): Represents the name of the student. CGPA_lastyear (FLOAT/DECIMAL): Represents the student's CGPA from the previous year. CGPA_thisyear (FLOAT/DECIMAL): Represents the student's CGPA for the current year. Required Output The output should contain the following columns, returned in this exact