<s>[INST] # SQL Query move data from one table to another

I have two tables, `incident` and `incident_history`:

```sql
CREATE TABLE incident (
    incident_id INT PRIMARY KEY,
    title VARCHAR(50) NOT NULL,
    description TEXT,
    status VARCHAR(20) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    closed_at TIMESTAMP NULL,
    deleted_at TIMESTAMP NULL
);

CREATE TABLE incident_history (
    history_id INT PRIMARY KEY,
    incident_id INT NOT NULL,
    status VARCHAR(20) NOT NULL,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (incident_id) REFERENCES incident(incident_id)
);
```

I need a SQL query to move all records with `status = 'closed'` from the `incident` table to the `incident_history` table. I also need to update the `status` to `'archived'` so the record is not moved back if the query is run again.

Here is the query I have so far:

```sql
INSERT INTO incident_history (incident_id, status, updated_at)
SELECT incident_id, 'archived', NOW()
FROM incident
WHERE status = 'closed';
```

What else do I need to add to this query to delete the records from the `incident` table?[/INST]