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
Explanation / Answer
Output from the query 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 ; dept_id dept_name location_id employee_id sal 10 Administration 1500 100 20000 20 Marketing 1800 150 30000 30 Shiping 1600 200 15000 40 IT 1700 250 12000 50 Purchase 1400 300 15000 60 Sales 1300 350 20000 70 Accounts 1100 400 40000 80 Admin 1900 450 35000 90 Contracting 1700 500 10000Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.