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.
Write your request in the field below and click the "Check it!" button.
Use SQLite syntax to write your answer. Descriptions of tables are provided at the bottom of the screen.
