aggregate-average-assignment-time.sql.ts

export const aggregateAverageAssignmentTimeQuery = `
select
	avg(
	(select sum(case
		when "createdAt" notnull and "assignedAt" notnull
		then (extract(epoch from "assignedAt") - extract(epoch from "createdAt")) * 1000
		else 0
		end)::bigint  as time
	from "WorkflowRuntimeData"
	where "assigneeId" = "User".id
	and "assignedAt" >= $1)
	)::varchar as time
from
	"User"
where
	"User".id = coalesce($2,
	"id")
`;