Display all employee names (last name and first name separated by a comma and a space) with proper case, and salary with currency format.

Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)

```
SQL> SELECT INITCAP(LName) || ', ' || INITCAP(FName),
2 TO_CHAR(Salary, '$999,999')
3 FROM employee;

INITCAP(LNAME)||','||INITCAP(FNA TO_CHAR(S
-------------------------------- ---------
Smith, John $265,000
Houston, Larry $150,000
Roberts, Sandi $75,000
Mccall, Alex $66,500
Dev, Derek $80,000
Shaw, Jinku $24,500
Garner, Stanley $45,000
Chen, Sunny $35,000

8 rows selected.
```