1月5日

#查询报名表中第一志愿为计算机系的人


SELECT * FROM stu_sign
where stu_firstvolunteer in (
SELECT major_name 
from major 
WHERE major_department="计算机系"
)
SELECT * 
FROM stu_sign,major
WHERE stu_sign.stu_firstvolunteer=major.major_name and major_department="计算机系"


SELECT * FROM stu_sign,major
WHERE stu_sign.stu_id=major.major_id and stu_firstvolunteerand major_department="计算机系" 


#查询报名表中第一志愿为计算机系的人数
SELECT count(stu_name)总人数 FROM stu_sign
where stu_firstvolunteer in (
SELECT major_name 
from major 
WHERE major_department="计算机系"