I Need Help writing all these SQL Problems ASAP!!

1. Write an SQL query for the HAPPY INSURANCE Database that will retrieve the name of each agent that has a rating lower than 100, as well as whose name starts with an A

2.Write an SQL query for the HAPPY INSURANCE database that will list the client name and agent name for each client who does Not have a spouse.

3.Write an SQL query for the HAPPY INSURANCE Database that will display the average agent year of hire for all agents.

4. Write an SQL query for the HAPPY INSURANCE Database that will for each agent, the agents id, name and area along with the number of clients that agent had with the column header Client Count.

5.write an SQL for the HAPPY INSURANCE Database that will display the name of each client of the agent that has been with the company longest.

6. Write an SQL query for the HAPPY INSURANCE Database that will for each agent listcthe agents id, agents name, area name, and the clients of that agent. The results should be listed by agent name, area name, and client name.

tion 12 HAPPY NSURANCE t answered Observe the HAPPY INSURANCE DATABASE ts out of 4 00 Flag queston A1 C333 C44 A2 DerethyA2 C666 Mike A1 A2 101 92 100 1990 A1 1992 2010 A3 Bouta San Frane This database will be used for the folliovwring questions citing tables from the HAPPY INSURANCE database Write an SQL query for the HAPPY INSURANCE database that wia list the client name and agent name for each client who BET