Give all employees under BLAKE’s supervision 5% salary increase and 1000 bonus commission using sql Below is a transcription of the provided table, formatted for clarity as it might appear on an educational website:---**Employee Information Table**| **Emp No** | **Employee Name** | **Job Title** | **Manager ID** | **Hire Date** | **Salary** | **Commission** | **Dept No** ||------------|-------------------|---------------|----------------|----------------|------------|----------------|-------------|| 7839 | KING | PRESIDENT | (null) | 17-NOV-81 | 5000 | (null) | 10 || 7566 | JONES | MANAGER | 7839 | 02-APR-81 | 2975 | (null) | 20 || 7902 | FORD | ANALYST | 7566 | 03-DEC-81 | 3000 | (null) | 20 |---**Explanation:**- **Emp No:** This is the unique employee number assigned to each individual.- **Employee Name:** This column lists the names of the employees.- **Job Title:** Describes the employee's position within the company.- **Manager ID:** Refers to the employee number of the manager who supervises them. A value of (null) indicates the employee does not report to another manager.- **Hire Date:** This is the date the employee was hired, formatted as DD-MMM-YY.- **Salary:** The monthly salary of the employee, presented in monetary units.- **Commission:** Any commission the employee might earn, noted here as (null) indicating no commission.- **Dept No:** The department number to which the employee belongs.This table provides an overview of basic employee data, offering insights into organizational structure through job titles and reporting relationships.

Given a table, say, emp(name of the given table) First Step: select all the employees under blake's supervision. Second Step: Give these employees a 5% salary increase and 1000 bonus commission. SQL Query: update emp set sal=sal*1.05+1000 where mgr in (select empno from emp where name in ('BLAKE'));

Answered: Give all employees under BLAKE’s…

Engineering

Computer Science

Give all employees under BLAKE’s supervision 5% salary increase and 1000 bonus commission using sql

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Give each clerk a salary increase, which is 3% of all clerks’ average salary to each clerk using…

A: Syntax to find the average of column in SQL: SELECT AVG(column_name)FROM table_nameWHERE condition;…

Q: SQL

Q: Write a SQL trigger to carry out the following action: If an account is deleted, then write a…

