mysql数据库练习
SELECT * FROM `student`
SELECT count(*) as '人数' FROM student ;
SELECT SUM(exam) as '总成绩' FROM schooldb where studentid='2011001003';
SELECT avg(exam) as '平均分' FROM schooldb WHERE studentid='2011001004';
SELECT max(exam) as '最大值',min(exam)as '最小值',avg(exam) as '平均值' FROM schooldb WHERE subjectid=2;
SELECT AVG(exam) as '平均分' FROM schooldb WHERE subjectid=1 and exam>60;
//....
SELECT sex,count(*) as '人数',addres FROM student GROUP BY sex,addres HAVING sex='男' and count(*)>2;
SELECT count(*) as '人数',gid FROM student GROUP BY gid HAVING count(*)>8;
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步