Advanced Questions (Using Joins)

  1. Display a list of all titles and sales numbers in the Books and Sales tables, including titles that have no sales. Use a join.
  2. Display a list of authors' last names and all associated titles that each author has published sorted by the author's last name. Use a join.  Save it as a view named: Published Authors.
  3. Using a subquery, display all the authors (show last and first name, postal code) who receive a royalty of 100% and live in Alberta. Save it as a view titled: AuthorsView. When creating the view, rename the author's last name and first name as 'Last Name' and 'First Name'.
  4. Display the stores that did not sell the title Is Anger the Enemy?
  5. Display a list of store names for sales after 2013 (Order Date is greater than 2013).  Display store name and order date.
  6. Display a list of titles for books sold in store name "News & Brews".  Display store name, titles, and order dates.
  7. List total sales (qty) by title. Display total quantity and title columns.
  8. List total sales (qty) by type. Display total quantity and type columns.
  9. List total sales (qty*price) by type. Display total dollar value and type columns.
  10. Calculate the total number of types of books by publisher. Show publisher name and total count of types of books for each publisher.
  11. Show publisher names that do not have any type of book.  Display publisher name only.