Add to the new_students table a student named Carol Tomas who is in the same grade as Anna Phillips. Table students looks as follows:
name | grade |
|---|---|
Anna Phillips | 2 |
Tom Basil | 3 |
Nancy Smith | 6 |
Table new_students has the same columns name and grade.
Use a query with a subquery for this task!
Hint: Do not use aliases when making a request. Such a request is difficult to verify.
Hint: Don't forget to add spaces to the query when specifying the name. For example, name = 'Anna Phillips' is correct while name='Anna Phillips' is not.
Hint: Do not forget the SELECT query clause order, you can check it in the corresponding topic section.