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.
```

Computer Science & Information Technology

You might also like to view...

Explain any constraints in using the top-down versus bottom-up approach in duration estimating.

What will be an ideal response?

Computer Science & Information Technology

A ________ is software that controls access to data in a database.

a) database management server b) structured query language c) database management system d) data manipulation language

Computer Science & Information Technology

In which layer are ongoing communications between a sender and a receiver set up, maintained, and then terminated, or torn down, as needed?

A. Session layer B. Physical layer C. Network layer D. Presentation layer

Computer Science & Information Technology

ASCII is a universally accepted text file format.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology