Learn to Practice Java database query problems

Primary key: sno+ Cno
Table (iv) Teacher (Teacher's table)
Whether the property name data type can be null meaning
TNOVARCHAR2 (3) No faculty number (primary key)
TNAMEVARCHAR2 (4) No Faculty name
TSEXVARCHAR2 (2) No Faculty gender
Tbirthdaydate can be a faculty born
PROFVARCHAR2 (6) Available titles
Departvarchar (10) No Faculty Department
Table 1-2 data in the database
Table (i) Student
Snosnamessexsbirthdayclass
108 Zeng Hua male 1977-09-0195033
105 Kuanming Male 1975-10-0295031
107 Wang Liju 1976-01-2395033
101 Li June Male 1976-02-2095033
109 Wang Fang Female 1975-02-1095031
103 Contacts Male 1974-06-0395031

Table (ii) Course
Cnocnametno
3-105 Introduction to Computers 825
3-245 Operating System 804
6-166 Digital Circuit 856
9-888 Advanced Mathematics 831
Table (iii) score
Snocnodegree
1033-24586
1053-24575
1093-24568
1033-10592
1053-10588
1093-10576
1013-10564
1073-10591
1083-10578
1016-16685
1076-16679
1086-16681
Table (iv) Teacher
Tnotnametsextbirthdayprofdepart
804 Li Chengnan 1958-12-02 Associate Professor Computer Department
856 Zhang Xunan 1969-03-12 Lecturer, Department of Electronic Engineering
825 Wang Ping 1972-05-05 Assistant computer Department
831 Liu Bing 1977-08-14 teaching assistant, Department of Electronic Engineering

1. Query the sname, Ssex, and class columns of all records in the student table.

2, the inquiry teacher all units namely does not duplicate depart column.

3. Query all records of student table.

4. Query all records from 60 to 80 of the scores in the score table.

5. Check the record of 85, 86 or 88 in the score table.

6, inquires the student table "95031" class or the sex is "the female" the classmate record.

7. Query the student table for all records in descending order of class.

8, in CNO Ascending, Degree descending query score all records of the table.

9. Check the number of students in "95031" class.

Learn to Practice Java database query problems