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.
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.
- 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.
- Produce a list of all customers who live in the state of Florida and have ordered books about computers.0