human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
Give me the name of all reviewers.
assistant
SELECT name FROM Reviewer;
human
Whose name contains 'Mike'?
assistant
SELECT name FROM Reviewer WHERE name LIKE '%Mike%';
human
What about his id?
assistant
SELECT rID FROM Reviewer WHERE name LIKE "%Mike%" ;