oracle或者mysql中有一張表students表？

selectsex,count(*)人數fromstudentsgroupbysex;或者selectcount(casewhensex='男'thensexend)男性人數,count(casewhensex='女'thensexend)女性人數fromstudents