I have a query that filters the emails of people who "have a quantity" bigger than the median over all quantities found in the table: SELECT AVG(quantity) AS avg_quantity, email FROM table GROUP BY email HAVING AVG(quantity) > (SELECT PERCENTILE_DISC(0.5)…
Let's say I have two tables called schools and students which have a one-to-many relationship. Each student can only be in one school but each school can have many students. school ----------- id name student ----------- id name school_id I…
I was wondering if there was an actually good way to aggregate/calculate percentiles based on all data in a database. For example, data like: { 'name':'John' 'rank':5 }, { 'name':'John' 'rank':4 }, { 'name':'John' 'rank':5 }, { 'name':'James' 'rank':3 },…