Use the SP database $($D$2$L$/$content$/$Oracle Public Databases$/$SP DB$)$ to get access to the SP database. This database consisted of $3$ tables and the data model $($click$)$ is in Oracle public database folder.

Your task is to answer the following questions. You must write the SQL statements $($query$)$ and Run the query against the tables in BOOK database. Paste your query in English, SQL command, and result into a notepad, word doc, or pdf using the following format

Question $1$: LIST the Book code and book type for thoes books published by the publishercode $\text{'}$JP$\text{'}$

SELECT book$\_$code, TYPE

FROM book

WHERE publisher$\_$code$=\text{'}$JP$\text{'}$;

BOOK TYP

$0808$ MYS

$8720$ PSY

$9882$ MYS