Sample Table For Examples

This section lists the sample tables used across examples in the subsequent SQL functions sections.

Table 1. VIRTUAL TABLE - EMPL_COMP
EMPL_ID EMPL_NAME COMPANY LOCATION UPDATED_TS
1 AKHIL TIMBER INC. NY

2019-11-26

05:39:59.454707
2 ELICA STANLEY INC. TX  
3 SMITH CHROME INC. WA  
1919574970 KANE      
Table 2. VIRTUAL TABLE - EMPLOYEE
EMPL_NAME AGE DEPT INDUSTRY SALARY DATEOFJOIN
BUMRAH 53 SALES RETAIL 50000 2019-11-25
CEASAR 43 MARKETING RETAIL 20000  
ELICA 23 CUST SUPR RETAIL 5000 2019-10-10
DEV 33 ADMIN RETAIL 25000 2019-11-27
NEWTON 53 DATA RETAIL 75000 2019-11-25
SAMUEL 43 IT BANKING 75000 2019-11-25
ELICA          
Table 3. Virtual Table - EMP
EMPL_NAME AGE DEPT INDUSTRY SALARY DATEOFJOIN
DEV 33 ADMIN RETAIL 25000 2019-11-27
WAYNE 36 ADMIN RETAIL 45000 2018-11-01
Table 4. Virtual Table - JOIN1
ID NAME DEPT JOB YEARS SALARY COMM
999 JOHN   SALES   16.99  
10 MIC 20 MGR 7 98357 0.00
20 WILLIAM 20 SALES 8 78171 612.45
30 MIC 38 MGR 5 77506 0.00
40 OBRIEN 38 SALES 6 78006 846.55
Table 5. Virtual Table - JOIN2
ID NAME DEPT JOB YEARS SALARY COMM
0 SANDERS 20 MGR 7 18357  
1 WILLIAM 20 SALES 8 18171 612.45