{
    "queries": [
        {
            "query": "SELECT company_name, COUNT(*) AS trading_days FROM semi_conductor_se GROUP BY company_name ORDER BY trading_days DESC LIMIT 10",
            "description": "Companies with the most trading days recorded in the data."
        },
        {
            "query": "SELECT company_name, AVG(close) AS avg_close, MAX(close) AS max_close FROM semi_conductor_se WHERE close IS NOT NULL GROUP BY company_name ORDER BY avg_close DESC LIMIT 10",
            "description": "Average and peak closing prices for each company, highest average first."
        },
        {
            "query": "SELECT date, open, high, low, close, volume FROM semi_conductor_se WHERE company_name = 'NVIDIA' ORDER BY date DESC LIMIT 10",
            "description": "The 10 most recent trading days for NVIDIA."
        },
        {
            "query": "SELECT company_name, SUM(volume) AS total_volume FROM semi_conductor_se WHERE volume IS NOT NULL GROUP BY company_name ORDER BY total_volume DESC LIMIT 10",
            "description": "Companies with the highest total shares traded."
        },
        {
            "query": "SELECT EXTRACT(year FROM date) AS yr, AVG(close) AS avg_close FROM semi_conductor_se WHERE company_name = 'AMD' AND close IS NOT NULL GROUP BY yr ORDER BY yr",
            "description": "AMD's average closing price for each year."
        },
        {
            "query": "SELECT company_name, date, high, low, (high - low) AS day_range FROM semi_conductor_se WHERE high IS NOT NULL AND low IS NOT NULL ORDER BY day_range DESC LIMIT 10",
            "description": "Trading days with the largest gap between daily high and low."
        },
        {
            "query": "SELECT stock_name, MIN(date) AS first_date, MAX(date) AS last_date FROM semi_conductor_se GROUP BY stock_name ORDER BY first_date LIMIT 10",
            "description": "Date coverage for each stock ticker, earliest starting first."
        },
        {
            "query": "SELECT company_name, date, close, volume FROM semi_conductor_se WHERE company_name = 'Micron Technology' AND volume IS NOT NULL ORDER BY volume DESC LIMIT 10",
            "description": "Micron's highest-volume trading days."
        }
    ]
}