While this works as I had hoped, I am looking for additional information. How would I write a query so that I have the average of Previous and Renew combined as well as 1st -New and 1st Old combined.
Along with this, I am looking for a Count of "ID" Grouped By "Client Info". However, I am having trouble writing the correct query for this as well.
Please let me know of any changes or how can I make this happen. If more info is needed, please let me know.