CREATE TABLE friends (Nickname VARCHAR(40), Name (First VARCHAR(20), Last Varchar(20))

##</code><code>##

SELECT * FROM friends WHERE Name=('John', 'Smith')

##</code><code>##

SELECT * FROM friends WHERE Name.First='John'

##</code><code>##

SELECT Nickname FROM friends WHERE Name.First='John'