查询语句3（Query 3）.docVIP

查询语句3（Query 3） (1) query the basic information of STUDENT, COURSE and SC respectively. SELECT * FROM Student; (2) inquire about all the students name, number of students, their department and their family address. SELECT, Sname, Sno, Sdept, Saddr, FROM, Student; (3) query the names of all students, the year of birth, and the Department and class, requiring lower case letters to indicate the name of the Department, and use the alias to express column headings. SELECT sname 2010-sage name, year of birth, lower (sdept) FROM Student department, class class; (4) ask the students to take courses. SELECT, distinct, SnO, FROM, SC, WHERE, grade, is, null; (5) name, class and age of all students over the age of 20. SELECT, sname, class, sage, FROM, Student, WHERE, sage20; (6) query at the age of 17~19 years (including 17 years old and 19 years old) between the students name, Department, class and age. SELECT, sname, sdept, class, sage, FROM, Student, WHERE, sgae, between,, 17, and, two; (7) inquire about the names and gender of students who are neither the Department of information, the Department of mathematics, nor the Department of computer science. SELECT, sname, ssex, FROM, Student, WHERE, sdept, not, in (` IS, ` MA , CS); (8) name, school number and gender of all students who are surnamed zhang. SELECT, sname, SnO, ssex, FROM, Student, WHERE, sname, like Zhang%; (9) the name of the student who inquires the surname Ouyang and the full name is four characters. SELECT sname FROM Student WHERE sname like Ouyang __.; (10) inquire about the basic information of the students in all home addresses including Chengdu SELECT * FROM, Student, WHERE, saddr, like %%; 2. single table query (1) the names and genders of female students in the Department of inquiry information systems (IS), the Department of Mathematics (MA) and the Department of Computer Science (CS) (using in, and, and and, or, respectively, two ways to query) SELECT, sname, ssex FROM Studen WHERE, sdept, in (` IS, ` C