To perform these assignments, refer to the tables in the JustLee Books database.

Generate and test two SQL queries for each of the following tasks:

a$)$ the SQL statement needed to perform the stated task with the traditional approach, and

b$)$ the SQL statement needed to perform the stated task with the JOIN keyword.

Apply table aliases in all queries.

$1.$ Create a list that displays the title of each book and the name and phone number of the contact at the publisher$$s office for reordering each book$\mathrm{.}2.$ Determine which orders haven$$t yet shipped and the name of the customer who placed the order. Sort the results by the date on which the order was placed.