I am trying to link 2 tables to create the below output. The purpose of the query is to report on the agents who have been able to sell insurance policy with the products we sell within a week timeframe. I am struggling to set up a query to pull back the correct information. Any help would be greatly Appreciated.
I have just one quick question I hope you can help with. When I run the below query and I get a message that reads 'The sum or average aggregate operation cannot take a bit data type as an argument'. Do you know what this means and how I can correct the query.