Display all employee names (last name and first name separated by a comma and a space) and salary with appropriate column aliases.
Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT LNAME || ', ' || FNAME "Employee Name", SALARY "Yearly Salary"
2 FROM EMPLOYEE;
Employee Name Yearly Salary
-------------------------------- -------------
Smith, John 265000
Houston, Larry 150000
Roberts, Sandi 75000
McCall, Alex 66500
Dev, Derek 80000
Shaw, Jinku 24500
Garner, Stanley 45000
Chen, Sunny 35000
8 rows selected.
```
You might also like to view...
VBA is an event-driven language.
Answer the following statement true (T) or false (F)
CD] Using JavaScript, add to article.xml’s root element
Form elements such as text boxes have ____ properties that you can use to set or retrieve the value entered into the field.
A. name B. text C. setting D. value
A keyword is recognized as part of the ____ definition.
A. language B. method C. property D. parameter