Extract the 'city' field from the 'address' object within the JSON object in the 'profile' column of the 'users' table.
CREATE TABLE users (profile JSON); INSERT INTO users (profile) VALUES ('{"name": "John Doe", "address": {"city": "New York", "zip": "10001"}}');
```sql
SELECT profile->'address'->>'city' AS city FROM users;
```
```sql
SELECT profile->'address'->>'city' AS city FROM users;
```