Need this done in Oracle, SQL DEVELOPER! expected outcome is shown.

10. List the student first name, last name, tuition balance for those registered students who have a balance of more than $9800.00. If the student has a balance equal to or more than 9900 then the message should be Nearing Limit. If the balance is between 9800 and less than 9900 then the message should be Approaching Limit. You'll need to use the CASE expression). List each student only once. Arrange the list by tuition balance descending order