charged_minutes AS (
    SELECT
        dt AS ChargedDate,
        uid,
        SUM(visitParamExtractFloat(addJson, 'seconds')) AS TotalSeconds,
        COUNT(*) AS UsageCount
    FROM stat.funnelTrack
    WHERE dt >= '2024-08-01'
    AND action in ('listen_live_seconds_spent')
    GROUP BY ChargedDate, uid
)

SELECT
    SUM(charged_minutes.TotalSeconds) AS TotalSeconds,
    SUM(charged_minutes.UsageCount) AS TotalUsageCount
FROM charged_minutes