SELECT AVG(kilometers) OVER() AS overall_avg_kms, category, AVG(kilometers) OVER(PARTITION BY category) AS category_avg_kms, AVG(kilometers) OVER() - AVG(kilometers) OVER(PARTITION BY category) AS diff FROM table_name;
上一篇:编写一个查询来显示学生的姓名和他们在任何科目中的最高分数。
下一篇:编写一个查询来选择部门中获得最高薪水的员工姓名。