I need some query help and I would really appreciate any help. Below is
my query:

Select AdminAdvertiserList.Company, AdminAdvertiserList.City,
AdminAdvertiserInvoices.[Contract Date], AdminAdvertiserInvoices.[Start
Date], AdminAdvertiserInvoices.[End Date],
AdminAdvertiserInvoices.Amount,
AdminAdvertiserInvoices.AdditionalRevenueProgram,
AdminAdvertiserInvoices.Payments, AdminAdvertiserInvoices.Messages,
AdminAdvertiserInvoices.[Bonus Messages], AdminAdvertiserInvoices.Type,
AdminAdvertiserRepsDDL.Name [Sales Rep]
JOIN AdminAdvertiserList ON AdminAdvertiserList.Id =
AdminAdvertiserInvoices.AdvertiserId
JOIN AdminAdvertiserRepsDDL ON AdminAdvertiserRepsDDL.Id =
AdminAdvertiserList.SalesEmployeeId


I would like to include the column MessagesSent. However, I want to
calculate MessagesSent that were sent between Start Date and End Date.
Does anyone have any ideas how this would even look?

Thank you very much for your help!

How to concatenate strings from a column into a single row (with NULL value)?
SQL problem to solve...
passing a table from one sp to another sp
Temp Table Indexing??
Best way to document databases ?
How to utilize the rowId in sql server
How to select a single varchar combined by many rows?
need help on sql
OPENROWSET
SQL Query