Display employee’s full name followed by a message based on salary. If salary is above $100,000, display “HIGH”. If salary is between $50,000 and $100,000, display “MEDIUM”. If salary is below $50,000, display “LOW”.
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT LName, FName,
2 CASE WHEN Salary > 100000 THEN 'HIGH'
3 WHEN Salary >= 50000 THEN 'MEDIUM'
4 ELSE 'LOW'
5 END
6* FROM employee
SQL> /
LNAME FNAME CASEWH
--------------- --------------- ----------
Smith John HIGH
Houston Larry HIGH
Roberts Sandi MEDIUM
McCall Alex MEDIUM
Dev Derek MEDIUM
Shaw Jinku LOW
Garner Stanley LOW
Chen Sunny LOW
8 rows selected.
```
You might also like to view...
The fact that a stack can consist of a stack of floats, a stack of ints, a stack of objects, a stack of strings, etc., illustrates:
A. how class templates can come in handy for data structures B. that stacks need overloaded operator functions C. abstraction D. that a push or pop might not work for every situation
What is wrong with this call statement? Print Name(string name);
A. It’s missing “void”. B. The datatype should be removed. C. The semicolon should be removed. D. Nothing is wrong with it.
When creating a menu, typing a _______ in front of a menu item name will create an access shortcut for that item.
a) & b) ! c) $ d) #
Which of the following will allow certain ports to be part of the same group while other ports within that switch are part of a different group?
A. Trunking B. Port authentication C. Enabling VLANs D. Enabling VTP