hive学习之经典sql50题 hive版(四)
21.查询男生、女生人数 select f.c,m.cfrom(select count(sid) c from student where ssex='男') fjoin(select count(sid) c from student where ssex='女') m;22.查询名字中含有"风"字的学生信息select * from student where sname like '%风%...
