CREATE TABLE rating (rid DECIMAL, mid DECIMAL, stars DECIMAL, ratingdate TIME)
CREATE TABLE reviewer (rid DECIMAL, name TEXT)
CREATE TABLE movie (mid DECIMAL, title TEXT, year DECIMAL, director TEXT)

Who directed Avatar?
SELECT director FROM movie WHERE title = 'Avatar'
SELECT "director" FROM "movie" WHERE "title" = 'Avatar'