Question8: How can I list all California authors regardless of
whether they have written a book?
In database pubs, have a table authors and titleauthor , table authors has a
column state, and titleauhtor have books each author written.
CA behalf of california in table authors.
Question9: How can I get a list of the stores that have bought both
'bussiness' and 'mod_cook' type books?
In database pubs, use three table stores,sales and titles to implement this
equestment.
ow I want to get the result as below:
stor_id stor_name
------- ----------------------------------------
...
7896 Fricative Bookshop
...
...
...