数据库的考题（Database questions）.doc

数据库的考题（Database questions） Query operation 1 1. query the students number, name, gender and professional data from the student form Student in the student database EDUC. Use educ Go Select, sname, Sid, sex, specialty From student Where sex=men 2. query the first 3 lines of data from the Course EDUC curriculum management database Use educ Go Select top 3* From course 3., from the teaching management database EDUC student table Student query the name of the schools professional Use educ Go Select distinct specialty From student 4., from the teaching management database EDUC course Course table, query the credits corresponding course hours (assuming 1 hours per 18 academic hours credits), show the first 5 lines. Use educ Go Select top 5 (credit*18) as class hour From course 5. from the student table Student in the statistics of the number of boys. Use educ Go Select count (*) From student Where sex=men 6. count the number of students from the student form Student. Note that the role of the DISTINCT keyword is to eliminate duplicate rows, that is, each profession is only counted once. Use educ Go Select count (distinct specialty) From student 7., from the student table Student in the statistics of the total number of students, admission scores, AScores the highest score, minimum score, total score (without practical significance, for example only) and the average. Use educ Go Select max (ascores) as highest score, min (ascores) as minimum, Sum (ascores) as total score, str (ascores) as average, count (distinct, student.sid) as total number From, SC, student Group by ascores 8., from the teaching management database EDUC query the students student number, name, the selected course name and achievement information. Use educ Go Select, student.sid, sname, CNAME, grade From, SC, course, student Where student.sid=sc.sid and sc.cid=course.cid 9. check out the number of students who have chosen at least two courses from the course table SC. Use educ Go Select distinct x.sid Fr