Which of the following SQL statements lists all books written by the author of The Wok Way to Cook?
a. SELECT title FROM books

WHERE isbn IN (SELECT isbn FROM bookauthor
HAVING authorid IN 'THE WOK WAY TO COOK);

b. SELECT isbn FROM bookauthor

WHERE authorid IN (SELECT authorid FROM books
JOIN bookauthor USING (isbn)
WHERE title = 'THE WOK WAY TO COOK');

c. SELECT title FROM bookauthor

WHERE authorid IN (SELECT authorid FROM books
JOIN bookauthor USING (isbn)
WHERE title = 'THE WOK WAY TO COOK);

d. SELECT isbn FROM bookauthor

HAVING authorid = SELECT authorid FROM books
JOIN bookauthor USING (isbn)
WHERE title = 'THE WOK WAY TO COOK';