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.

a. update Staff set salary=salary*1.05 where position='manager'

b. delete from Staff where position='salesman'

c. delete from Staff where name='Smith' and staff_no=17

d. insert into Staff (staff_no, name, position, salary, sex) values (18, 'Johnson', 'salesman', 2500, 'F')

e. update Staff set salary=2000 where job_id like '5%'

Explanation:

To update a column in a table 'update' command is used.

To remove a record from the table 'delete' command is used

To add a new record to the table 'insert into' command is used.

which of the following is not an effect of technology on farming?

the correct answer is: it makes farmers perform more tasks by hand for apex.