Author Question: A good rule of thumb is to interview: A) at least three people on every level of the organization ... (Read 47 times)

vinney12 · **on:** Jul 7, 2018

A good rule of thumb is to interview:

A) at least three people on every level of the organization and at least one from each functional area directly involved in the system.
B) at least one person on every level of the organization and at least three from each functional area directly involved in the system.
C) at least one person on every level of the organization and at least one from each functional area directly involved in the system.
D) at least one person on every level of the organization and at least two from each functional area directly involved in the system.

Question 2

Write an SQL query for HAPPY INSURANCE database that will for each area display the area ID, area name, and average rating for all agents in the area.

What will be an ideal response?

Jmfn03 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

A

Answer to Question 2

SELECT areaid, areaname, AVG(agentrating)
FROM area, agent
WHERE areaid = agentarea
GROUP BY areaid, areaname;