Database Exercises 26-45 Questions

1-- -, the inquiry has 85 points above the course CNO.2 SelectDistinct Cno fromScorewhereDegree > -3 4-- -, and the results of the "computer department" Teachers ' teaching courses were queried. 5 Select* fromScorewhereCnoinch(SelectCno fromCoursewhereTnoinch(SelectTno fromTeacherwhereDepart ='Computer Department'))6 7 8--0028, and inquires into the tname and prof of teachers with different titles of "computer department" and "Electronic Engineering department". 9 SelectTname,prof fromTeacher T1whereDepart ='Computer Department'And NOT EXISTS (Select* fromTeacher T2whereDepart ='Department of Electronic Engineering'and T1. Prof =t2.prof)Ten Union One SelectTname,prof fromTeacher T1whereDepart ='Department of Electronic Engineering'And NOT EXISTS (Select* fromTeacher T2whereDepart ='Computer Department'and T1. Prof =t2.prof) A  ---0029, the query elective number is "3- the"The course is at least higher than an elective number"3-245"The CNO, Sno and degree of the classmates, and sorted by degree from high to low order. --any one value, all of the values - Select* fromScorewhereDegree >any (SelectDegree fromScorewherecno='3-245') and Cno ='3-105'ORDER BY degree desc the  --- -, the query elective number is "3- the"And the score is higher than the elective number."3-245"CNO, Sno and degree of the students in the course. - Select* fromScorewhereDegree > All (SelectDegree fromScorewherecno='3-245') and cno='3-105'  -  +-- to, check the name, sex and birthday of all teachers and classmates. -     SelectSname,ssex,sbirthday fromStudent + Union A     SelectTname,tsex,tbirthday fromTeacher at  --- +, query the name, sex and birthday of all "female" teachers and "female" classmates. -     SelectSname,ssex,sbirthday fromStudentwheressex='female' - Union -     SelectTname,tsex,tbirthday fromTeacherwheretsex='female' -  in-- -, and the results of students who have a lower average score than the course.  -     Select* fromScore S1wheredegree< (SelectAVG (degree) fromScore S2 GROUP BY Cno has S1. cno=S2. Cno) to  +-- the, query all teachers tname and depart. -     SelectTname,depart fromTeacherwhereTnoinch(SelectTno fromCoursewhereCnoinch(SelectCno fromscore)) the  *-- *, the Tname and depart of all teachers who have not been lectured. $     SelectTname,depart fromTeacherwhereTno notinch(SelectTno fromCoursewhereCnoinch(SelectCno fromscore))Panax Notoginseng  --- $, check the class number of at least 2 men. --Select all the boys first, then group by class. the     SelectClass fromStudentwheressex='male'GROUP BY Class has COUNT (*) >1 +  A--Panax Notoginseng, query the student table, not the surname "Wang" student records.  the     Select* fromStudentwhereSname not like'Wang%' +  ---0038, query the name and age of each student in the student table.  $--Note: Year (GETDATE ()) Gets the current time "years" getdate () gets $     SelectSname,year (GETDATE ())-year (Sbirthday) asAge fromStudent -  --- the, querying the largest and smallest sbirthday date values in the student table.  the      SelectMAX (Sbirthday), MIN (Sbirthday) fromStudent - Wuyi-- +, querying all records in the student table in the order of class number and age from large to small.  the     Select* fromStudent ORDER BY Class desc,sbirthday ASC -   Wu-- A, query "male" teachers and their courses.  -     SelectCname,tname fromCourse Join Teacher on Course.tno=teacher.tnowheretsex='male'--Union of 2 tabular practices About      $ Select* fromCoursewhereRninch(SelectRn fromTeacherwheretsex='male')    --where procedure -  --- the, Query the SNO, CNO and degree columns of the highest score.  -     SelectSno,cno,degree fromScorewheredegree = (SelectMAX (degree) fromScore)--Method One A  +     SelectTop1* fromScore ORDER BY degree desc--Method Two the  --- +, inquiries and "Li June" with the sex of all the students of the sname. $     SelectSname fromStudentwhereSsex= (SelectSsex fromStudentwhereSname='Li June') and Sname! ='Li June' the  the-- -, inquiries and "Li June" with the same sex and classmates sname. the     SelectSname fromStudentwhereSsex= (SelectSsex fromStudentwhereSname='Li June') and class= (SelectClass fromStudentwhereSname='Li June') and Sname! ='Li June'--Method One the  - SelectSname fromStudent S1wheressex=( in SelectSsex fromStudent S2whereSname='Li June'and S1.class= S2.class the)--Method Two the  About-- $, and query all the "male" students who have enrolled in the "Introduction to Computer" course.  the     Select* fromScorewhereCno= (SelectCno fromCoursewhereCname='Introduction to Computers') and Snoinch(SelectSno fromStudentwheressex='male')--f Method 1

26-45 questions about database exercises