Genius Badge Qualification

Problem Statement

Genius Badge Qualification A teacher has decided to felicitate intelligent students in a class by awarding them a "Genius" badge. A student gets the badge only when both of these conditions hold: the student's CGPA last year was strictly greater than 9 , and the student's CGPA this year is strictly greater than their CGPA last year (the student improved). Write a query to select the roll_number , student_name , and whether or not he/she will be getting a "Genius" badge. Arrange the final answer in increasing order of roll number. Table: student_record Column Type Description roll_number INTEGER Represents the unique id of a student student_name TEXT Represents the name of a student (two students may share a name) CGPA_lastyear REAL Represents the past year's CGPA of a student CGPA_thisyear REAL Represents this year's CGPA of a student (inferred -- the original table lists the CGPA columns as Int, but its own sample holds values such as 9.2 and 8.4, so they are stored as REAL numbers wi