Question

1. Display the query you would write to update the salary for John Jones

2. Display the query you would write to update all salaries by 5%

3. Display the query you would write to update all salaries by 5% for only the employees who live in Arizona

4. Write a query to insert a new record into the empinfo table (Hint: you are adding a full record - a new piece of information for each field/column)

5. Write a query to add a new record into the empinfo table - BUT, you only have the employee's first and last names along with their age at this point.

Sample Table: empinfo
first	last	id	age	city	state
John	Jones	99980	45	Payson	Arizona
Mary	Jones	99982	25	Payson	Arizona
Eric	Edwards	88232	32	San Diego	California
Mary Ann	Edwards	88233	32	Phoenix	Arizona
Ginger	Howell	98002	42	Cottonwood	Arizona
Sebastian	Smith	92001	23	Gila Bend	Arizona
Gus	Gray	22322	35	Bagdad	Arizona
Mary Ann	May	32326	52	Tucson	Arizona
Erica	Williams	32327	60	Show Low	Arizona
Leroy	Brown	32380	22	Pinetop	Arizona
Elroy	Cleaver	32382	22	Globe	Arizona
Sample Table: empsal
id	suprvsr	salary	bonus	bonus amt	office
99980	92001	45600	Y	3000	Arizona
99982	92001	47000	Y	3000	Arizona
88232	92001	52500	N		California
88233	92001	49300	Y	3000	Arizona
98002	92001	52200	Y	3000	Arizona
92001	88888	65000	Y	5000	California
22322	32380	46800	Y	3000	Arizona
32326	32380	50900	N		Arizona
32327	32380	48300	Y	3000	Arizona
32380	32380	53400	Y	3000	Arizona
32382	32380	55600	Y	3000	Arizona

Answer 1

Answer)
Q1. SQL statement to update the salary for John Jones:

UPDATE empsal
SET salary=60000
WHERE id in (
select id from empinfo
where first='John' and last='Jones'
);

Q2. SQL statement to update all salaries by 5%:

UPDATE empsal
SET salary=salary*1.05;

Q3. SQL statement to update all salaries by 5% for only the employees who live in Arizona:

UPDATE empsal
SET salary=salary*1.05
where id in (
select id from empinfo
where state='Arizona'
);

Q4. SQL statement to insert a new record into the empinfo table:

insert into empinfo values('Mark','Rogers',99999,35,Payson,Arizona);

Q5. SQL statement to add a new record into the empinfo table, employee's first and last names along with their age:

INSERT INTO empinfo (first,last,age)
VALUES ('William','Skins',35);

**Please Hit Like if you appreciate my answer. For further doubts on the question or answer please drop a comment, I'll be happy to help. Thanks for posting.**