```json { "queries": [ { "query": "SELECT Species, COUNT(*) AS count FROM Iris GROUP BY Species ORDER BY count DESC", "description": "Number of samples for each iris species in the dataset." }, { "query": "SELECT Species, AVG(PetalLengthCm) AS avg_petal_length FROM Iris GROUP BY Species ORDER BY avg_petal_length 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 Species", "description": "Average sepal dimensions for each iris species." }, { "query": "SELECT * FROM Iris WHERE Species = 'Iris-setosa' ORDER BY PetalLengthCm DESC LIMIT 10", "description": "Top 10 Iris-setosa samples with the longest petals." }, { "query": "SELECT Species, MIN(PetalWidthCm) AS min_width, MAX(PetalWidthCm) AS max_width FROM Iris GROUP BY Species", "description": "Minimum and maximum petal width for each species." }, { "query": "SELECT * FROM Iris WHERE PetalLengthCm > 5.0 AND Species = 'Iris-virginica' LIMIT 15", "description": "Iris-virginica samples with petal length exceeding 5 cm." }, { "query": "SELECT Species, AVG(PetalLengthCm * PetalWidthCm) AS avg_petal_area FROM Iris GROUP BY Species ORDER BY avg_petal_area DESC", "description": "Average petal area by species, largest first." }, { "query": "SELECT * FROM Iris WHERE Species = 'Iris-versicolor' ORDER BY SepalLengthCm ASC LIMIT 10", "description": "Iris-versicolor samples with the shortest sepals." }, { "query": "SELECT COUNT(*) AS large_petals FROM Iris WHERE PetalLengthCm > 4.5 AND PetalWidthCm > 1.5", "description": "Count of flowers with both large petal length and width." }, { "query": "SELECT Species, MAX(SepalLengthCm) AS max_sepal FROM Iris GROUP BY Species ORDER BY max_sepal DESC", "description": "Maximum sepal length recorded for each species." } ] } ```