Write SQL expressions

The Orion.staff is

4. Conditional Processing Create a report that displays Employee LD. Level, Salary, and Salary Range using the orion,staff table. Level and Salary Range are two new columns in the report. The report should also contain salary information for only the Orion Star executives. Conditionally, assign values to the two new columns as follows: Salary Ranges Job Title (Last Word) Level Medium High Low Manager Manager 52,000 52,000-72,000 72,000 Director Director