Need inputs to get the number of Payrolls between the Period start date and period end date

Content

Hi All,

We have a requirement to find the number of payrolls in between the period start date and period end date through FF. 

Ex: Period start date :01-Aug-2019

Period End Date:31-Aug-2019

Payroll Name:XYZBIWeekly.

Expected Output:3

To achieve this requirement we are unable to find the DBI's from the FF so that we developed below SQL query to be used in a value set and call from FF but we are unable to use aggregate functions in value set.

Any inputs to achieve this requirement from DBI's in FF or through Value set.

SELECT a.abc

FROM