Discuss / SQL / 作业
Back

作业

Topic source

赵楠星

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

SELECT  class_id , AVG(score ) avg_score from students group by class_id ; 

SELECT class_id , gender , AVG(score) FROM students group by class_id , gender ;

  • 1

Reply