Stock Ticker Find

Robinhood users are currently interested in the artificial intelligence sector. To help them find relevant stocks, the engineering team needs to generate a list of all stocks where the ticker symbol contains the letters AI.

Write an SQL query to retrieve these stocks.

Rules:

• The string AI must appear anywhere within the ticker_symbol.
• The search should be case-sensitive (standard for tickers).
• Output columns: ticker_symbol, company_name.
• Results must be returned in ascending order by ticker_symbol.

Table Schema:

• Stocks: stock_id, ticker_symbol (VARCHAR), company_name (VARCHAR), exchange.