数据库应用技术---案例.docVIP

select USE student GO SELECT stud_id, name, birthday, gender, mark FROM stud_info WHERE name LIKE N郑_ USE student GO SELECT teacher_id, name, tech_title, salary FROM teacher_info WHERE tech_title IN (N助教, N讲师, N副教授) USE student GO SELECT AVG (grade) FROM stud_grade WHERE course_id=0401010102 USE student GO SELECT stud_id 学号, name 姓名, year(getdate())-year(birthday) 年龄, birthday 出生日期 FROM stud_info WHERE gender = N男 ORDER BY birthday ASC SE student GO SELECT substring(stud_id,5,2) 专业编号, avg(mark) 平均入学成绩 FROM stud_info WHERE substring(stud_id,3,2) =01 GROUP BY substring(stud_id,5,2)