A: create trigger [trigger_name] [before | after] {insert | update | delete} on [table_name] [for…

Q: Consider the following schema: Publisher (name, phone, city), PK: name. Book (ISBN, title, year,…

A: select b.title from Book b inner join (select e.bISBN from Edit e group by e.eSSN having count(*)…

Q: Use the given database to output the results of the following SQL queries: a.) SELECT DISTINCT…

A: Note: To implement the query mentioned in the question, classroom and section tables are needed.…

Q: The following tables (Table 2 and Table 3) with the following values are stored in Oracle database.…

A: (i) The following is the Rollback SQL query to undo transactions with reference to log UPDATE…

Q: Can some rewrite the following sql tables into relational algebra format? a) SELECT NoOfCopies…

A: Consider ∏ for Project ,σ for Select and ⋈ for join. a) ∏No_Of_Copies(( σTitle='The Lost…

Q: What does the following SQL snippet do? Select all pertinent answers. SUM(X) over ( order by date…

A: SUM(X) over ( order by date between rows 1 preceding and 1 following ) 1. Calculates an average of…

Q: Ashley has a data set of sales transactions in the following format Cust Gender Clothing Tech 1…

A: A function in R is a block of code that can be called or invoked several times with varied inputs to…

Q: Give 3% salary increase to those employees who have the smallest salary in their respective…

A: UPDATE EMP SET SAL = (SAL*103)/100 WHERE SAL IN

Q: Movie mID title year director Gonewith the Wind 1939 Victor Fleming 1977 George Lucas The Sound of…

A: In this question we are going to create SQL table by watching at the different charts. Here we are…

Q: Give all employees under BLAKE's supervision 5% salary increase and 1000 bonus commission using sql…

A: In this, we are given a SQL table (let say named Employee) in which details of Employees are given.…

Q: Task3: Write SQL Queries • At least 2 queries involving GROUP BY, HAVING, and aggregate operators. •…

A: To write SQL queries.

Q: The following SQL query deletes all drivers in an accident that were not injured (Note that a value…

A: The correct answer is False

Q: Describe succinctly but completely in standard written English what each of the following SQL…

A: This question comes from Database Management System which is a part of computer science. Let's…

Q: How do I calculate the min, average, and total for the total revenue (tot_revenue), total community…

A: To calculate the min, average, and total for the total revenue (tot_revenue), total community…

Q: CPUs that are not pipelined have clock cycles that are much quicker.

A: In computer building, pipelining is a method used to improve the recital of a CPU by overlap the…

Q: For all the employees supervised by KING, give them a salary increase, which is equal to the 2% of…

A: This can be done by changing the salary value in all columns where the MGR id is 7839. script in…

Q: Write an SQL query to fetch last_name from employees table using the alias name as Employee Name.…

A: As per our company guidelines, we are supposed to answer three subparts of a post and kindly…

Q: Solve This SQL For the following operations, write the appropriate SQL statement. b) Determine the…

A: Please see the next step for solution:-

Q: Using a SQL query on the CSV that have their own contained table Find all reservations in room HBB…

A: * first we need to read csv files and import it to two tables * after reading csv file we need to…

Question

Give all employees under BLAKE’s supervision 5% salary increase and 1000 bonus commission

using sql

Below is a transcription of the provided table, formatted for clarity as it might appear on an educational website:

---

**Employee Information Table**

| **Emp No** | **Employee Name** | **Job Title** | **Manager ID** | **Hire Date** | **Salary** | **Commission** | **Dept No** |
|------------|-------------------|---------------|----------------|----------------|------------|----------------|-------------|
| 7839 | KING | PRESIDENT | (null) | 17-NOV-81 | 5000 | (null) | 10 |
| 7566 | JONES | MANAGER | 7839 | 02-APR-81 | 2975 | (null) | 20 |
| 7902 | FORD | ANALYST | 7566 | 03-DEC-81 | 3000 | (null) | 20 |

---

**Explanation:**

- **Emp No:** This is the unique employee number assigned to each individual.
- **Employee Name:** This column lists the names of the employees.
- **Job Title:** Describes the employee's position within the company.
- **Manager ID:** Refers to the employee number of the manager who supervises them. A value of (null) indicates the employee does not report to another manager.
- **Hire Date:** This is the date the employee was hired, formatted as DD-MMM-YY.
- **Salary:** The monthly salary of the employee, presented in monetary units.
- **Commission:** Any commission the employee might earn, noted here as (null) indicating no commission.
- **Dept No:** The department number to which the employee belongs.

This table provides an overview of basic employee data, offering insights into organizational structure through job titles and reporting relationships.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Thank you!
Lab Exercise Consider the following emp table given below and perform the given below operations. Oracle 5Q Plus sOL) select from enp; EPHO ENAE JOn HGR MIREDATE SAL CO CLERK SALESHAN SALESHAH 7982 17-0EC-80 7698 20-FEB-81 7698 22-FEB-81 7839 2-APR-1 7698 28-SEP-81 7839 01-HAY-81 7839 09-JUH-81 7566 19-APR-87 17-HOV-81 7698 -SEP-81 7788 23-HAY-87 7698 03-DEC-81 7566 03-DEC-81 782 23-JAH-82 7369 SHITH 7499 ALLEN 7521 MARD 1600 1250 2975 1258 2850 2450 3000 300 500 7566 JONES 7654 HARTIN HANAGER 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 78A TURNER 7876 ADAMS 7900 JAHES 7902 FORD 7934 HILLER SALESHAN PANAGER HANAGER ANALYST PRESIDENT SALESHAN CLERK CLERK ANALYST CLERK 1580 1180 950 3000 1300 rows selected. SOL> I 4. Drop the COMM column 5. Rename the table as Employees. 6. Check that the SAL column value is between 500 and 10000 7. Delete all records from the table. - For each step screenshot the SQL code you wrote + screenshot the table showing the changes done. - Upload your work to…
Write SQL statements to answer the following questions using Assignment 3’s schema (tables below). You can add more data to the tables if you want, just follow the PK and FK rules. Accounts are not Loans and Loans are not Accounts. NOTE I already have Answers for part 1 BELOW PART 1 IS FOR ONLY REFRENCE TO ANSWER QUESTIONS 6-11 6- Find Customer ID, Customer name and the number of loans for each Customer. 7- Find Loan number and Customer Id of the loan with the lowest amount. 8- Create a view called Gary_Branch_V that contains Branch Id, Branch name, and number of loans for each Branch that is in the city of Gary. 9- For each Customer in Hopkins, find the balance in their account(s). 10- Find how many different accounts each customer has at each Branch. The output should be a list of Customer ID and for each Customer ID, the number of accounts for this customer by Branch ID. 11- Find the branch with the highest or largest Average loan amount. List the Branch ID, Branch…
Use SQL to query the inter assignee patent citations among top 100 assignees
(b) Consider the schema of Customer table and write SQL statements for the following queries. sid sname address age occupation salary Pavment mode gender 123 sam yacoas 31 manager 60000 cash 124 david flaca 38 administrator 45000 credit i. Write the SQL query to set salary of all supervisors to Rs 40 000. ii. Write the SQL query to display details of clients whose names end with character 'e'. iii. Write the SQL code to display details of those clients who come from Vacoas or mahebourg,