cs327e Lab 4 and 5 Solution

# The University of Texas

CS 327e

Fall 2004

### Lab 4 and 5 Solution

Due: 2004-11-05 Friday 8.30 a.m.

Total points = 200. There is NO late submission allowed. In other words, you receive 0 points if you submit late!

PURPOSE:

The purpose of this lab is to learn about SELECT statement in SQL.

IMPLEMENTATION:

For this lab, consider the PUBS database in the Excel spreadsheet, as well its schema, both of which are zipped up and shown below. Just as in lab1, you will need to import this spreadsheet into tables in your account.

For each of the English statement,

a) Submit the correct SELECT statement, along with

b) Resultant data from the PUBS database.

NOTE: There is more than 1 correct SQL answer to solve each query. You are only required to submit 1 correct SQL statement per query. Clearly state any assumptions you make.

NOTE: Refer to last semester’s Lab4 for some practice queries.

For these queries, consider the following tables from the schema:

EMPLOYEE

AUTHORS

JOBS

DISCOUNTS

TITLEAUTHOR

STORES

SALES

PUBLISHERS

ROYSCHED

TITLES

NOTE: Blanks in the Excel spreadsheet imply null data. (e.g. the publisher Lucerne Publishing state is NULL).

NOTE: In all of the queries below, when asked for

a) Author, give their first and last name.

b) Title, give only their description (titles.title).

c) Year, give the 4 digit year 19xx.

d) Publisher, give their name.

e) Store, give their name.

Query1) Give all authors who live on Avenues, and don’t have a “0” in their phone number. (10 points)

SELECT au_fname author_first_name, au_lname author_last_name

FROM authors

WHERE

(address like '%Av.%')

AND

(phone not like '%0%')

author_first_name author_last_name

Dean Straight

Dirk Stringer

Query2) Give the year, along with the number of employees hired in that year. (You can assume that all hiring years have the ‘19xx’ format.) (10 points)

SELECT Hiring_Year, SUM (Num_Employees_Hired) Total_Hired_Employees

FROM

(

SELECT substring (cast (hire_date as char(26)),8,4) AS Hiring_Year, COUNT (hire_date) AS Num_Employees_Hired

FROM employee

GROUP BY hire_date

) EMP

GROUP BY Hiring_Year

Hiring_Year Total_Hired_Employees

1988 4

1989 7

1990 8

1991 7

1992 7

1993 7

1994 3

Query3) For each state that an author resides in, give me the count of contract and non-contract authors. (10 points)

(HINT: Use CASE statements, along with a special kind of JOIN)

Select

(case when sConAuth.s is null then sNonConAuth.s else sConAuth.s end) State,

(case when sConAuth.cntContract is null then 0 else sConAuth.cntContract end) CntContractAuth,

(case when sNonConAuth.cntNonContract is null then 0 else sNonConAuth.cntNonContract end) CntNonContractAuth

From

(

SELECT state s, COUNT (contract) cntContract

FROM authors

WHERE contract = '1'

GROUP BY state

) sConAuth

FULL OUTER JOIN

(

SELECT state s, COUNT (contract) cntNonContract

FROM authors

WHERE contract = '0'

GROUP BY state

) sNonConAuth

ON

sConAuth.s = sNonConAuth.s

State CntContractAuth CntNonContractAuth

CA 13 2

IN 1 0

KS 0 1

MD 1 0

MI 1 0

OR 1 0

TN 0 1

UT 2 0

Query4) Give me all USA Publishers that have “Pub” in their names. (10 points)

SELECT pub_name NAME

FROM publishers

WHERE

pub_name LIKE '%Pub%'

AND

country = 'USA'

NAME

Five Lakes Publishing

Ramona Publishers

Query5) For each store where a sale occurred, give me

· The total quantity of titles sold in that store

· The average quantity of titles (show only 2 decimal places) sold in that store

· The total quantity of titles sold across all stores

· The average quantity of titles (show only 2 decimal places) sold across all stores

