Try to complete the following SQL operations,
(1) insert a record (" 01 ", "li si", "male", 20).
(2) inserted into the "067" the studio staff Numbers for 03, name for "detective" employee records;
(3) change the Numbers for 7 employees name to "six";
(4) all the "067" studio number is changed to "095", (20 points) 2. The students (student id, name, department name and height)
Courses (class, class name, class, first class) course (student id, class, grade)
(1) to find the students take at least 3 course number.
(2) to find the "basis of database course" Jane answered first class number.
(3) to find the "artificial intelligence" course and result of less than 60 minutes student number and name. (subject with nested form) (20 points)
CodePudding user response:
You this is a very basic SQL statements and grammar, recommend myself