Find out the names and number of years worked along with their department names in descending order by number of years worked.
Use the NamanNavan (N2) Corporation database tables to design the following queries. (Use the spooling method to capture all queries and results in the CHAP7SP1.LST file.)
```
SQL> SELECT LNAME, FNAME, DEPTNAME, (SYSDATE-HIREDATE)/ 365 YEARS
2 FROM EMPLOYEE E, DEPT D
3 WHERE E.DEPTID = D.DEPTID
4 ORDER BY YEARS DESC;
LNAME FNAME DEPTNAME YEARS
--------------- --------------- ---------------- -------------
SMITH JOHN FINANCE 44.2244611
HOUSTON LARRY MARKETING 37.1285706
ROBERTS SANDI FINANCE 12.5724063
DEV DEREK INFOSYS 9.28747476
GARNER STANLEY SALES 8.32583092
MCCALL ALEX INFOSYS 7.13131038
CHEN SUNNY FINANCE 4.86555695
SHAW JINKU SALES 4.47925558
8 ROWS SELECTED.
```
You might also like to view...
________ is the standard internal drive interface used to connect drives to the motherboard
Fill in the blank(s) with correct word
Match the phishing attacks to their characteristics
Phishing Attacks Characteristics 6. Spoofing a. changing a Web site IP repeatedly without affecting the domain name 7. Floating windows b. redirecting users' network traffic to undesired sites 8. Botnets c. using company trademarks and logos in emails for online scams 9. Redirectors d. giving money to strangers who promise a larger sum in return 10. 419 fraud e. developing Javascript replicas that are variations of legitimate URLs