Score 5 5. USE SQL TO IMPLEMENT THE FOLLOWING QUERIES. ( 5 point for each sub item, 20 points in total. THESE QUESTIONS ARE EXTRA REWARD QUESTIONS, TYPING MISTAKES DOES NOT DEDUCT POINTS, ANSWERING CORRECTLY ADDS POINTS.) There exist a Database which includes relations Student, Course and SC. Please answer the following questions, such as data query, data update and authorization, BY USING SQL: (1) Querying the student number of a student with a failing grade on an exam. (2) Querying the name and age of a student in a non-computer science department who is younger than any of the students in the computer science department. (3) Insert a new student tuple (student number: 201215128; name: Chen Dong; gender: male; department: IS; age: 18) into the Student table. (4) Change the age of student 201215121 to 22 years old.

Score 5 5. USE SQL TO IMPLEMENT THE FOLLOWING QUERIES. (5 point for each sub item, 20 points in total. THESE QUESTIONS ARE EXTRA REWARD QUESTIONS, TYPING MISTAKES DOES NOT DEDUCT POINTS, ANSWERING CORRECTLY ADDS POINTS.) There exist a Database which includes relations Student, Course and SC. Please answer the following questions, such as data query, data update and authorization, BY USING SQL: (1) Querying the student number of a student with a failing grade on an exam. (2) Querying the name and age of a student in a non-computer science department who is younger than any of the students in the computer science department. (3) Insert a new student tuple (student number: 201215128; name: Chen Dong; gender: male; department: IS; age: 18) into the Student table. (4) Change the age of student 201215121 to 22 years old