subject

Assume that the following table is created and stored in your database:
staff (staff_no, name, position, salary, sex, job_id, hire_date)

write sql statements to do the following:

a. increment the salary of managers by 5%;
b. delete the records of all 'salesmen' from the staff table;
c. delete the record for the staff whose name is 'smith' and staff number is 17.
d. insert a new staff < 18, 'johnson', 'salesman, 2500, 'f'> in the database.
e. update the salaries for all staff who have one of the job ids similar to those in department 5.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 21:10
Dameas communication challenge is due to which factor
Answers: 2
question
Computers and Technology, 23.06.2019 03:00
What are the different parts of computer
Answers: 2
question
Computers and Technology, 23.06.2019 09:00
Which is the highest level of the hierarchy of needs model? a. humanity b. intrapersonal c. team d. interpersonal
Answers: 1
question
Computers and Technology, 24.06.2019 02:10
Which sentences describe the things you need to ensure while creating a sketch and a drawing? while an artistic or creative drawing is a creative expression, a technical drawing is an informative expression. you need to create accurate and neat drawings to convey accurate information. a technical drawing clearly conveys its meaning or information, and does not leave room for interpretation maintain a good speed while creating drawings
Answers: 1
You know the right answer?
Assume that the following table is created and stored in your database:
staff (staff_no, nam...
Questions
question
Mathematics, 15.03.2020 01:51
question
Biology, 15.03.2020 01:54
Questions on the website: 13722359