{
    "queries": [
        {
            "query": "SELECT \"Species\", COUNT(*) AS n FROM \"Iris\" GROUP BY 1 ORDER BY 2 DESC",
            "description": "Number of flowers recorded for each species."
        },
        {
            "query": "SELECT \"Species\", AVG(\"PetalLengthCm\") AS avg_petal_length FROM \"Iris\" GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average petal length by species, longest first."
        },
        {
            "query": "SELECT \"Species\", AVG(\"SepalLengthCm\") AS avg_sepal_length, AVG(\"SepalWidthCm\") AS avg_sepal_width FROM \"Iris\" GROUP BY 1",
            "description": "Average sepal length and width for each species."
        },
        {
            "query": "SELECT MIN(\"PetalWidthCm\") AS min_w, MAX(\"PetalWidthCm\") AS max_w, AVG(\"PetalWidthCm\") AS avg_w FROM \"Iris\" WHERE \"PetalWidthCm\" IS NOT NULL",
            "description": "Smallest, largest and average petal width across all flowers."
        },
        {
            "query": "SELECT \"Id\", \"SepalLengthCm\", \"PetalLengthCm\", \"Species\" FROM \"Iris\" WHERE \"Species\" = 'Iris-virginica' ORDER BY \"PetalLengthCm\" DESC LIMIT 10",
            "description": "Ten Iris-virginica flowers with the longest petals."
        },
        {
            "query": "SELECT \"Id\", \"SepalWidthCm\", \"SepalLengthCm\", \"Species\" FROM \"Iris\" WHERE \"Species\" = 'Iris-setosa' ORDER BY \"SepalWidthCm\" DESC LIMIT 10",
            "description": "Ten Iris-setosa flowers with the widest sepals."
        },
        {
            "query": "SELECT \"Species\", MAX(\"SepalLengthCm\") AS max_sepal_length, MIN(\"SepalLengthCm\") AS min_sepal_length FROM \"Iris\" GROUP BY 1",
            "description": "Range of sepal lengths within each species."
        },
        {
            "query": "SELECT \"Species\", COUNT(*) AS n FROM \"Iris\" WHERE \"PetalLengthCm\" > 4 GROUP BY 1 ORDER BY 2 DESC",
            "description": "Count of flowers with petals longer than 4 cm, by species."
        },
        {
            "query": "SELECT \"Id\", \"Species\", \"PetalLengthCm\" * \"PetalWidthCm\" AS petal_area FROM \"Iris\" WHERE \"PetalLengthCm\" IS NOT NULL AND \"PetalWidthCm\" IS NOT NULL ORDER BY 3 DESC LIMIT 10",
            "description": "Ten flowers with the largest approximate petal area."
        }
    ]
}