Discuss / SQL / 交作业了
Back

交作业了

Topic source

最酷的芝士意面

#1 Created at ... [Delete] [Delete and Lock User]

1

SELECT class_id,avg(score) from students group by class_id;

2

SELECT class_id,gender,avg(score) from students group by class_id,gender;

  • 1

Reply