Answer:
Please see explanation below .
Explanation:
Since you have not provided the db schema, I am providing the queries by guessing the table and column names. Feel free to reach out in case of any concerns.
1. SELECT ISBN, TITLE, PUBLICATION_YEAR FROM BOOKS WHERE AUTHOR_ID = (SELECT AUTHOR_ID FROM AUTHOR WHERE AUTHOR_NAME = 'C.J. Cherryh');
2. SELECT COUNT(*) FROM BOOKS;
3. SELECT COUNT(*) FROM ORDERS WHERE CUSTOMER_ID = 11 AND order_filled = 'No';