```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(petal_length) 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(sepal_length) AS avg_sepal, AVG(sepal_width) AS avg_width FROM iris GROUP BY species", "description": "Average sepal dimensions for each iris species." }, { "query": "SELECT * FROM iris WHERE species = 'setosa' ORDER BY petal_length DESC LIMIT 10", "description": "Top 10 setosa samples with the longest petals." }, { "query": "SELECT species, MAX(petal_width) AS max_width, MIN(petal_width) AS min_width FROM iris GROUP BY species", "description": "Petal width range for each species showing maximum and minimum values." }, { "query": "SELECT * FROM iris WHERE petal_length > 5.0 ORDER BY petal_length DESC LIMIT 15", "description": "Iris samples with petal length exceeding 5 cm, longest first." }, { "query": "SELECT species, AVG(petal_width) AS avg_petal_width FROM iris WHERE petal_length IS NOT NULL GROUP BY species", "description": "Average petal width by species for samples with recorded petal length." }, { "query": "SELECT * FROM iris WHERE species = 'virginica' AND sepal_length > 6.5 LIMIT 10", "description": "Virginica samples with sepal length greater than 6.5 cm." }, { "query": "SELECT COUNT(*) AS total, AVG(sepal_length) AS avg_sepal FROM iris WHERE species = 'versicolor'", "description": "Total count and average sepal length for versicolor species." }, { "query": "SELECT species, SUM(petal_length * petal_width) AS total_petal_area FROM iris GROUP BY species ORDER BY total_petal_area DESC", "description": "Approximate total petal area by species, largest first." } ] } ```