283. INSERT with SELECT

1INSERT INTO archive (name, course)
2SELECT name, course FROM students WHERE graduated = 1;