Exercise: Archive Graduates
Copy graduated students to archive.
Solution
sql
1INSERT INTO archive_students
2SELECT * FROM students WHERE status = 'graduated';
Copy graduated students to archive.
1INSERT INTO archive_students
2SELECT * FROM students WHERE status = 'graduated';