I ESPECIALLY need the queries to assign/update grades for SQL. Any help is appreciated

Write a function which takes marks as input and returns letter grade according to following grading classes 20 points] 100-87 86-80 79-70 69-60 59-0 Now, assume a table as student (ID, marks, grade). Write a query to assign/update grade of students based on their marks