SQL Example : (Edit SQL Statement correctly and Run query for result.)

Result:

Results:

DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID
10 Administration 200 1700
20 Marketing 201 1800
30 Purchasing 114 1700
40 Human Resources 203 2400
50 Shipping 121 1500
60 IT 103 1400
70 Public Relations 204 2700
80 Sales 145 2500
90 Executive 100 1700
100 Finance 108 1700
110 Accounting 205 1700
120 Treasury   1700
130 Corporate Tax   1700
140 Control And Credit   1700
150 Shareholder Services   1700
160 Benefits   1700
170 Manufacturing   1700
180 Construction   1700
190 Contracting   1700
200 Operations   1700
210 IT Support   1700
220 NOC   1700
230 IT Helpdesk   1700
240 Government Sales   1700
250 Retail Sales   1700
260 Recruiting   1700
270 Payroll   1700

27 rows selected.