just need the mySQL commands for each question using commands such as INNER JOIN and OUTTER JOIN

AUTHOR Column Length Decimal Nulls Author number (primary key) Author last name Author first name AUTHOR_NUM DECIMAL 2 No AUTHOR_LAST CHAR 12 AUTHOR_FIRST CHAR 10 BOOK Nulls BOOK_CODE CHAR No TITLE PUBLISHER CODE CHAR TYPE PRICE PAPERBACK Book code (primary key) Book title Publisher code Book type Book price Paperback (Y, N) CHAR 3 CHAR DECIMAL 4 CHAR 3 WROTE Column Length Decimal Nulls Description BOOK_CODE CHAR No Book code (primary key) Author number (primary key) Sequence number AUTHOR_NUM DECIMAL 2 No SEQUENCE DECIMAL 1 INVENTORY Nulls places BOOK_CODE CHAR No Book code (primary key) DECIMAL 2 No Branch number (primary key) BRANCH NUM ON HAND DECIMAL 2 Units on hand FIGURE 3-28 Table layouts for the Henry Books database (continued)