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 query below and click "Check it!". Tables are described in the right pane.
The query result will appear here. Ctrl+Enter - Run query