Basic and diluted share counts across eight large caps

SELECT
    ticker,
    round(avg(basic_m), 1)                              AS basic_shares_m,
    round(avg(diluted_m), 1)                            AS diluted_shares_m,
    round(100 * (avg(diluted_m) / avg(basic_m) - 1), 2) AS dilution_gap_pct
FROM
(
    SELECT
        t                                                AS ticker,
        period_end,
        max(toFloat64(basic_shares_outstanding)) / 1e6   AS basic_m,
        max(toFloat64(diluted_shares_outstanding)) / 1e6 AS diluted_m
    FROM global_markets.stocks_income_statements
    ARRAY JOIN tickers AS t
    WHERE t IN ('AAPL', 'MSFT', 'NVDA', 'AMZN', 'TSLA', 'KO', 'F', 'PFE')
      AND timeframe = 'quarterly'
      AND period_end >= '2024-07-01'
      AND basic_shares_outstanding > 0
      AND diluted_shares_outstanding > 0
    GROUP BY ticker, period_end
)
GROUP BY ticker
ORDER BY dilution_gap_pct DESC