Using the tables at the bottom, write a query to produce the results needed to answer each question below 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 Previous

The Answer is in the image, click to view ...

Question: Using the tables at the bottom, write a query to produce the results needed to answer each question below. 1. Display the query you would

Using the tables at the bottom, write a query to produce the results needed to answer each question below.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Directions The manager of a small marketing firm has hired new employees. The manager asks you to find information about the new hires. You ve already entered some information for the new hires, but...

I just need help with Part B. I have already created the tables and added the data but I am not sure how to go about creating the reports. The employee table from the homework document does not...

I need some help to complete those SQL Plus commands Question 1 Use the tables in your schema. What is the total salary of all employees. Format the answer as a dollar amount and label the column as...

1) Use the w3data database, and a query with a GROUP BY to answer the following: There are three compnaies providing shipping services for these products. They are (ShipperName) United Package,...

ORACLE DATABASE QUESTIONS Follow these basic instructions for all questions as applicable: If a concatenated patient name is used, FORMAT A18 If a concatenated employee name is used, FORMAT A18 If a...

Directions The manager of a small marketing firm has hired new employees and has asked you to identify information about them. You ve already entered some information for the new hires, but you ll...

Instructions Try to answer all the questions using what you have learned in class. Please make your query general not data related This schema is used for inventory management for an OEM Part...

SQL Programming (Simply Answer all the question) This schema is used for inventory management for an OEM Part Inventorv Name Cos Suppli Locatio p id Warehouse i quantit t er Traction Alternator 400...

The reliability of a piece of equipment is frequently defined to be the probability p that the equipment performs its intended function success fully for a given period under specific conditions...

Using the parallel-axis theorem, determine the product of inertia of the area shown with respect to the centroidal x and y axes. -3 in. 15 in 6 in. 3 in. 9 in

the three modes of the most common feedback controller are called the

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...