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

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%"