The resultant data should be sorted by “The total quantity of titles in that store” in descending order.

(20 points)

{HINT: Use the SQL Server CONVERT/CAST function to get average in 2 decimal places}

SELECT

S.stor_name STORE_NAME,

StoTotSales.StoTotQty STORE_TOTAL_QTY,

CAST (StoAvgSales.StoAvgQty AS DECIMAL (10,2)) STORE_AVERAGE_QTY,

TotSales.TotQty TOTAL_QTY,

CAST (AvgSales.AvgQty AS DECIMAL (10,2)) AVERAGE_QTY

FROM

stores S,

(

SELECT stor_id stor_id, SUM(Qty) StoTotQty

FROM Sales

GROUP BY stor_id

) StoTotSales,

(

SELECT SUM(Qty) TotQty

FROM Sales

) TotSales,

(

SELECT stor_id stor_id, AVG(Qty) StoAvgQty

FROM Sales

GROUP BY stor_id

) StoAvgSales,

(

SELECT AVG(Qty) AvgQty

FROM Sales

) AvgSales

WHERE

S.stor_id = StoTotSales.stor_id

AND

StoTotSales.stor_id = StoAvgSales.stor_id

ORDER BY StoTotSales.StoTotQty DESC

STORE_NAME STORE_TOTAL_QTY STORE_AVERAGE_QTY TOTAL_QTY AVERAGE_QTY

Doc-U-Mat: Quality Laundry and Books 130 21.67 493 23.48

Barnum's 125 62.50 493 23.48

News & Brews 90 22.50 493 23.48

Bookbeat 80 20.00 493 23.48

Fricative Bookshop 60 20.00 493 23.48

Eric the Read Books 8 4.00 493 23.48

Query6) Give the names of authors, and their titles, along with their quantities sold (must be at least 32 quantities of this title), who have not published a single psychology title. (20 points)

SELECT a.au_fname Author_First_Name, a.au_lname Author_Last_Name, t.title Title, SUM (s.qty) Quantity_Sold

FROM sales s, titles t, titleauthor ta, authors a

WHERE

s.title_id = t.title_id

AND

t.title_id = ta.title_id

AND

ta.au_id = a.au_id

AND

ta.au_id NOT IN

(

SELECT DISTINCT ta.au_id

FROM titles t, titleauthor ta

WHERE

t.title_id = ta.title_id

AND

t.type = 'psychology'

)

GROUP BY

a.au_fname, a.au_lname, t.title

HAVING SUM (s.qty) >= 32

Author_First_Name Author_Last_Name Title Quantity_Sold

Ann Dull Secrets of Silicon Valley 50

Marjorie Green You Can Combat Computer Stress! 35

Michel DeFrance The Gourmet Microwave 40

Sheryl Hunter Secrets of Silicon Valley 50

Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean 40

Query7) Give the titles, along with their authors and publishers, that didn’t sell. (20 points)

{HINT: Not all titles have authors and vice versa}

SELECT t.title Title, a.au_fname Author_First_Name, a.au_lname Author_Last_Name, p.pub_name Publisher

FROM

(

(

(titles t

LEFT OUTER JOIN

titleauthor ta

ON t.title_id = ta.title_id

)

LEFT OUTER JOIN authors a

ON ta.au_id = a.au_id

)LEFT OUTER JOIN publishers p

ON t.pub_id = p.pub_id

)

WHERE

t.title_id NOT IN

(

SELECT DISTINCT title_id

FROM sales

)

Title Author_First_Name Author_Last_Name Publisher

The Psychology of Computer Cooking ? ? Binnet & Hardley

Net Etiquette Charlene Locksley Algodata Infosystems

Query8) Give the authors, the state they live in, their title, the store in which a sale of this title occurred, the store state, for all out-of-state sales. An out-of-state sale is a sale occurring in a store whose state is not the same as the author’s state. (20 points)

SELECT a.au_fname Author_First_Name, a.au_lname Author_Last_Name, a.state Author_State, t.title Title, st.stor_name Store , st.state Store_State

