Create a PL/SQL block to satisfy the following criteria.

a. Create an inline (SQL Workshop Output) report using PL/SQL to display the following information for employee with employee id 169 with the following note next to their identifying information based on their salary for a 2021 Salary Update.

i. employees making > 500,000 -> display a message that says - "Due to Covid-19, your annual salary is reduced by 10% for the remainder of the year"

ii. employees making more than 200,000 -> display a message that says "Due to Covid-19, your annual salary is reduced by 5% for the remainder of the year"

iii. employees making under 200,000 -> display a message that reads "The firm is ensuring that employees in the lowest tier of salaries in the firm do not suffer any reductions in salary due to the Covid-19 pandemic"

Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.