[solved]-Cliextagent Client Spousename Jenny Client Clientid C111 C222 C333 C444 C555 C666 0777 Cli Q39010633

This is for intro to database, thanks!

CliextAgent Client SpouseName Jenny CLIENT ClientID C111 C222 C333 C444 C555 C666 0777 ClientName Tom Και Cae Dorothy Andy Tina Christina Bill Amy Amy Matt Mike AGENT AgentlD A1 AgentName AgentArea AgentRating Kate 101 AgentYearOfHire 1990 Supervised By A2 Amy 92 2009 A1 がおー A3 100 Luke James 1992 2010 A4 90 ARE.4 Areal AreaName East West Are HQ Boston San Francisco Chacago Central This database will be used for the following questions citing tables from the HAPPY INSURANCE database. 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. Show transcribed image text CliextAgent Client SpouseName Jenny CLIENT ClientID C111 C222 C333 C444 C555 C666 0777 ClientName Tom Και Cae Dorothy Andy Tina Christina Bill Amy Amy Matt Mike AGENT AgentlD A1 AgentName AgentArea AgentRating Kate 101 AgentYearOfHire 1990 Supervised By A2 Amy 92 2009 A1 がおー A3 100 Luke James 1992 2010 A4 90 ARE.4 Areal AreaName East West Are HQ Boston San Francisco Chacago Central This database will be used for the following questions citing tables from the HAPPY INSURANCE database. 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.

Expert Answer

---

Answer to CliextAgent Client SpouseName Jenny CLIENT ClientID C111 C222 C333 C444 C555 C666 0777 ClientName Tom Και Cae Dorothy… . . .