FROM authors a, titleauthor ta, titles t, sales s, stores st

WHERE

a.au_id = ta.au_id

AND

ta.title_id = t.title_id

AND

t.title_id = s.title_id

AND

s.stor_id = st.stor_id

AND

st.state <> a.state

Author_First_Name Author_Last_Name Author_State Title Store Store_State

Abraham Bennet CA The Busy Executive's Database Guide Bookbeat OR

Abraham Bennet CA The Busy Executive's Database Guide Eric the Read Books WA

Albert Ringer UT Is Anger the Enemy? Barnum's CA

Albert Ringer UT Is Anger the Enemy? Doc-U-Mat: Quality Laundry and Books WA

Albert Ringer UT Is Anger the Enemy? Eric the Read Books WA

Albert Ringer UT Is Anger the Enemy? News & Brews CA

Albert Ringer UT Life Without Fear Doc-U-Mat: Quality Laundry and Books WA

Anne Ringer UT Is Anger the Enemy? Barnum's CA

Anne Ringer UT Is Anger the Enemy? Doc-U-Mat: Quality Laundry and Books WA

Anne Ringer UT Is Anger the Enemy? Eric the Read Books WA

Anne Ringer UT Is Anger the Enemy? News & Brews CA

Anne Ringer UT The Gourmet Microwave Bookbeat OR

Anne Ringer UT The Gourmet Microwave Doc-U-Mat: Quality Laundry and Books WA

Charlene Locksley CA Emotional Security: A New Algorithm Doc-U-Mat: Quality Laundry and Books WA

Cheryl Carson CA But Is It User Friendly? Bookbeat OR

Innes del Castillo MI Silicon Valley Gastronomic Treats Fricative Bookshop CA

Johnson White CA Prolonged Data Deprivation: Four Case Studies Doc-U-Mat: Quality Laundry and Books WA

Livia Karsen CA Computer Phobic AND Non-Phobic Individuals: Behavior Variations Doc-U-Mat: Quality Laundry and Books WA

Marjorie Green CA The Busy Executive's Database Guide Bookbeat OR

Marjorie Green CA The Busy Executive's Database Guide Eric the Read Books WA

Michael O'Leary CA Cooking with Computers: Surreptitious Balance Sheets Bookbeat OR

Michel DeFrance IN The Gourmet Microwave Bookbeat OR

Michel DeFrance IN The Gourmet Microwave Doc-U-Mat: Quality Laundry and Books WA

Reginald Blotchet-Halls OR Fifty Years in Buckingham Palace Kitchens News & Brews CA

Stearns MacFeather CA Computer Phobic AND Non-Phobic Individuals: Behavior Variations Doc-U-Mat: Quality Laundry and Books WA

Stearns MacFeather CA Cooking with Computers: Surreptitious Balance Sheets Bookbeat OR

Sylvia Panteley MD Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean News & Brews CA

Query9) For each state in which an author lives in, give the following measures from stores that are in the same state as the author’s.

· The total number of sales that occurred

· The total number of unique titles sold

· The total quantity of titles sold

· The Percent to total of quantities sold. This is calculated as

(A/B) * 100.00

Where

A = The total quantity of titles sold for this state.

B = The total quantity of titles sold across all states.

· The average quantity of titles sold

NOTE: If there is a state in which an author resides, but no stores in that state had any sales, return “0” for all of the measures.

NOTE: Sort the data by “The Percent to Total” measure (descending), followed by state (ascending). (20 points)

SELECT DISTINCT

a.state Author_State,

(

CASE

WHEN salesmetrics.StNumSales is NULL THEN 0

ELSE salesmetrics.StNumSales

END ) StateNumSales,

(

CASE

WHEN salesmetrics.StNumTitles is NULL THEN 0

ELSE salesmetrics.StNumTitles

END ) StateTitles,

(

CASE

WHEN salesmetrics.StTotTitles is NULL THEN 0

ELSE salesmetrics.StTotTitles

END ) StateTotalSales,

