Ptt 大爆卦 | Codility - 前往 https://stackoverflow.com/questions/69044111/codility-postgresql-question-aggregation-and-conditionality-in-sql-query-compl

你即將離開本站

並前往https://stackoverflow.com/questions/69044111/codility-postgresql-question-aggregation-and-conditionality-in-sql-query-compl

Codility PostgreSQL Question: Aggregation and conditionality ...

SELECT task_id, name, CASE WHEN AVG(score) > 60 THEN 'Easy' WHEN AVG(score) <= 20 THEN 'Hard' ELSE 'Medium' END AS difficulty FROM reports ...

確定！回上一頁

查詢「Codility」的人也找了：

codility是什麼