This topic contains a solution. Click here to go to the answer

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

vinney12

  • Hero Member
  • *****
  • Posts: 586
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?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Jmfn03

  • Sr. Member
  • ****
  • Posts: 323
Answer to Question 1

A

Answer to Question 2

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




vinney12

  • Member
  • Posts: 586
Reply 2 on: Jul 7, 2018
:D TYSM


hollysheppard095

  • Member
  • Posts: 339
Reply 3 on: Yesterday
Excellent

 

Did you know?

The average office desk has 400 times more bacteria on it than a toilet.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

Signs and symptoms of a drug overdose include losing consciousness, fever or sweating, breathing problems, abnormal pulse, and changes in skin color.

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

For a complete list of videos, visit our video library