Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you help me with this EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH MANAGER 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698

can you help me with this
image text in transcribed
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH MANAGER 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-SI 1250 500 30 7566 JONES MANAGER 7839 02-APR-812975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-SI 2850 30 7782 CLARK MANAGER 7839 09-JUN-SI 2450 10 7788 SCOTT MANAGER 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 30 Referring to the database below, specify the following queries: Retrieve the name and job of all employees who work in department 20, and their salary exceeding 2000. SQL> Using SQL update command change the job of all employees working in department 20 to supervisor SQL>

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Readings In Database Systems

Authors: Michael Stonebraker

2nd Edition

0934613656, 9780934613651

More Books

Students also viewed these Databases questions