glints
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
givedays(integer, date)
Parameters
Name
Type
Mode
integer
IN
date
IN
Definition
SELECT AVG("x-day") FROM (SELECT COUNT(*) as "x-day" FROM "Applications" AS A FULL OUTER JOIN "Jobs" AS J ON A."JobId" = J.id WHERE A."createdAt" <= J."createdAt" + $1 * interval '1 day' AND J."createdAt" <= now() - $1 * interval '1 day' and J."createdAt" >= $2 - $1 * 4 * interval '1 day' and J."createdAt" <= $2 GROUP BY J.id) AS "Total Number of Jobs";