Display employee’s last name and first name, followed by salary+commission if commission is not null, else display salary only.
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT LName, FName, Salary + NVL(Commission, 0)
2 FROM employee;
LNAME FNAME SALARY+NVL(COMMISSION,0)
--------------- --------------- -----------------------------------
Smith John 300000
Houston Larry 160000
Roberts Sandi 75000
McCall Alex 66500
Dev Derek 100000
Shaw Jinku 27500
Garner Stanley 50000
Chen Sunny 35000
8 rows selected.
```
You might also like to view...
In a text box, the text can be ________ to make it appear sideways or upside down
Fill in the blank(s) with correct word
ITIL used the term best practices, which has morphed into ________ practices
Fill in the blank(s) with correct word