To perform these assignments refer to the tables in the JUST

To perform these assignments, refer to the tables in the JUSTLEE Books database. Use a subquery to accomplish each task. Make sure to execute query plan to use as the subquery to verify results before writing the entire SQL query.


Determine which books were published by the publisher of The Wok Way to Cook.


So far i got...
SELECT title FROM books WHERE pubid =

Solution

SELECT title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = \"The WOK WAY TO COOK\")