(

CASE

WHEN salesmetrics.StAvgTitles is NULL THEN 0

ELSE salesmetrics.StAvgTitles

END ) StateAvgSales,

(

CASE

WHEN ((salesmetrics.StTotTitles * 100.00)/nullif ((GrandSales.TotalSalesAllStates),0)) is NULL THEN 0.00

ELSE cast ((((salesmetrics.StTotTitles * 100.00)/nullif ((GrandSales.TotalSalesAllStates),0))) AS decimal(10,2))

END ) PercentToTotalSales

FROM authors a LEFT OUTER JOIN

(

SELECT st.state state, count (s.title_id) StNumSales, count (DISTINCT s.title_id) StNumTitles, sum (s.qty) StTotTitles, avg (s.qty) StAvgTitles

FROM sales s, stores st

WHERE s.stor_id = st.stor_id

GROUP BY st.state

) salesMetrics

ON a.state = salesMetrics.state,

(

SELECT sum(qty) TotalSalesAllStates

FROM sales

) GrandSales

ORDER BY PercentToTotalSales DESC, Author_State ASC

Author_State StateNumSales StateTitles StateTotalSales StateAvgSales PercentToTotalSales

CA 9 8 275 31 55.78

OR 4 4 80 20 16.23

IN 0 0 0 0 0.00

KS 0 0 0 0 0.00

MD 0 0 0 0 0.00

MI 0 0 0 0 0.00

TN 0 0 0 0 0.00

UT 0 0 0 0 0.00

Query10) Give the name(s) of publishers who sold the most quantity of psychology titles. (10 points)

SELECT pub_name Publisher

FROM

(

SELECT pub_psyc_qty.pub_name pub_name, MAX (pub_psyc_qty.qty) max_qty

FROM

(

SELECT p.pub_name pub_name, SUM (s.qty) qty

FROM Publishers p, Titles t, Sales s

WHERE

s.title_id = t.title_id

AND

t.pub_id = p.pub_id

AND

t.type = ‘psychology’

GROUP BY p.pub_name

) pub_psyc_qty

GROUP BY pub_psyc_qty.pub_name

) pub_psyc_max_qty

Publisher

Binnet & Hardley

New Moon Books

Query11) Give the name(s) of above-average authors. Above Average authors are authors who sold more than the average sales across all authors. Average sales across all authors is defined as the total sales across all authors, divided by the total number of authors.(10 points)

SELECT DISTINCT a.au_lname AUTHOR_LAST_NAME, a.au_fname AUTHOR_FIRST_NAME

FROM Authors a,

(

SELECT ta.au_id au_id , SUM (s.qty * t.price) Tot_Sales

FROM Sales s, Titles t, TitleAuthor ta

WHERE

s.title_id = t.title_id

AND
t.title_id = ta.title_id

GROUP BY ta.au_id

HAVING SUM (s.qty * t.price)

>

(

SELECT (st.Tot_Sales/NULLIF (a.Tot_Authors, 0)) Avg_Sales

FROM

(

SELECT SUM (s.qty * t.price) Tot_Sales

FROM Sales s, Titles t

WHERE s.title_id = t.title_id

) st,

(

SELECT COUNT(*) Tot_Authors

FROM Authors

) a

)

) Auth_Above_Avg_Sales

WHERE

a.au_id = Auth_Above_Avg_Sales.au_id

AUTHOR_LAST_NAME AUTHOR_FIRST_NAME

Bennet Abraham

Carson Cheryl

Dull Ann

Green Marjorie

Gringlesby Burt

Hunter Sheryl

Karsen Livia

MacFeather Stearns

O'Leary Michael

Panteley Sylvia

Ringer Albert

Ringer Anne

Straight Dean

White Johnson

Yokomoto Akiko

Query12) Give the name(s) of above-average selling authors. Above Average authors are authors who sold more than the average sales across all selling authors. Average sales across all selling authors is defined as the total sales across all authors, divided by the total number of authors who had at least 1 sale. (10 points)

