How often front volatility sat above back volatility

SELECT
    symbol,
    round(100 * countIf(slope_pts > 0) / count(), 1) AS inverted_days_pct,
    round(avg(slope_pts), 2)                         AS avg_slope_pts,
    count()                                          AS obs_count
FROM
(
    SELECT
        underlying_symbol AS symbol,
        date,
        (avgIf(implied_volatility, days_to_expiry BETWEEN 7 AND 25)
       - avgIf(implied_volatility, days_to_expiry BETWEEN 60 AND 120)) * 100 AS slope_pts
    FROM global_markets.options_greeks
    WHERE underlying_symbol IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO')
      AND date >= today() - 400
      AND date <= today() - 2
      AND iv_converged = 1
      AND volume > 0
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
    GROUP BY symbol, date
    HAVING countIf(days_to_expiry BETWEEN 7 AND 25) > 0
       AND countIf(days_to_expiry BETWEEN 60 AND 120) > 0
)
GROUP BY symbol
ORDER BY inverted_days_pct DESC