I have this table where I can return a list of rows for a specific date range.
The row it is pulling from has a more data in it than I need so I’ve reduced that down using a case when

SELECT case when w.[description] like '%Provisioning%' then left (w.[description],charindex('Provisioning',w.[description])-2)
                                         else '' end as [Application]
FROM [Table 1] as w
left join [Table2] as i on i.https://stackoverflow.com/q/72568367 = w.[owner]
where [owner_name] in ('Specific_Owner')
and  (convert(datetime,dateadd(s,w.[created]/1000,'1970-01-01'),110) BETWEEN Convert(datetime, '2022-05-09' ) AND Convert(datetime, '2022-06-01' ))
and w.[description] not like '%Approve%'

Which gives an output as below:

I would like to return a count of each application

So something like

Struggling a bit with this one! Any help would be appreciated 🙂