can you please solve the question ?

2) For the EMPLOYEE table, write a query that uses searched CASE to determine a bonus for each employee according to the following rules: (5 points) w If the salary is less or equal 25000, the bonus is 10% of the salary If the salary is less or equal 40000, the bonus is 15% of the salary Otherwise, the bonus is 20% of the salary That is, your query should display the following output: ENAME LNAME Bonus($) James 11000 6000 4500 8600 Franklin John Jennifer Alicia Ramesh Joyce Ahmad Borg Wong Smith Wallace Zelaya Narayan English Jabbar 2500 5700 2500 2500 Insert here your query