Operational CRM systems improve the efficiency of CRM delivery ...

[imowrer]

Operational CRM systems improve the efficiency of CRM delivery and support processes.
 
  Indicate whether the statement is true or false

Question 2

Write an SQL query for the HAPPY INSURANCE database that will, for each area where the highest rated agent has a rating higher than 100, display the area ID, area name, and average rating for all agents in the area.
 
  What will be an ideal response?

[Joc]

Answer to Question 1

TRUE

Answer to Question 2

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

[imowrer]

Excellent

[raili21]

TYSM