Extract the 'title' field from the first object in the 'books' array 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", "books": [{"title": "The Great Gatsby", "author": "F. Scott Fitzgerald"}, {"title": "1984", "author": "George Orwell"}]}');
```sql
SELECT json_extract(profile, '$.books[0].title') AS title FROM users;
```
```sql
SELECT json_extract(profile, '$.books[0].title') AS title FROM users;
```