SELECT DISTINCT a.au_lname AUTHOR_LAST_NAME, a.au_fname AUTHOR_FIRST_NAME

FROM Authors a,

(

SELECT ta.au_id au_id, SUM (s.qty * t.price) Tot_Sales

FROM Sales s, Titles t, TitleAuthor ta

WHERE

s.title_id = t.title_id

AND
t.title_id = ta.title_id

GROUP BY ta.au_id

HAVING SUM (s.qty * t.price)

>

(

SELECT (st.Tot_Sales/NULLIF (a.Tot_Authors, 0)) Avg_Sales

FROM

(

SELECT SUM (s.qty * t.price) Tot_Sales

FROM Sales s, Titles t

WHERE s.title_id = t.title_id

) st,

(SELECT COUNT(DISTINCT ta.au_id) Tot_Authors

FROM Sales s, Titles t, TitleAuthor ta

WHERE

s.title_id = t.title_id

AND
t.title_id = ta.title_id

) a

)

) Auth_Above_Avg_Sales

WHERE

a.au_id = Auth_Above_Avg_Sales.au_id

AUTHOR_LAST_NAME AUTHOR_FIRST_NAME

Carson Cheryl

Dull Ann

Green Marjorie

Hunter Sheryl

Karsen Livia

MacFeather Stearns

O'Leary Michael

Panteley Sylvia

Ringer Albert

Ringer Anne

Query13) Give the names of authors whose titles have a “?”, or who live in California. (10 points)

SELECT a.au_lname author_last_name, a.au_fname author_first_name

FROM authors a, titleauthor at, titles t

WHERE

a.au_id = at.au_id

AND

at.title_id = t.title_id

AND

t.title LIKE ‘%?%’

UNION

SELECT a.au_lname author_last_name, a.au_fname author_first_name

FROM authors a

WHERE a.state = ‘CA’

author_last_name author_first_name

Bennet Abraham

Carson Cheryl

Dull Ann

Green Marjorie

Gringlesby Burt

Hunter Sheryl

Karsen Livia

Locksley Charlene

MacFeather Stearns

McBadden Heather

O'Leary Michael

Ringer Albert

Ringer Anne

Straight Dean

Stringer Dirk

White Johnson

Yokomoto Akiko

Query14) For each (selling author, title), list all the other distinct selling authors and their titles who have sold at least 1 title of the same title type. Note that if a selling author does not have any other authors selling the same title type, then don’t list that author. Columns returned will include

· AuthorFirstName

· AuthorLastName

· TitleSold

· OtherAuthorFirstName

· OtherAuthorLastName

· OtherTitleSold

SELECT DISTINCT

a.au_fname AuthorFirstName,

a.au_lname AuthorLastName,

t.title TitleSold,

o.au_fname OtherAuthorFirstName,

o.au_lname OtherAuthorLastName,

o.title OtherTitleSold

FROM

Authors a,

Titles t,

Titleauthor ta,

Sales s,

(

SELECT DISTINCT

a.au_id au_id,

a.au_fname Au_FName,

a.au_lname Au_LName,

t.title Title,

t.type Type

FROM

Authors a,

Titles t,

Titleauthor ta,

Sales s

WHERE

a.au_id = ta.au_id

AND

Ta.title_id = t.title_id

AND

t.title_id = s.title_id

) o

WHERE

a.au_id = ta.au_id

AND

Ta.title_id = t.title_id

AND

t.title_id = s.title_id

AND

t.type = o.type

AND

a.au_id <> o.au_id

AuthorFirstName AuthorLastName TitleSold OtherAuthorFirstName OtherAuthorLastName OtherTitleSold

Abraham Bennet The Busy Executive's Database Guide Dean Straight Straight Talk About Computers

Abraham Bennet The Busy Executive's Database Guide Marjorie Green The Busy Executive's Database Guide

Abraham Bennet The Busy Executive's Database Guide Marjorie Green You Can Combat Computer Stress!

Abraham Bennet The Busy Executive's Database Guide Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets

