Questions:

Using the pubs database answer the following:

1. List the first and last name of all authors with the title ID's of 
   titles they have published. Use descriptive headings (e.g." Last Name",
   "First Name" for authors) and include the names of authors that do
   not have publications.

2. List the names of all publishers that publish business titles. Use a
   descriptive heading for the column and use a subquery for your SQL
   statement. 
   Note: Rewrite the SQL statement using a join. Use the basic join
   discussed in the SQL II notes and SQL92 syntax.

3. List the title and price of all titles written by Anne Ringer. Use a
   subquery.



Solutions:

1.  SELECT au_lname AS 'Last Name', au_fname AS 'First Name', title_id
      FROM authors LEFT OUTER JOIN titleauthor
                	ON authors.au_id = titleauthor.au_id

2.  SELECT pub_name AS Publisher
      FROM publishers
      WHERE pub_id IN (SELECT pub_id
                         FROM titles
                         WHERE type='business')
    Note: See Project #1 for the equivalent join.

3.  SELECT title, price 
      FROM titles
      WHERE title_id IN (SELECT title_id
                           FROM titleauthor
                           WHERE au_id IN (SELECT au_id
                                             FROM authors
                                             WHERE au_lname='Ringer' AND
                                                   au_fname='Anne'))