In Oracle I can do something like this:
SELECT COLUMN1, COLUMN2, SUM(COLUMN3), AVG(COLUMN3), MEDIAN(COLUMN3) FROM TABLE
GROUP BY COLUMN1, COLUMN2
Is there a way to achieve the same thing in MEMSQL?
I tried PERCENTILE_CONT, but the best I could get is the median group by COLUMN1 and COLUMN2, and I don’t know how to fit SUM(COLUMN3) and AVG(COLUMN3) into the query.
I also tried create a custom function using CREATE AGGREGATE but have no luck.