Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Question.find_by_sql("SELECT AVG(value) FROM (
- SELECT value FROM answers WHERE question_id=1 ORDER BY value LIMIT (
- SELECT COUNT(*)/4 FROM answers WHERE question_id=1
- ), (SELECT 2*(COUNT(*)/4) FROM answers WHERE question_id=1)
- ) as T;")
Add Comment
Please, Sign In to add comment