EMPLOYEE_ID FIRST_NAME LAST_NAME CITY HIRE_DATE SAL DEPT_ID JOB_ID 100 Abdul Ale
ID: 3616274 • Letter: E
Question
EMPLOYEE_ID
FIRST_NAME
LAST_NAME
CITY
HIRE_DATE
SAL
DEPT_ID
JOB_ID
100
Abdul
Aleem
ISLD
19-Dec-97
20000
10
IT_PROG
150
Rasheed
Jaleel
LHR
14-Jan-97
30000
20
IT_PROG
200
Ali
Hassan
LHR
15-Mar-07
15000
30
IT_PROG
250
Aamir
Nazir
MUL
23-Jun-02
12000
40
ST_CLERCK
300
Badr
Deen
LHR
07-Aug-01
15000
50
ST_CLERCK
350
Fareed
Hassam
ISLD
11-Feb-99
20000
60
IT_PROG
400
Haashim
Ali
ISLD
13-Nov-09
40000
70
IT_PROG
450
Houd
Nawaz
ISLD
20-Dec-07
35000
80
IT_PROG
500
Isaam
Ahmad
ISLD
14-Apr-01
10000
90
M_CLER
DEPARTMENTS Table
DEPT_ID
DEPT_NAME
MANAGER_ID
LOCATION_ID
10
Administration
1
1500
20
Marketing
2
1800
30
Shipping
3
1600
40
IT
4
1700
50
Purchase
5
1400
60
Sales
6
1300
70
Accounts
7
1100
80
Admin
8
1900
90
Contracting
9
1700
Question No. 2 What will be the outputof the following querie in table form?
SELECT d.dept_id, d.dept_name, d.location_id,e.employee_id, e.sal
FROM Departments d, employees e
WHERE e.dept_id = d.dept_id ;
EMPLOYEE_ID
FIRST_NAME
LAST_NAME
CITY
HIRE_DATE
SAL
DEPT_ID
JOB_ID
100
Abdul
Aleem
ISLD
19-Dec-97
20000
10
IT_PROG
150
Rasheed
Jaleel
LHR
14-Jan-97
30000
20
IT_PROG
200
Ali
Hassan
LHR
15-Mar-07
15000
30
IT_PROG
250
Aamir
Nazir
MUL
23-Jun-02
12000
40
ST_CLERCK
300
Badr
Deen
LHR
07-Aug-01
15000
50
ST_CLERCK
350
Fareed
Hassam
ISLD
11-Feb-99
20000
60
IT_PROG
400
Haashim
Ali
ISLD
13-Nov-09
40000
70
IT_PROG
450
Houd
Nawaz
ISLD
20-Dec-07
35000
80
IT_PROG
500
Isaam
Ahmad
ISLD
14-Apr-01
10000
90
M_CLER