cascader1 value is "12 hours"
SELECT
"status",
COUNT("id") AS "Total",
ROUND(
(COUNT("id") * 100.0) / (
SELECT
COUNT(*)
FROM
"bills"
WHERE
"merchant_id" = 8
AND "inserted_at" >= NOW() - INTERVAL '{{ cascader1.value[0] }}'::interval
),
1
) AS "Percentage"
FROM
"bills"
WHERE
"status" IN ('succeeded', 'pending', 'failed')
AND "merchant_id" = 8
AND "inserted_at" >= NOW() - INTERVAL '{{ cascader1.value[0] }}'::interval
GROUP BY
"status";