Getting monthly and weekly data from daily in sql server

Question

Hello All,

I have a table like below.
I need to get daily,weekly and monthly calls data from this.

Could any one please help what is the query to write here

Answer 1

Use a date function like YEAR, MONTH, DATEPART and an aggregation, like

select YEAR(date) AS Year, MONTH(date) AS Month, SUM(Calls) AS Calls  
from yourTable  
group by YEAR(date), MONTH(date)  
order by YEAR(date), MONTH(date)  

for a monthly report.
See https://learn.microsoft.com/en-us/sql/t-sql/functions/date-and-time-data-types-and-functions-transact-sql?view=sql-server-ver15#DateandTimeFunctions
for details.