Discuss / SQL / day day up，打卡第10天，sql开始变复杂了，有点难
Back

day day up，打卡第10天，sql开始变复杂了，有点难

Topic source

Krien-jac

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

SELECT AVG(score) avg_score, class_id FROM students GROUP BY class_id;

SELECT AVG(score) avg_score, class_id, gender FROM students GROUP BY class_id, gender;

  • 1

Reply