Abraham Bennet The Busy Executive's Database Guide Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets

Akiko Yokomoto Sushi, Anyone? Burt Gringlesby Sushi, Anyone?

Akiko Yokomoto Sushi, Anyone? Michael O'Leary Sushi, Anyone?

Akiko Yokomoto Sushi, Anyone? Reginald Blotchet-Halls Fifty Years in Buckingham Palace Kitchens

Akiko Yokomoto Sushi, Anyone? Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean

Albert Ringer Is Anger the Enemy? Anne Ringer Is Anger the Enemy?

Albert Ringer Is Anger the Enemy? Charlene Locksley Emotional Security: A New Algorithm

Albert Ringer Is Anger the Enemy? Johnson White Prolonged Data Deprivation: Four Case Studies

Albert Ringer Is Anger the Enemy? Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Albert Ringer Is Anger the Enemy? Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Albert Ringer Life Without Fear Anne Ringer Is Anger the Enemy?

Albert Ringer Life Without Fear Charlene Locksley Emotional Security: A New Algorithm

Albert Ringer Life Without Fear Johnson White Prolonged Data Deprivation: Four Case Studies

Albert Ringer Life Without Fear Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Albert Ringer Life Without Fear Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Ann Dull Secrets of Silicon Valley Cheryl Carson But Is It User Friendly?

Ann Dull Secrets of Silicon Valley Sheryl Hunter Secrets of Silicon Valley

Anne Ringer Is Anger the Enemy? Albert Ringer Is Anger the Enemy?

Anne Ringer Is Anger the Enemy? Albert Ringer Life Without Fear

Anne Ringer Is Anger the Enemy? Charlene Locksley Emotional Security: A New Algorithm

Anne Ringer Is Anger the Enemy? Johnson White Prolonged Data Deprivation: Four Case Studies

Anne Ringer Is Anger the Enemy? Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Anne Ringer Is Anger the Enemy? Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Anne Ringer The Gourmet Microwave Innes del Castillo Silicon Valley Gastronomic Treats

Anne Ringer The Gourmet Microwave Michel DeFrance The Gourmet Microwave

Burt Gringlesby Sushi, Anyone? Akiko Yokomoto Sushi, Anyone?

Burt Gringlesby Sushi, Anyone? Michael O'Leary Sushi, Anyone?

Burt Gringlesby Sushi, Anyone? Reginald Blotchet-Halls Fifty Years in Buckingham Palace Kitchens

Burt Gringlesby Sushi, Anyone? Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean

Charlene Locksley Emotional Security: A New Algorithm Albert Ringer Is Anger the Enemy?

Charlene Locksley Emotional Security: A New Algorithm Albert Ringer Life Without Fear

Charlene Locksley Emotional Security: A New Algorithm Anne Ringer Is Anger the Enemy?

Charlene Locksley Emotional Security: A New Algorithm Johnson White Prolonged Data Deprivation: Four Case Studies

Charlene Locksley Emotional Security: A New Algorithm Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Charlene Locksley Emotional Security: A New Algorithm Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Cheryl Carson But Is It User Friendly? Ann Dull Secrets of Silicon Valley

Cheryl Carson But Is It User Friendly? Sheryl Hunter Secrets of Silicon Valley

Dean Straight Straight Talk About Computers Abraham Bennet The Busy Executive's Database Guide

Dean Straight Straight Talk About Computers Marjorie Green The Busy Executive's Database Guide

Dean Straight Straight Talk About Computers Marjorie Green You Can Combat Computer Stress!

Dean Straight Straight Talk About Computers Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets

Dean Straight Straight Talk About Computers Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets

Innes del Castillo Silicon Valley Gastronomic Treats Anne Ringer The Gourmet Microwave

Innes del Castillo Silicon Valley Gastronomic Treats Michel DeFrance The Gourmet Microwave

Johnson White Prolonged Data Deprivation: Four Case Studies Albert Ringer Is Anger the Enemy?

Johnson White Prolonged Data Deprivation: Four Case Studies Albert Ringer Life Without Fear

