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

What is the id of the reviewer whose name has substring Mike ?
SELECT rid FROM reviewer WHERE name LIKE "%Mike%"
SELECT "rid" FROM "reviewer" WHERE "name" LIKE "%Mike%"