Author Question: Operational CRM systems improve the efficiency of CRM delivery and support processes. Indicate ... (Read 107 times)

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

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 · **Reply #1 on:** Jul 7, 2018

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;