Johnson White Prolonged Data Deprivation: Four Case Studies Anne Ringer Is Anger the Enemy?

Johnson White Prolonged Data Deprivation: Four Case Studies Charlene Locksley Emotional Security: A New Algorithm

Johnson White Prolonged Data Deprivation: Four Case Studies Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Johnson White Prolonged Data Deprivation: Four Case Studies Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations Albert Ringer Is Anger the Enemy?

Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations Albert Ringer Life Without Fear

Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations Anne Ringer Is Anger the Enemy?

Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations Charlene Locksley Emotional Security: A New Algorithm

Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations Johnson White Prolonged Data Deprivation: Four Case Studies

Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Marjorie Green The Busy Executive's Database Guide Abraham Bennet The Busy Executive's Database Guide

Marjorie Green The Busy Executive's Database Guide Dean Straight Straight Talk About Computers

Marjorie Green The Busy Executive's Database Guide Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets

Marjorie Green The Busy Executive's Database Guide Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets

Marjorie Green You Can Combat Computer Stress! Abraham Bennet The Busy Executive's Database Guide

Marjorie Green You Can Combat Computer Stress! Dean Straight Straight Talk About Computers

Marjorie Green You Can Combat Computer Stress! Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets

Marjorie Green You Can Combat Computer Stress! Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets

Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets Abraham Bennet The Busy Executive's Database Guide

Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets Dean Straight Straight Talk About Computers

Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets Marjorie Green The Busy Executive's Database Guide

Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets Marjorie Green You Can Combat Computer Stress!

Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets

Michael O'Leary Sushi, Anyone? Akiko Yokomoto Sushi, Anyone?

Michael O'Leary Sushi, Anyone? Burt Gringlesby Sushi, Anyone?

Michael O'Leary Sushi, Anyone? Reginald Blotchet-Halls Fifty Years in Buckingham Palace Kitchens

Michael O'Leary Sushi, Anyone? Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean

Michel DeFrance The Gourmet Microwave Anne Ringer The Gourmet Microwave

Michel DeFrance The Gourmet Microwave Innes del Castillo Silicon Valley Gastronomic Treats

Reginald Blotchet-Halls Fifty Years in Buckingham Palace Kitchens Akiko Yokomoto Sushi, Anyone?

Reginald Blotchet-Halls Fifty Years in Buckingham Palace Kitchens Burt Gringlesby Sushi, Anyone?

Reginald Blotchet-Halls Fifty Years in Buckingham Palace Kitchens Michael O'Leary Sushi, Anyone?

Reginald Blotchet-Halls Fifty Years in Buckingham Palace Kitchens Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean

Sheryl Hunter Secrets of Silicon Valley Ann Dull Secrets of Silicon Valley

Sheryl Hunter Secrets of Silicon Valley Cheryl Carson But Is It User Friendly?

Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations Albert Ringer Is Anger the Enemy?

Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations Albert Ringer Life Without Fear

Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations Anne Ringer Is Anger the Enemy?

Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations Charlene Locksley Emotional Security: A New Algorithm

Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations Johnson White Prolonged Data Deprivation: Four Case Studies

Stearns MacFeather Computer Phobic AND Non-Phobic Individuals: Behavior Variations Livia Karsen Computer Phobic AND Non-Phobic Individuals: Behavior Variations

Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets Abraham Bennet The Busy Executive's Database Guide

Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets Dean Straight Straight Talk About Computers

Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets Marjorie Green The Busy Executive's Database Guide

Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets Marjorie Green You Can Combat Computer Stress!

Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets Michael O'Leary Cooking with Computers: Surreptitious Balance Sheets

Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean Akiko Yokomoto Sushi, Anyone?

Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean Burt Gringlesby Sushi, Anyone?

Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean Michael O'Leary Sushi, Anyone?

Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean Reginald Blotchet-Halls Fifty Years in Buckingham Palace Kitchens

(20 points)

Last Updated: 11/12/2004 12:18:28 AM