The conversation between human and AI assistant.
[|Human|] Construct a query to list the titles of all books written by John Smith
[|AI|] SELECT title FROM books WHERE author = 'John Smith';
[|Human|] 
Construct a query to list the titles of all books written by John Smith