What is the id of the reviewer whose name has substring “Mike”?
SELECT rID FROM Reviewer WHERE name LIKE "%Mike%"
reviewer name contains 'Mike' refers to name LIKE '%Mike%'; id of the reviewer refers to rID;