Average and median functions in MySQL

gistfile1.txt

USE new_schema; #schema name
SELECT * FROM new_table ORDER BY new_column; #order by column
SELECT AVG(new_column) FROM new_table; #average
SET @median = (SELECT COUNT(*) FROM new_table) DIV 2; #variable to use as 'offset' in 'limit'
PREPARE median FROM 'SELECT * FROM new_table ORDER BY new_column LIMIT ?,1'; #? will be replaced by variable from 'using'
EXECUTE median USING @median; #execute