Your task is to perform a two-step data migration:
- Add a new column named acquired_at to the machine table. This column should be of the DATE data type.
- Update all records in the machine table:
- Populate the newly created acquired_at column by extracting the date value from the acquired field within the details JSON column.
- After successful extraction, remove the acquired field from the details JSON column.
Use SQLite syntax to write your answer. Descriptions of tables are provided in the right pane.
Write your request in the field below and click the "Check it!" button.