XDean

SELECT
	`count` AS `count`,
	MIN(`value`) AS `min`,
	MAX(`value`) AS `max`,
	AVG(`value`) AS `mean`,
	AVG(CASE WHEN ABS(`rank`-`count`*.25 + .5)<=.5 THEN `value` ELSE NULL END) AS q1,
	AVG(CASE WHEN ABS(`rank`-`count`*.5 + .5)<=.5 THEN `value` ELSE NULL END) AS q2,
	AVG(CASE WHEN ABS(`rank`-`count`*.75 + .5)<=.5 THEN `value` ELSE NULL END) AS q3
FROM
(

XDean

import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.DriverPropertyInfo;
import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.util.Properties;
import java.util.logging.Logger;

XDean

public @interface Anno {
  String value();
}