Count SQL, find the total number of documents and find the total number of documents by quarter

--Find the total number of documents

Select COUNT (1) as ' table XXXXXX data volume ' from XXXXXXwith (NOLOCK)

--Find total documents by quarter

Select COUNT (1) as ' table xxxxxx per quarter number of data ', b.yq as ' xxxxxx quarter ' from
(
Select A.tn_no,cast (DatePart (year,a.created_date) as varchar) + ' 0 ' +cast (DatePart (quarter,a.created_date) as varchar (+) as YQ---stitching annual quarter string
From (
Select Tn_no,created_date from XXXXXXwith (NOLOCK)---Find the underlying data source
) A
) B GROUP by B.yq ORDER BY B.yq Desc

Count SQL, find the total number of documents and find the total number of documents by quarter