The most recent 10-K on file for the same nine issuers

SELECT
    ticker,
    toString(max(filing_date))  AS latest_annual_report,
    monthName(max(filing_date)) AS filed_in,
    uniqExact(accession_number) AS annual_reports_on_file
FROM
(
    SELECT
        leftPad(toString(cik), 10, '0') AS filer_cik,
        filing_date,
        accession_number
    FROM global_markets.stocks_sec_edgar_index
    WHERE form_type = '10-K'
      AND filing_date >= toDate('2025-01-01')
      AND filing_date <  toDate('2026-07-01')
) AS annual
INNER JOIN
(
    SELECT
        ticker,
        argMax(leftPad(toString(cik), 10, '0'), period_end) AS filer_cik
    FROM
    (
        SELECT
            arrayJoin(tickers) AS ticker,
            cik,
            period_end
        FROM global_markets.stocks_income_statements
        WHERE period_end >= toDate('2023-07-01')
    )
    WHERE ticker IN ('AAPL', 'COST', 'HD', 'JNJ', 'KO', 'MSFT', 'NVDA', 'ORCL', 'WMT')
    GROUP BY ticker
) AS issuers USING (filer_cik)
GROUP BY ticker
ORDER BY ticker