27. Grade Assignment The given table 'students' contains the total marks of a student in a class. The teacher of the cla

[answerhappygod]

27 Grade Assignment The Given Table Students Contains The Total Marks Of A Student In A Class The Teacher Of The Cla 1 (58.37 KiB) Viewed 78 times

27. Grade Assignment The given table 'students' contains the total marks of a student in a class. The teacher of the class wants to assign grades to the students with the following logic: • Greater > 90 A+ • Greater > 70 A • Greater > 50 B • Greater >= 40C • Less than 40 Fail Write an SQL query to achieve the same. Return ID, name, marks, grade for each student. Schema There is 1 table: students students Name Type Description id INTEGER This is the first column. It is the primary key. name VARCHAR Name of the student. marks INTEGER Total marks of the student Sample Data Tables students id name marks 26 1 Matt 44 2 N John 57 3 Lucas 78 28