CS 327e
Fall 2004
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
SELECT
pub_name NAME
FROM
publishers
WHERE
pub_name
LIKE '%Pub%'
AND
country = '
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
(
TotSales.TotQty TOTAL_QTY,
CAST
(
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
Marjorie Green You Can Combat Computer Stress! 35
Michel DeFrance The Gourmet Microwave 40
Sheryl Hunter Secrets of
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
Abraham
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
Cheryl
Innes del Castillo MI Silicon
Valley Gastronomic Treats Fricative
Johnson
Livia
Marjorie
Marjorie
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
Stearns
Stearns
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
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
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
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 ‘%?%’
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
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
Akiko Yokomoto Sushi, Anyone? Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of
the
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
Ann Dull Secrets of Silicon Valley Sheryl Hunter Secrets of
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
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
Burt Gringlesby Sushi, Anyone? Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of
the
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
Cheryl
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
Michael O'Leary Sushi,
Anyone? Sylvia Panteley Onions, Leeks, and Garlic: Cooking Secrets of
the
Michel DeFrance The Gourmet Microwave Anne Ringer The
Gourmet Microwave
Michel DeFrance The Gourmet Microwave Innes del Castillo
Reginald Blotchet-Halls Fifty Years in
Reginald Blotchet-Halls Fifty Years in
Reginald Blotchet-Halls Fifty Years in
Reginald Blotchet-Halls Fifty
Years in
Sheryl Hunter Secrets of Silicon Valley Ann Dull Secrets of
Sheryl Hunter Secrets of Silicon Valley Cheryl
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
(20 points)
Last Updated: 11/12/2004 12:18:28 AM