《数据库整理》数据库上机报告.doc

《数据库整理》数据库上机报告.doc中国矿业大学矿业学院实验报告课程名称 姓名 班级 学号 日期 成绩 教师1・简单的数据查询(1)答:SELECT*FROMStudentsnoclassnosnamessexsbirthday991204jS9902991203j三9902991202js9902991201je9902991104js9901991103js9901991102js9901991101js9901002102xxOOOl002101xxOOOl001202js9902001201js9902001102js9901001101js9901一桃鹏东平建iia方国苗彬王丽莉一山辉大方男女男男男男女男男女女男女男姚藩葛陈李李王张李李牛王许宋1981-05-071980-02-0612-2302-0805-121981-04-0508-0810-0109-2309-191981-06-091980-12-041978-08-011980-04-09(2)答:SELECT 丿s_nameFROMStxident|snosxtame991204991203991202991201991104991103991102991101002102002101001202001201001102001101藩陈李李牛王许宋一桃鵬东平建蕾彬王嵯芝方国莉F3H大山方⑶答::>ELECTs_no^s_name?s_birthdayFROMStudent(THERE(='男丿)Isname►991204991202991201991104991103991101002102峰辉方建彬王姚葛陈李李张李王一山宋大方1981-05-0712-2302-0805-121981-04-051981-10-011980-09-231980-12-041980-04-09SELECT s_nam已s_sex^s_birthdayFROMStudentWHERE(<?1980-01-Of)AND(,女)snosnamessexsbirthday►001102许裤女1978-08-01(5)答:,?ROMStudent- - -YHERE(‘男')AND('李蜕)snosnamesbirthday上991104991103002102李平方李建国李王BnDEI-耳--§..・耳-•1981-05-121981-04-051980-09-23(6)答:^najTieFROMStudentWHERE( |±991204001201王一山(7)答:SELECTt_no,t_name,FROMTeacherWHERE(HOT('讲师”))tno11nameIttitle山军霞军菁大为红永桂喔王陈徐徐李田授w懺教熾授授教副助副教教助L000002ZUUUUU4一000006000007UUUUU8000010(8)答:SELECTs_noFROMChoTcettKERE(scoreISHULL)sno |►-20.^dministrator(54))*□selects_no,