Learn PostgreSQL GROUP BY extensions: ROLLUP, CUBE, GROUPING SETS. ... category, AVG(score) AS avg_score FROM contest_score GROUP BY full_name, category;.
確定! 回上一頁