<invoke name="query_sql"> <parameter name="sql">WITH q AS (SELECT species, quantile_cont(sepal_length,0.25) sl1, quantile_cont(sepal_length,0.75) sl3, quantile_cont(sepal_width,0.25) sw1, quantile_cont(sepal_width,0.75) sw3, quantile_cont(petal_length,0.25) pl1, quantile_cont(petal_length,0.75) pl3, quantile_cont(petal_width,0.25) pw1, quantile_cont(petal_width,0.75) pw3 FROM raw.iris GROUP BY species) SELECT i.species, i.sepal_length, i.sepal_width, i.petal_length, i.petal_width, (i.sepal_length < q.sl1-1.5*(q.sl3-q.sl1) OR i.sepal_length > q.sl3+1.5*(q.sl3-q.sl1)) AS sl_out, (i.sepal_width < q.sw1-1.5*(q.sw3-q.sw1) OR i.sepal_width > q.sw3+1.5*(q.sw3-q.sw1)) AS sw_out, (i.petal_length < q.pl1-1.5*(q.pl3-q.pl1) OR i.petal_length > q.pl3+1.5*(q.pl3-q.pl1)) AS pl_out, (i.petal_width < q.pw1-1.5*(q.pw3-q.pw1) OR i.petal_width > q.pw3+1.5*(q.pw3-q.pw1)) AS pw_out FROM raw.iris i JOIN q USING (species) WHERE sl_out OR sw_out OR pl_out OR pw_out ORDER BY species</parameter> <parameter name="purpose">List per-species IQR outlier rows</parameter> </invoke> <parameter name="source">raw</parameter> </invoke>