<invoke name="query_sql"> <parameter name="sql">WITH b AS (SELECT *, AVG(sepal_length) OVER (PARTITION BY species) gsl, AVG(sepal_length) OVER () tsl, AVG(sepal_width) OVER (PARTITION BY species) gsw, AVG(sepal_width) OVER () tsw, AVG(petal_length) OVER (PARTITION BY species) gpl, AVG(petal_length) OVER () tpl, AVG(petal_width) OVER (PARTITION BY species) gpw, AVG(petal_width) OVER () tpw FROM raw.iris) SELECT 1 - SUM(pow(sepal_length-gsl,2))/SUM(pow(sepal_length-tsl,2)) AS sepal_length_eta2, 1 - SUM(pow(sepal_width-gsw,2))/SUM(pow(sepal_width-tsw,2)) AS sepal_width_eta2, 1 - SUM(pow(petal_length-gpl,2))/SUM(pow(petal_length-tpl,2)) AS petal_length_eta2, 1 - SUM(pow(petal_width-gpw,2))/SUM(pow(petal_width-tpw,2)) AS petal_width_eta2 FROM b</parameter> <parameter name="purpose">Rank the four measures by how much of their variance is explained by species (discriminatory power)</parameter> <parameter name="source">raw</parameter> </invoke> <invoke name="query_sql"> <parameter name="sql">(SELECT 'highest' AS record_type, species, petal_length, petal_width, sepal_length, sepal_width FROM raw.iris ORDER BY petal_length DESC LIMIT 3) UNION ALL (SELECT 'lowest', species, petal_length, petal_width, sepal_length, sepal_width FROM raw.iris ORDER BY petal_length ASC LIMIT 3)</parameter> <parameter name="purpose">Show highest and lowest petal_length records</parameter> <parameter name="source">raw</parameter> </invoke>