-- ===================================================================
-- York River Books, Inc., Book Vendor Database

-- Creation script
-- Parke Godfrey, Copyright 2005

-- -------------------------------------------------------------------
-- Schema definition

create table yrb_customer (
    cid   smallint  not null,
    name  varchar(20),
    city  varchar(15),
    constraint yrb_customer_pk
        primary key (cid)
);

create table yrb_club (
    club varchar(15) not null,
    desc varchar(50),
    constraint yrb_club_pk
        primary key (club)
);

create table yrb_member (
    club  varchar(15)  not null,
    cid   smallint     not null,
    constraint yrb_member_pk
        primary key (club, cid),
    constraint yrb_mem_fk_club
        foreign key (club) references yrb_club,
    constraint yrb_mem_fk_cust
        foreign key (cid) references yrb_customer
);

create table yrb_category (
    cat varchar(10) not null,
    constraint yrb_category_pk
        primary key (cat)
);

create table yrb_book (
    title     varchar(25)  not null,
    year      smallint     not null,
    language  varchar(10),
    cat       varchar(10)  not null,
    weight    smallint     not null,
    constraint yrb_book_pk
        primary key (title, year),
    constraint yrb_book_fk_cat
        foreign key (cat) references yrb_category,
    constraint yrb_book_weight
        check (weight > 0)
);

create table yrb_offer (
    club   varchar(15)  not null,
    title  varchar(25)  not null,
    year   smallint     not null,
    price  decimal(5,2) not null,
    constraint yrb_off_pk
        primary key (club, title, year),
    constraint yrb_off_fk_club
        foreign key (club) references yrb_club,
    constraint yrb_off_fk_book
        foreign key (title, year) references yrb_book,
    constraint yrb_off_price
        check (price > 0)
);

create table yrb_purchase (
    cid    smallint     not null,
    club   varchar(15)  not null,
    title  varchar(25)  not null,
    year   smallint     not null,
    when   timestamp    not null,
    qnty   smallint     not null,
    constraint yrb_pur_pk
        primary key (cid, club, title, year, when),
    constraint yrb_pur_fk_offer
        foreign key (club, title, year) references yrb_offer,
    constraint yrb_pur_fk_mem
        foreign key (club, cid) references yrb_member,
    constraint yrb_pur_qnty
        check (qnty > 0)
);

-- A prettier way to view the PURCHASE table.
create view pretty_purchase as
    (select cast (cid as decimal(2)) as cid,
            title,
            club,
            year,
            cast (when as date) as day,
            cast (when as time) as time
        from yrb_purchase);

create table yrb_shipping (
    weight  smallint     not null,
    cost    decimal(5,2) not null,
    constraint yrb_shipping_pk
        primary key (weight),
    constraint yrb_ship_uni_cost
        unique (cost)
);

-- ---------------------------------------------------------------------------
-- Populate with some toy data.

insert into yrb_customer (cid, name, city) values
    (1,'Tracy Turnip','Toronto'),
    (2,'Qfwfq','Pluto'),
    (3,'Fuzzy Fowles','Orilla'),
    (4,'Suzy Sedwick','Ottawa'),
    (5,'Andy Aardverk','Oshawa'),
    (6,'Boswell Biddles','Waterloo'),
    (7,'Cary Cizek','Toronto'),
    (8,'Jack Daniels','Windsor'),
    (9,'Doris Daniels','Windsor'),
    (10,'Egbert Engles','Pembroke'),
    (11,'Sally Mae','Toronto'),
    (12,'Fanny Mae','Mississauga'),
    (13,'Garp Google','Ottawa'),
    (14,'Kathy Lee Gifford','Cornwall'),
    (15,'Henrietta Hogg','Parry Sound'),
    (16,'Ingrid Iverson','Oshawa'),
    (17,'George Gush','Timmins'),
    (18,'Al Bore','Niagara Falls'),
    (19,'Ekksdwl Qjksynn','Pluto'),
    (20,'Finwick Cooper','Guelph'),
    (21,'Jackie Johassen','Bancroft'),
    (22,'Klive Kittlehart','Parry Sound'),
    (23,'Lux Luthor','Lakehead'),
    (24,'Clark Kent','Lakehead'),
    (25,'Margaret Mitchie','Toronto'),
    (26,'George Wolf','Mississauga'),
    (27,'Jorge Lobo','Mississauga'),
    (28,'Phil Regis','Lakehead'),
    (29,'Nigel Nerd','Toronto'),
    (30,'Pretence Parker','Orilla'),
    (31,'Parker Posey','Toronto'),
    (32,'Mark Dogfurry','Toronto'),
    (33,'Oswell Orson','Oshawa'),
    (34,'Quency Quark','Sarnia'),
    (35,'Renee Riztp','Bancroft'),
    (36,'Steve Songheim','Waterloo'),
    (37,'Trixie Trudeau','Waterloo'),
    (38,'Ulya Umbrigde','Ottawa'),
    (39,'Valerie Vixen','Pembroke'),
    (40,'Walter Wynn','Kingston'),
    (41,'Xia Xu','Toronto'),
    (42,'Yves Yonge','Ottawa'),
    (43,'Zachary Zoxx','London'),
    (44,'Zebulon Zilio','Georgetown'),
    (45,'Jack Daniels','London');

insert into yrb_club (club, desc) values
    ('CARP',           'Association of Canadian Retired Persons'),
    ('CAA',            'Canadian Automobile Association'),
    ('Guelph Club',    'University club for the University of Guelph'),
    ('York Club',      'University club for York University'),
    ('UofT Club',      'University club for the Univeristy of Toronto'),
    ('Waterloo Club',  'University club for the University of Waterloo'),
    ('Readers Digest', 'The Readers Digest club'),
    ('Oprah',          'The Oprah Winfrey book club'),
    ('Basic',          'Our basic club'),
    ('YRB Gold',       'Our gold club'),
    ('YRB Silver',     'Our silver club'),
    ('YRB Bronze',     'Our bronze club');

insert into yrb_member (club, cid) values
    ('Basic',1),
    ('Basic',2),
    ('Basic',3),
    ('Basic',4),
    ('Basic',5),
    ('Basic',6),
    ('Basic',7),
    ('Basic',8),
    ('Basic',9),
    ('Basic',10),
    ('Basic',11),
    ('Basic',12),
    ('Basic',13),
    ('Basic',14),
    ('Basic',15),
    ('Basic',16),
    ('Basic',17),
    ('Basic',18),
    ('Basic',19),
    ('Basic',20),
    ('Basic',21),
    ('Basic',22),
    ('Basic',23),
    ('Basic',24),
    ('Basic',25),
    ('Basic',26),
    ('Basic',27),
    ('Basic',28),
    ('Basic',29),
    ('Basic',30),
    ('Basic',32),
    ('Basic',33),
    ('Basic',35),
    ('Basic',36),
    ('Basic',37),
    ('Basic',38),
    ('Basic',39),
    ('Basic',40),
    ('Basic',41),
    ('Basic',42),
    ('Basic',43),
    ('Basic',44),
    ('Basic',45),
    ('CAA',2),
    ('CAA',3),
    ('CAA',6),
    ('CAA',8),
    ('CAA',9),
    ('CAA',12),
    ('CAA',16),
    ('CAA',19),
    ('CAA',21),
    ('CAA',26),
    ('CAA',27),
    ('CAA',29),
    ('CAA',32),
    ('CAA',34),
    ('CAA',37),
    ('CAA',39),
    ('CAA',41),
    ('CAA',44),
    ('CARP',3),
    ('CARP',5),
    ('CARP',10),
    ('CARP',15),
    ('CARP',25),
    ('CARP',33),
    ('CARP',36),
    ('Waterloo Club',4),
    ('Waterloo Club',9),
    ('Waterloo Club',13),
    ('Waterloo Club',21),
    ('Waterloo Club',33),
    ('Waterloo Club',36),
    ('Waterloo Club',38),
    ('Waterloo Club',40),
    ('Waterloo Club',42),
    ('Oprah',2),
    ('Oprah',4),
    ('Oprah',8),
    ('Oprah',9),
    ('Oprah',10),
    ('Oprah',12),
    ('Oprah',13),
    ('Oprah',14),
    ('Oprah',19),
    ('Oprah',20),
    ('Oprah',23),
    ('Oprah',28),
    ('Oprah',32),
    ('Oprah',33),
    ('Oprah',37),
    ('Oprah',38),
    ('Oprah',45),
    ('Readers Digest',1),
    ('Readers Digest',6),
    ('Readers Digest',13),
    ('Readers Digest',20),
    ('Readers Digest',22),
    ('Readers Digest',24),
    ('Readers Digest',30),
    ('Readers Digest',35),
    ('Readers Digest',39),
    ('Readers Digest',42),
    ('Readers Digest',44),
    ('YRB Bronze',3),
    ('YRB Bronze',5),
    ('YRB Bronze',8),
    ('YRB Bronze',22),
    ('YRB Bronze',25),
    ('YRB Bronze',29),
    ('YRB Bronze',34),
    ('YRB Bronze',35),
    ('YRB Bronze',39),
    ('YRB Gold',2),
    ('YRB Gold',7),
    ('YRB Gold',15),
    ('YRB Gold',19),
    ('YRB Gold',22),
    ('YRB Gold',28),
    ('YRB Gold',32),
    ('YRB Gold',43),
    ('YRB Gold',44),
    ('YRB Silver',1),
    ('YRB Silver',4),
    ('YRB Silver',9),
    ('YRB Silver',10),
    ('YRB Silver',11),
    ('YRB Silver',13),
    ('YRB Silver',16),
    ('YRB Silver',21),
    ('YRB Silver',26),
    ('YRB Silver',27),
    ('YRB Silver',30),
    ('YRB Silver',36),
    ('YRB Silver',38),
    ('Guelph Club',3),
    ('Guelph Club',10),
    ('Guelph Club',16),
    ('Guelph Club',22),
    ('Guelph Club',30),
    ('Guelph Club',36),
    ('Guelph Club',39),
    ('UofT Club',29),
    ('UofT Club',34),
    ('UofT Club',35),
    ('UofT Club',44),
    ('York Club',1),
    ('York Club',7),
    ('York Club',16),
    ('York Club',25),
    ('York Club',26),
    ('York Club',27),
    ('York Club',32),
    ('York Club',37),
    ('York Club',42),
    ('York Club',45);

insert into yrb_category (cat) values
    ('children'),
    ('cooking'),
    ('drama'),
    ('guide'),
    ('history'),
    ('horror'),
    ('humor'),
    ('mystery'),
    ('phil'),
    ('romance'),
    ('science'),
    ('travel');

insert into yrb_book (title, year, language, cat, weight) values
    ('Toronto Underground',2001,'English','travel',167),
    ('Tensor Calculus made Easy',1996,'English','science',582),
    ('The Vampires Among Us',1999,'English','horror',192),
    ('Plato Rocks',1975,'Greek','phil',467),
    ('Will Snoopy find Lucy?',1990,'English','mystery',161),
    ('Les Gens Miserable',1996,'French','romance',180),
    ('Tampopo Oishii',1997,'Japanese','romance',238),
    ('Tande mou nai',2002,'Japanese','humor',1171),
    ('Flibber Gibber',2004,'English','drama',51),
    ('La Petite Chou',2001,'French','children',160),
    ('Napolean''s Revenge',1952,'English','history',1479),
    ('Pluto Collides With Mars',2004,'Plutonian','science',428),
    ('Quarks and Other Matter',2000,'English','science',823),
    ('Oberon',1963,'Greek','drama',237),
    ('Yakuza Kekkon Shita',1996,'Japanese','romance',356),
    ('Suzy does Waterloo',2001,'English','travel',201),
    ('Bancroft''s Great!',2003,'English','travel',276),
    ('Yon-juu Hachi',1948,'Japanese','drama',459),
    ('Transmorgifacation',2004,'Plutonian','science',2911),
    ('Oui, Oui, Non!',1992,'French','romance',393),
    ('Rats Like Us',1999,'English','humor',187),
    ('Rats Like Us',1997,'English','science',880),
    ('Alpha Centauri',2002,'Plutonian','travel',461),
    ('Where''s Canada?',1998,'English','travel',262),
    ('Ou est Ce Canada?',1998,'French','travel',250),
    ('Learn How To Vote',2004,'English','guide',153),
    ('Voting for Dummies',2004,'English','guide',251),
    ('Capricia''s Conundrum',1993,'English','romance',159),
    ('Databases aren''t',2004,'English','phil',491),
    ('Databases made Real Hard',2002,'English','science',363),
    ('Montreal est dans Quebec',1999,'French','travel',227),
    ('Tchuss',2002,'German','drama',265),
    ('Nippon no Joodan',2001,'Japanese','humor',352),
    ('Recipes for Humans',2004,'Plutonian','cooking',705),
    ('Vegetables are Good!',2003,'English','children',231),
    ('Vegetables are Good!',1992,'English','cooking',292),
    ('Tampopo Oishii',1999,'Japanese','cooking',276),
    ('I''m Sorry, But No',2003,'English','romance',112),
    ('Radiator Barbecuing',2002,'English','cooking',154),
    ('Please Beam Me Up',2004,'Plutonian','drama',250),
    ('Eigen Eigen',1980,'German','science',659),
    ('Play me a Song',1997,'English','romance',248),
    ('Food for Dummies',2004,'English','cooking',234),
    ('Ringo to Nashi',1997,'Japanese','cooking',334),
    ('Aubergines!',2000,'French','cooking',296),
    ('Nothing but Steak',1995,'English','cooking',338),
    ('SQL Kills!',2003,'English','science',425),
    ('Curiouser and Curiouser',1953,'English','children',308),
    ('Dogs are not Cats',1995,'English','science',340),
    ('Je ne me souvien pas',1997,'French','romance',129),
    ('Okay, Why Not?',2001,'English','romance',197),
    ('Math is fun!',1993,'English','science',590),
    ('Math is fun!',1995,'English','humor',166),
    ('Is Math is fun?',1996,'English','phil',752),
    ('The Stars are not Enough',2002,'English','romance',248),
    ('Bobbie Sue Ellen',1999,'English','drama',247),
    ('Akachan Furu',2003,'Japanese','children',244),
    ('Darmstadt',2004,'German','travel',295),
    ('Been There Done That',2002,'English','romance',91),
    ('Acrimony Made Simple',1996,'English','guide',260),
    ('Tomenatte Kudasai!',2000,'Japanese','romance',342),
    ('Parthenon',2004,'Greek','travel',313),
    ('Where are my Socks?',1998,'English','humor',259),
    ('The Earth is not Enough',2003,'Plutonian','drama',393),
    ('Legacy Software made Fun',2004,'English','guide',557),
    ('Brats like Us',1999,'English','drama',338),
    ('Where are my Socks?',1994,'English','mystery',261),
    ('Yum, Yum, English Cooking',1997,'English','cooking',57),
    ('Cuisine Anglaise!?',1997,'French','cooking',49),
    ('Where art thou Bertha?',2003,'English','romance',289),
    ('Rigor Mortis',1023,'Latin','mystery',244),
    ('Meine Kleine Katze',2002,'German','romance',183),
    ('Pigs are nice',1996,'English','children',144),
    ('Getting into Snork U.',2004,'English','guide',222),
    ('Are my feet too big?',1993,'English','romance',147),
    ('Live in London?!',2002,'English','travel',71),
    ('Not That London!',2003,'English','travel',132),
    ('Rabbits are nice',1996,'English','children',119),
    ('Rabbits are nice',2004,'English','cooking',186),
    ('Under Your Bed',2004,'English','mystery',147),
    ('Strike Once, Strike Twice',2004,'English','guide',198),
    ('Cats are not Dogs',1996,'English','science',353),
    ('Chats ne sont pas Chiens',1996,'French','science',328),
    ('The Fickle Pickle',2004,'English','cooking',285),
    ('I don''t think so',2001,'English','romance',139),
    ('Quantum Databases',2003,'English','science',731),
    ('Are my feet too big?',1997,'English','guide',128),
    ('Tsukimono to Tsukemono',2004,'Japanese','romance',79),
    ('Tropical Windsor',2004,'English','travel',185),
    ('Montreal pour les Idiots',2002,'French','travel',344),
    ('Base de Donne',2003,'French','guide',251),
    ('The Wiley Snark',1980,'English','mystery',187),
    ('Press the Red Button!',2003,'Plutonian','drama',564),
    ('Relational Algebra',2004,'English','humor',144),
    ('Ottawa Hot Spots',2002,'English','travel',169),
    ('Gigabytes still to go',2001,'English','drama',227),
    ('DB2, DB3, and Beyond!',2004,'English','guide',429),
    ('DB2 Made Simple',2003,'Greek','guide',1142),
    ('Avarice is Good',1998,'English','guide',2198),
    ('Humor in SQL',2004,'English','humor',292);

insert into yrb_offer (title, year, club, price) values
    ('Toronto Underground',2001,'Basic',15.95),
    ('Toronto Underground',2001,'YRB Bronze',15.45),
    ('Toronto Underground',2001,'York Club',12.95),
    ('Toronto Underground',2001,'UofT Club',12.95),
    ('Toronto Underground',2001,'CAA',13.95),
    ('Toronto Underground',2001,'CARP',14.95),
    ('Toronto Underground',2001,'YRB Silver',14.95),
    ('Toronto Underground',2001,'YRB Gold',14.45),
    ('Tensor Calculus made Easy',1996,'Basic',59.95),
    ('Tensor Calculus made Easy',1996,'YRB Bronze',56.95),
    ('Tensor Calculus made Easy',1996,'York Club',49.95),
    ('Tensor Calculus made Easy',1996,'UofT Club',54.95),
    ('Tensor Calculus made Easy',1996,'Waterloo Club',54.95),
    ('Tensor Calculus made Easy',1996,'YRB Silver',53.95),
    ('Tensor Calculus made Easy',1996,'Guelph Club',51.95),
    ('Tensor Calculus made Easy',1996,'YRB Gold',50.95),
    ('The Vampires Among Us',1999,'Basic',19.95),
    ('The Vampires Among Us',1999,'YRB Bronze',18.95),
    ('The Vampires Among Us',1999,'UofT Club',18.95),
    ('The Vampires Among Us',1999,'Readers Digest',17.95),
    ('The Vampires Among Us',1999,'CARP',19.95),
    ('The Vampires Among Us',1999,'YRB Silver',17.95),
    ('The Vampires Among Us',1999,'YRB Gold',16.95),
    ('The Vampires Among Us',1999,'Oprah',16.95),
    ('The Vampires Among Us',1999,'York Club',18.95),
    ('The Vampires Among Us',1999,'Guelph Club',18.95),
    ('Plato Rocks',1975,'Basic',39.95),
    ('Plato Rocks',1975,'YRB Bronze',38.95),
    ('Plato Rocks',1975,'York Club',35.95),
    ('Plato Rocks',1975,'UofT Club',34.95),
    ('Plato Rocks',1975,'Waterloo Club',36.95),
    ('Plato Rocks',1975,'CARP',36.95),
    ('Plato Rocks',1975,'YRB Silver',37.95),
    ('Plato Rocks',1975,'Guelph Club',35.95),
    ('Plato Rocks',1975,'YRB Gold',36.95),
    ('Will Snoopy find Lucy?',1990,'Basic',15.95),
    ('Will Snoopy find Lucy?',1990,'YRB Bronze',14.95),
    ('Will Snoopy find Lucy?',1990,'UofT Club',14.45),
    ('Will Snoopy find Lucy?',1990,'CAA',14.95),
    ('Will Snoopy find Lucy?',1990,'Readers Digest',13.95),
    ('Will Snoopy find Lucy?',1990,'CARP',12.95),
    ('Will Snoopy find Lucy?',1990,'YRB Silver',13.95),
    ('Will Snoopy find Lucy?',1990,'YRB Gold',12.95),
    ('Will Snoopy find Lucy?',1990,'Oprah',14.95),
    ('Will Snoopy find Lucy?',1990,'York Club',14.45),
    ('Will Snoopy find Lucy?',1990,'Waterloo Club',14.95),
    ('Will Snoopy find Lucy?',1990,'Guelph Club',13.95),
    ('Les Gens Miserable',1996,'Basic',17.95),
    ('Les Gens Miserable',1996,'YRB Bronze',16.95),
    ('Les Gens Miserable',1996,'Readers Digest',14.95),
    ('Les Gens Miserable',1996,'CARP',17.95),
    ('Les Gens Miserable',1996,'YRB Silver',15.95),
    ('Les Gens Miserable',1996,'YRB Gold',14.95),
    ('Les Gens Miserable',1996,'Oprah',15.45),
    ('Les Gens Miserable',1996,'York Club',15.95),
    ('Les Gens Miserable',1996,'Waterloo Club',16.45),
    ('Tampopo Oishii',1997,'Basic',22.95),
    ('Tampopo Oishii',1997,'YRB Bronze',21.95),
    ('Tampopo Oishii',1997,'UofT Club',20.95),
    ('Tampopo Oishii',1997,'Readers Digest',20.95),
    ('Tampopo Oishii',1997,'CARP',20.95),
    ('Tampopo Oishii',1997,'YRB Silver',20.95),
    ('Tampopo Oishii',1997,'YRB Gold',19.95),
    ('Tampopo Oishii',1997,'Oprah',18.95),
    ('Tampopo Oishii',1997,'York Club',19.95),
    ('Tampopo Oishii',1997,'Waterloo Club',20.45),
    ('Tampopo Oishii',1997,'Guelph Club',20.45),
    ('Tande mou nai',2002,'Basic',112.95),
    ('Tande mou nai',2002,'YRB Bronze',108.95),
    ('Tande mou nai',2002,'UofT Club',106.95),
    ('Tande mou nai',2002,'Readers Digest',99.95),
    ('Tande mou nai',2002,'CARP',108.95),
    ('Tande mou nai',2002,'YRB Silver',104.95),
    ('Tande mou nai',2002,'YRB Gold',100.95),
    ('Tande mou nai',2002,'Oprah',104.95),
    ('Tande mou nai',2002,'York Club',104.95),
    ('Tande mou nai',2002,'Waterloo Club',106.95),
    ('Tande mou nai',2002,'Guelph Club',106.95),
    ('Flibber Gibber',2004,'Basic',3.25),
    ('Flibber Gibber',2004,'YRB Bronze',3.15),
    ('Flibber Gibber',2004,'UofT Club',3.05),
    ('Flibber Gibber',2004,'Readers Digest',2.95),
    ('Flibber Gibber',2004,'CARP',3.25),
    ('Flibber Gibber',2004,'YRB Silver',3.05),
    ('Flibber Gibber',2004,'YRB Gold',2.95),
    ('Flibber Gibber',2004,'Oprah',1.20),
    ('Flibber Gibber',2004,'York Club',3.05),
    ('Flibber Gibber',2004,'Waterloo Club',3.15),
    ('Flibber Gibber',2004,'Guelph Club',2.95),
    ('La Petite Chou',2001,'Basic',14.50),
    ('La Petite Chou',2001,'YRB Bronze',14.00),
    ('La Petite Chou',2001,'Readers Digest',11.50),
    ('La Petite Chou',2001,'CARP',12.50),
    ('La Petite Chou',2001,'YRB Silver',13.50),
    ('La Petite Chou',2001,'YRB Gold',13.00),
    ('La Petite Chou',2001,'Oprah',12.50),
    ('La Petite Chou',2001,'York Club',13.50),
    ('La Petite Chou',2001,'Waterloo Club',13.50),
    ('La Petite Chou',2001,'Guelph Club',13.50),
    ('Napolean''s Revenge',1952,'Basic',149.85),
    ('Napolean''s Revenge',1952,'YRB Bronze',146.85),
    ('Napolean''s Revenge',1952,'UofT Club',142.85),
    ('Napolean''s Revenge',1952,'Readers Digest',135.85),
    ('Napolean''s Revenge',1952,'CARP',139.85),
    ('Napolean''s Revenge',1952,'YRB Silver',143.85),
    ('Napolean''s Revenge',1952,'YRB Gold',140.85),
    ('Napolean''s Revenge',1952,'Oprah',139.85),
    ('Napolean''s Revenge',1952,'York Club',139.85),
    ('Napolean''s Revenge',1952,'Waterloo Club',139.85),
    ('Napolean''s Revenge',1952,'Guelph Club',149.85),
    ('Pluto Collides With Mars',2004,'Basic',44.19),
    ('Pluto Collides With Mars',2004,'YRB Bronze',43.69),
    ('Pluto Collides With Mars',2004,'York Club',41.19),
    ('Pluto Collides With Mars',2004,'UofT Club',42.00),
    ('Pluto Collides With Mars',2004,'CAA',40.19),
    ('Pluto Collides With Mars',2004,'Waterloo Club',41.49),
    ('Pluto Collides With Mars',2004,'YRB Silver',43.19),
    ('Pluto Collides With Mars',2004,'Guelph Club',40.99),
    ('Pluto Collides With Mars',2004,'YRB Gold',42.69),
    ('Quarks and Other Matter',2000,'Basic',79.95),
    ('Quarks and Other Matter',2000,'YRB Bronze',76.95),
    ('Quarks and Other Matter',2000,'UofT Club',74.95),
    ('Quarks and Other Matter',2000,'Readers Digest',73.95),
    ('Quarks and Other Matter',2000,'CARP',75.95),
    ('Quarks and Other Matter',2000,'YRB Silver',73.95),
    ('Quarks and Other Matter',2000,'YRB Gold',70.95),
    ('Quarks and Other Matter',2000,'Oprah',75.95),
    ('Quarks and Other Matter',2000,'York Club',74.95),
    ('Quarks and Other Matter',2000,'Waterloo Club',75.95),
    ('Quarks and Other Matter',2000,'Guelph Club',76.95),
    ('Oberon',1963,'Basic',25.95),
    ('Oberon',1963,'YRB Bronze',24.95),
    ('Oberon',1963,'UofT Club',23.95),
    ('Oberon',1963,'Readers Digest',22.95),
    ('Oberon',1963,'CARP',25.95),
    ('Oberon',1963,'YRB Silver',23.95),
    ('Oberon',1963,'YRB Gold',22.95),
    ('Oberon',1963,'Oprah',23.45),
    ('Oberon',1963,'York Club',23.95),
    ('Oberon',1963,'Waterloo Club',22.95),
    ('Oberon',1963,'Guelph Club',24.95),
    ('Yakuza Kekkon Shita',1996,'Basic',33.95),
    ('Yakuza Kekkon Shita',1996,'YRB Bronze',32.95),
    ('Yakuza Kekkon Shita',1996,'UofT Club',30.95),
    ('Yakuza Kekkon Shita',1996,'Readers Digest',30.95),
    ('Yakuza Kekkon Shita',1996,'CARP',30.95),
    ('Yakuza Kekkon Shita',1996,'YRB Silver',31.95),
    ('Yakuza Kekkon Shita',1996,'YRB Gold',30.95),
    ('Yakuza Kekkon Shita',1996,'Oprah',31.95),
    ('Yakuza Kekkon Shita',1996,'York Club',31.95),
    ('Yakuza Kekkon Shita',1996,'Waterloo Club',32.45),
    ('Yakuza Kekkon Shita',1996,'Guelph Club',32.45),
    ('Suzy does Waterloo',2001,'Basic',19.95),
    ('Suzy does Waterloo',2001,'YRB Bronze',18.95),
    ('Suzy does Waterloo',2001,'UofT Club',18.95),
    ('Suzy does Waterloo',2001,'CAA',15.95),
    ('Suzy does Waterloo',2001,'CARP',16.95),
    ('Suzy does Waterloo',2001,'YRB Silver',17.95),
    ('Suzy does Waterloo',2001,'YRB Gold',16.95),
    ('Suzy does Waterloo',2001,'York Club',17.95),
    ('Suzy does Waterloo',2001,'Waterloo Club',18.45),
    ('Suzy does Waterloo',2001,'Guelph Club',18.45),
    ('Bancroft''s Great!',2003,'Basic',24.95),
    ('Bancroft''s Great!',2003,'YRB Bronze',24.45),
    ('Bancroft''s Great!',2003,'UofT Club',23.45),
    ('Bancroft''s Great!',2003,'CAA',20.95),
    ('Bancroft''s Great!',2003,'CARP',22.95),
    ('Bancroft''s Great!',2003,'YRB Silver',23.95),
    ('Bancroft''s Great!',2003,'YRB Gold',23.45),
    ('Bancroft''s Great!',2003,'York Club',22.95),
    ('Bancroft''s Great!',2003,'Waterloo Club',22.95),
    ('Bancroft''s Great!',2003,'Guelph Club',23.95),
    ('Yon-juu Hachi',1948,'Basic',44.95),
    ('Yon-juu Hachi',1948,'YRB Bronze',43.95),
    ('Yon-juu Hachi',1948,'UofT Club',41.45),
    ('Yon-juu Hachi',1948,'Readers Digest',41.00),
    ('Yon-juu Hachi',1948,'CARP',41.95),
    ('Yon-juu Hachi',1948,'YRB Silver',42.95),
    ('Yon-juu Hachi',1948,'YRB Gold',41.95),
    ('Yon-juu Hachi',1948,'Oprah',41.95),
    ('Yon-juu Hachi',1948,'York Club',40.95),
    ('Yon-juu Hachi',1948,'Waterloo Club',41.95),
    ('Yon-juu Hachi',1948,'Guelph Club',41.45),
    ('Transmorgifacation',2004,'Basic',288.73),
    ('Transmorgifacation',2004,'YRB Bronze',285.73),
    ('Transmorgifacation',2004,'UofT Club',281.00),
    ('Transmorgifacation',2004,'CAA',278.73),
    ('Transmorgifacation',2004,'Readers Digest',285.00),
    ('Transmorgifacation',2004,'YRB Silver',282.73),
    ('Transmorgifacation',2004,'YRB Gold',279.73),
    ('Transmorgifacation',2004,'York Club',280.73),
    ('Transmorgifacation',2004,'Waterloo Club',282.73),
    ('Transmorgifacation',2004,'Guelph Club',282.00),
    ('Oui, Oui, Non!',1992,'Basic',39.95),
    ('Oui, Oui, Non!',1992,'YRB Bronze',38.95),
    ('Oui, Oui, Non!',1992,'UofT Club',37.95),
    ('Oui, Oui, Non!',1992,'Readers Digest',35.45),
    ('Oui, Oui, Non!',1992,'CARP',36.95),
    ('Oui, Oui, Non!',1992,'YRB Silver',37.95),
    ('Oui, Oui, Non!',1992,'YRB Gold',36.95),
    ('Oui, Oui, Non!',1992,'Oprah',37.95),
    ('Oui, Oui, Non!',1992,'York Club',35.95),
    ('Oui, Oui, Non!',1992,'Waterloo Club',36.95),
    ('Oui, Oui, Non!',1992,'Guelph Club',36.95),
    ('Rats Like Us',1999,'Basic',17.50),
    ('Rats Like Us',1999,'YRB Bronze',17.00),
    ('Rats Like Us',1999,'UofT Club',16.00),
    ('Rats Like Us',1999,'Readers Digest',15.50),
    ('Rats Like Us',1999,'CARP',15.50),
    ('Rats Like Us',1999,'YRB Silver',16.50),
    ('Rats Like Us',1999,'YRB Gold',16.00),
    ('Rats Like Us',1999,'Oprah',16.00),
    ('Rats Like Us',1999,'York Club',16.50),
    ('Rats Like Us',1999,'Waterloo Club',16.50),
    ('Rats Like Us',1999,'Guelph Club',16.50),
    ('Rats Like Us',1997,'Basic',85.95),
    ('Rats Like Us',1997,'YRB Bronze',83.95),
    ('Rats Like Us',1997,'UofT Club',80.95),
    ('Rats Like Us',1997,'Readers Digest',83.95),
    ('Rats Like Us',1997,'CARP',80.95),
    ('Rats Like Us',1997,'YRB Silver',81.95),
    ('Rats Like Us',1997,'YRB Gold',79.95),
    ('Rats Like Us',1997,'Oprah',82.95),
    ('Rats Like Us',1997,'York Club',79.95),
    ('Rats Like Us',1997,'Waterloo Club',79.95),
    ('Rats Like Us',1997,'Guelph Club',81.95),
    ('Alpha Centauri',2002,'Basic',44.62),
    ('Alpha Centauri',2002,'YRB Bronze',44.12),
    ('Alpha Centauri',2002,'York Club',40.62),
    ('Alpha Centauri',2002,'UofT Club',41.00),
    ('Alpha Centauri',2002,'CAA',39.00),
    ('Alpha Centauri',2002,'Waterloo Club',41.00),
    ('Alpha Centauri',2002,'YRB Silver',43.62),
    ('Alpha Centauri',2002,'Guelph Club',41.62),
    ('Alpha Centauri',2002,'YRB Gold',43.12),
    ('Where''s Canada?',1998,'Basic',23.95),
    ('Where''s Canada?',1998,'YRB Bronze',23.45),
    ('Where''s Canada?',1998,'UofT Club',22.95),
    ('Where''s Canada?',1998,'CAA',19.95),
    ('Where''s Canada?',1998,'Readers Digest',21.95),
    ('Where''s Canada?',1998,'CARP',20.95),
    ('Where''s Canada?',1998,'YRB Silver',22.95),
    ('Where''s Canada?',1998,'YRB Gold',22.45),
    ('Where''s Canada?',1998,'Oprah',22.95),
    ('Where''s Canada?',1998,'York Club',22.45),
    ('Where''s Canada?',1998,'Waterloo Club',22.95),
    ('Where''s Canada?',1998,'Guelph Club',22.95),
    ('Ou est Ce Canada?',1998,'Basic',23.95),
    ('Ou est Ce Canada?',1998,'YRB Bronze',23.45),
    ('Ou est Ce Canada?',1998,'CAA',19.95),
    ('Ou est Ce Canada?',1998,'Readers Digest',21.95),
    ('Ou est Ce Canada?',1998,'CARP',20.95),
    ('Ou est Ce Canada?',1998,'YRB Silver',22.95),
    ('Ou est Ce Canada?',1998,'YRB Gold',22.45),
    ('Ou est Ce Canada?',1998,'Oprah',22.95),
    ('Ou est Ce Canada?',1998,'York Club',22.45),
    ('Ou est Ce Canada?',1998,'Waterloo Club',22.95),
    ('Ou est Ce Canada?',1998,'Guelph Club',22.95),
    ('Learn How To Vote',2004,'Basic',14.95),
    ('Learn How To Vote',2004,'YRB Bronze',14.45),
    ('Learn How To Vote',2004,'UofT Club',12.95),
    ('Learn How To Vote',2004,'CAA',11.95),
    ('Learn How To Vote',2004,'Readers Digest',11.95),
    ('Learn How To Vote',2004,'CARP',12.95),
    ('Learn How To Vote',2004,'YRB Silver',13.95),
    ('Learn How To Vote',2004,'YRB Gold',13.45),
    ('Learn How To Vote',2004,'Oprah',12.45),
    ('Learn How To Vote',2004,'York Club',12.00),
    ('Learn How To Vote',2004,'Waterloo Club',12.45),
    ('Learn How To Vote',2004,'Guelph Club',12.45),
    ('Voting for Dummies',2004,'Basic',24.95),
    ('Voting for Dummies',2004,'YRB Bronze',23.95),
    ('Voting for Dummies',2004,'UofT Club',22.95),
    ('Voting for Dummies',2004,'CAA',20.95),
    ('Voting for Dummies',2004,'Readers Digest',21.95),
    ('Voting for Dummies',2004,'CARP',22.95),
    ('Voting for Dummies',2004,'YRB Silver',22.95),
    ('Voting for Dummies',2004,'YRB Gold',21.95),
    ('Voting for Dummies',2004,'Oprah',22.95),
    ('Voting for Dummies',2004,'York Club',22.45),
    ('Voting for Dummies',2004,'Waterloo Club',22.45),
    ('Voting for Dummies',2004,'Guelph Club',22.95),
    ('Capricia''s Conundrum',1993,'Basic',14.95),
    ('Capricia''s Conundrum',1993,'YRB Bronze',14.45),
    ('Capricia''s Conundrum',1993,'UofT Club',13.95),
    ('Capricia''s Conundrum',1993,'CAA',13.95),
    ('Capricia''s Conundrum',1993,'Readers Digest',12.45),
    ('Capricia''s Conundrum',1993,'CARP',13.45),
    ('Capricia''s Conundrum',1993,'YRB Silver',13.95),
    ('Capricia''s Conundrum',1993,'YRB Gold',13.45),
    ('Capricia''s Conundrum',1993,'Oprah',13.45),
    ('Capricia''s Conundrum',1993,'York Club',13.95),
    ('Capricia''s Conundrum',1993,'Waterloo Club',13.95),
    ('Capricia''s Conundrum',1993,'Guelph Club',12.95),
    ('Databases aren''t',2004,'Basic',45.95),
    ('Databases aren''t',2004,'YRB Bronze',44.95),
    ('Databases aren''t',2004,'UofT Club',43.95),
    ('Databases aren''t',2004,'CAA',43.95),
    ('Databases aren''t',2004,'Readers Digest',43.95),
    ('Databases aren''t',2004,'CARP',41.95),
    ('Databases aren''t',2004,'YRB Silver',43.95),
    ('Databases aren''t',2004,'YRB Gold',42.95),
    ('Databases aren''t',2004,'Oprah',42.95),
    ('Databases aren''t',2004,'York Club',42.95),
    ('Databases aren''t',2004,'Waterloo Club',43.95),
    ('Databases aren''t',2004,'Guelph Club',42.95),
    ('Databases made Real Hard',2002,'Basic',39.95),
    ('Databases made Real Hard',2002,'YRB Bronze',38.95),
    ('Databases made Real Hard',2002,'UofT Club',37.95),
    ('Databases made Real Hard',2002,'CAA',36.95),
    ('Databases made Real Hard',2002,'Readers Digest',35.95),
    ('Databases made Real Hard',2002,'CARP',37.95),
    ('Databases made Real Hard',2002,'YRB Silver',37.95),
    ('Databases made Real Hard',2002,'YRB Gold',36.95),
    ('Databases made Real Hard',2002,'Oprah',35.95),
    ('Databases made Real Hard',2002,'York Club',37.95),
    ('Databases made Real Hard',2002,'Waterloo Club',37.95),
    ('Databases made Real Hard',2002,'Guelph Club',36.95),
    ('Montreal est dans Quebec',1999,'Basic',24.95),
    ('Montreal est dans Quebec',1999,'YRB Bronze',23.95),
    ('Montreal est dans Quebec',1999,'UofT Club',22.95),
    ('Montreal est dans Quebec',1999,'CAA',20.95),
    ('Montreal est dans Quebec',1999,'Readers Digest',22.95),
    ('Montreal est dans Quebec',1999,'CARP',20.95),
    ('Montreal est dans Quebec',1999,'YRB Silver',22.95),
    ('Montreal est dans Quebec',1999,'YRB Gold',21.95),
    ('Montreal est dans Quebec',1999,'Oprah',21.95),
    ('Montreal est dans Quebec',1999,'York Club',22.95),
    ('Montreal est dans Quebec',1999,'Waterloo Club',21.95),
    ('Montreal est dans Quebec',1999,'Guelph Club',21.95),
    ('Tchuss',2002,'Basic',24.95),
    ('Tchuss',2002,'YRB Bronze',23.95),
    ('Tchuss',2002,'UofT Club',21.45),
    ('Tchuss',2002,'CAA',21.95),
    ('Tchuss',2002,'Readers Digest',22.95),
    ('Tchuss',2002,'CARP',21.95),
    ('Tchuss',2002,'YRB Silver',22.95),
    ('Tchuss',2002,'YRB Gold',21.95),
    ('Tchuss',2002,'Oprah',21.95),
    ('Tchuss',2002,'York Club',21.95),
    ('Tchuss',2002,'Waterloo Club',21.95),
    ('Tchuss',2002,'Guelph Club',21.95),
    ('Nippon no Joodan',2001,'Basic',36.50),
    ('Nippon no Joodan',2001,'YRB Bronze',35.50),
    ('Nippon no Joodan',2001,'UofT Club',33.00),
    ('Nippon no Joodan',2001,'CAA',32.50),
    ('Nippon no Joodan',2001,'Readers Digest',32.50),
    ('Nippon no Joodan',2001,'CARP',33.50),
    ('Nippon no Joodan',2001,'YRB Silver',34.50),
    ('Nippon no Joodan',2001,'YRB Gold',33.50),
    ('Nippon no Joodan',2001,'Oprah',33.50),
    ('Nippon no Joodan',2001,'York Club',33.50),
    ('Nippon no Joodan',2001,'Waterloo Club',33.00),
    ('Nippon no Joodan',2001,'Guelph Club',33.00),
    ('Recipes for Humans',2004,'Basic',72.43),
    ('Recipes for Humans',2004,'YRB Bronze',69.43),
    ('Recipes for Humans',2004,'UofT Club',68.43),
    ('Recipes for Humans',2004,'CAA',69.43),
    ('Recipes for Humans',2004,'Readers Digest',64.43),
    ('Recipes for Humans',2004,'CARP',69.43),
    ('Recipes for Humans',2004,'YRB Silver',66.43),
    ('Recipes for Humans',2004,'YRB Gold',63.43),
    ('Recipes for Humans',2004,'Oprah',60.43),
    ('Recipes for Humans',2004,'York Club',68.43),
    ('Recipes for Humans',2004,'Waterloo Club',68.43),
    ('Recipes for Humans',2004,'Guelph Club',65.43),
    ('Vegetables are Good!',2003,'Basic',23.95),
    ('Vegetables are Good!',2003,'YRB Bronze',22.95),
    ('Vegetables are Good!',2003,'UofT Club',21.95),
    ('Vegetables are Good!',2003,'CAA',19.95),
    ('Vegetables are Good!',2003,'Readers Digest',21.95),
    ('Vegetables are Good!',2003,'CARP',19.95),
    ('Vegetables are Good!',2003,'YRB Silver',21.95),
    ('Vegetables are Good!',2003,'YRB Gold',20.95),
    ('Vegetables are Good!',2003,'Oprah',19.95),
    ('Vegetables are Good!',2003,'York Club',21.95),
    ('Vegetables are Good!',2003,'Waterloo Club',20.95),
    ('Vegetables are Good!',2003,'Guelph Club',20.45),
    ('Vegetables are Good!',1992,'Basic',29.95),
    ('Vegetables are Good!',1992,'YRB Bronze',28.95),
    ('Vegetables are Good!',1992,'UofT Club',26.95),
    ('Vegetables are Good!',1992,'CAA',26.95),
    ('Vegetables are Good!',1992,'Readers Digest',27.95),
    ('Vegetables are Good!',1992,'CARP',26.95),
    ('Vegetables are Good!',1992,'YRB Silver',27.95),
    ('Vegetables are Good!',1992,'YRB Gold',26.95),
    ('Vegetables are Good!',1992,'Oprah',25.95),
    ('Vegetables are Good!',1992,'York Club',26.95),
    ('Vegetables are Good!',1992,'Waterloo Club',27.95),
    ('Vegetables are Good!',1992,'Guelph Club',27.95),
    ('Tampopo Oishii',1999,'Basic',24.50),
    ('Tampopo Oishii',1999,'YRB Bronze',23.50),
    ('Tampopo Oishii',1999,'UofT Club',21.50),
    ('Tampopo Oishii',1999,'CAA',21.50),
    ('Tampopo Oishii',1999,'Readers Digest',21.50),
    ('Tampopo Oishii',1999,'CARP',21.50),
    ('Tampopo Oishii',1999,'YRB Silver',22.50),
    ('Tampopo Oishii',1999,'YRB Gold',21.50),
    ('Tampopo Oishii',1999,'Oprah',21.50),
    ('Tampopo Oishii',1999,'York Club',22.50),
    ('Tampopo Oishii',1999,'Waterloo Club',21.50),
    ('Tampopo Oishii',1999,'Guelph Club',21.50),
    ('I''m Sorry, But No',2003,'Basic',9.95),
    ('I''m Sorry, But No',2003,'YRB Bronze',9.45),
    ('I''m Sorry, But No',2003,'UofT Club',8.45),
    ('I''m Sorry, But No',2003,'CAA',7.45),
    ('I''m Sorry, But No',2003,'Readers Digest',8.45),
    ('I''m Sorry, But No',2003,'CARP',7.45),
    ('I''m Sorry, But No',2003,'YRB Silver',8.95),
    ('I''m Sorry, But No',2003,'YRB Gold',8.45),
    ('I''m Sorry, But No',2003,'Oprah',8.95),
    ('I''m Sorry, But No',2003,'York Club',8.95),
    ('I''m Sorry, But No',2003,'Waterloo Club',8.45),
    ('I''m Sorry, But No',2003,'Guelph Club',7.95),
    ('Radiator Barbecuing',2002,'Basic',14.20),
    ('Radiator Barbecuing',2002,'YRB Bronze',13.70),
    ('Radiator Barbecuing',2002,'UofT Club',12.20),
    ('Radiator Barbecuing',2002,'CAA',11.70),
    ('Radiator Barbecuing',2002,'Readers Digest',12.70),
    ('Radiator Barbecuing',2002,'CARP',11.70),
    ('Radiator Barbecuing',2002,'YRB Silver',13.20),
    ('Radiator Barbecuing',2002,'YRB Gold',12.70),
    ('Radiator Barbecuing',2002,'Oprah',13.20),
    ('Radiator Barbecuing',2002,'York Club',12.70),
    ('Radiator Barbecuing',2002,'Waterloo Club',12.20),
    ('Radiator Barbecuing',2002,'Guelph Club',12.20),
    ('Please Beam Me Up',2004,'Basic',27.19),
    ('Please Beam Me Up',2004,'YRB Bronze',26.19),
    ('Please Beam Me Up',2004,'UofT Club',24.19),
    ('Please Beam Me Up',2004,'CAA',23.19),
    ('Please Beam Me Up',2004,'Readers Digest',24.19),
    ('Please Beam Me Up',2004,'CARP',24.19),
    ('Please Beam Me Up',2004,'YRB Silver',25.19),
    ('Please Beam Me Up',2004,'YRB Gold',24.19),
    ('Please Beam Me Up',2004,'Oprah',25.19),
    ('Please Beam Me Up',2004,'York Club',25.19),
    ('Please Beam Me Up',2004,'Waterloo Club',25.19),
    ('Please Beam Me Up',2004,'Guelph Club',23.69),
    ('Eigen Eigen',1980,'Basic',64.95),
    ('Eigen Eigen',1980,'YRB Bronze',61.95),
    ('Eigen Eigen',1980,'UofT Club',54.95),
    ('Eigen Eigen',1980,'CAA',61.95),
    ('Eigen Eigen',1980,'Readers Digest',61.95),
    ('Eigen Eigen',1980,'CARP',61.95),
    ('Eigen Eigen',1980,'YRB Silver',58.95),
    ('Eigen Eigen',1980,'YRB Gold',55.95),
    ('Eigen Eigen',1980,'Oprah',56.95),
    ('Eigen Eigen',1980,'York Club',57.95),
    ('Eigen Eigen',1980,'Waterloo Club',57.95),
    ('Eigen Eigen',1980,'Guelph Club',57.95),
    ('Play me a Song',1997,'Basic',21.95),
    ('Play me a Song',1997,'YRB Bronze',20.95),
    ('Play me a Song',1997,'UofT Club',18.95),
    ('Play me a Song',1997,'CAA',19.95),
    ('Play me a Song',1997,'Readers Digest',19.95),
    ('Play me a Song',1997,'CARP',17.95),
    ('Play me a Song',1997,'YRB Silver',19.95),
    ('Play me a Song',1997,'YRB Gold',18.95),
    ('Play me a Song',1997,'Oprah',19.95),
    ('Play me a Song',1997,'York Club',19.95),
    ('Play me a Song',1997,'Waterloo Club',18.45),
    ('Play me a Song',1997,'Guelph Club',19.95),
    ('Food for Dummies',2004,'Basic',24.95),
    ('Food for Dummies',2004,'YRB Bronze',23.95),
    ('Food for Dummies',2004,'UofT Club',21.45),
    ('Food for Dummies',2004,'CAA',20.95),
    ('Food for Dummies',2004,'Readers Digest',21.95),
    ('Food for Dummies',2004,'CARP',20.95),
    ('Food for Dummies',2004,'YRB Silver',22.95),
    ('Food for Dummies',2004,'YRB Gold',21.95),
    ('Food for Dummies',2004,'Oprah',21.95),
    ('Food for Dummies',2004,'York Club',21.95),
    ('Food for Dummies',2004,'Waterloo Club',22.95),
    ('Food for Dummies',2004,'Guelph Club',21.45),
    ('Ringo to Nashi',1997,'Basic',32.95),
    ('Ringo to Nashi',1997,'YRB Bronze',31.95),
    ('Ringo to Nashi',1997,'UofT Club',29.95),
    ('Ringo to Nashi',1997,'CAA',30.95),
    ('Ringo to Nashi',1997,'Readers Digest',30.95),
    ('Ringo to Nashi',1997,'CARP',29.95),
    ('Ringo to Nashi',1997,'YRB Silver',30.95),
    ('Ringo to Nashi',1997,'YRB Gold',29.95),
    ('Ringo to Nashi',1997,'Oprah',30.95),
    ('Ringo to Nashi',1997,'York Club',29.95),
    ('Ringo to Nashi',1997,'Waterloo Club',30.95),
    ('Ringo to Nashi',1997,'Guelph Club',29.95),
    ('Aubergines!',2000,'Basic',29.99),
    ('Aubergines!',2000,'YRB Bronze',28.99),
    ('Aubergines!',2000,'UofT Club',26.49),
    ('Aubergines!',2000,'CAA',26.99),
    ('Aubergines!',2000,'Readers Digest',25.99),
    ('Aubergines!',2000,'CARP',27.99),
    ('Aubergines!',2000,'YRB Silver',27.99),
    ('Aubergines!',2000,'YRB Gold',26.99),
    ('Aubergines!',2000,'Oprah',25.99),
    ('Aubergines!',2000,'York Club',26.99),
    ('Aubergines!',2000,'Waterloo Club',26.49),
    ('Aubergines!',2000,'Guelph Club',26.99),
    ('Nothing but Steak',1995,'Basic',30.00),
    ('Nothing but Steak',1995,'YRB Bronze',29.00),
    ('Nothing but Steak',1995,'UofT Club',28.00),
    ('Nothing but Steak',1995,'CAA',27.00),
    ('Nothing but Steak',1995,'Readers Digest',28.00),
    ('Nothing but Steak',1995,'CARP',27.00),
    ('Nothing but Steak',1995,'YRB Silver',28.00),
    ('Nothing but Steak',1995,'YRB Gold',27.00),
    ('Nothing but Steak',1995,'Oprah',28.00),
    ('Nothing but Steak',1995,'York Club',28.00),
    ('Nothing but Steak',1995,'Waterloo Club',28.00),
    ('Nothing but Steak',1995,'Guelph Club',26.50),
    ('SQL Kills!',2003,'Basic',42.95),
    ('SQL Kills!',2003,'YRB Bronze',41.95),
    ('SQL Kills!',2003,'UofT Club',40.95),
    ('SQL Kills!',2003,'CAA',38.95),
    ('SQL Kills!',2003,'Readers Digest',38.95),
    ('SQL Kills!',2003,'CARP',39.95),
    ('SQL Kills!',2003,'YRB Silver',40.95),
    ('SQL Kills!',2003,'YRB Gold',39.95),
    ('SQL Kills!',2003,'Oprah',39.95),
    ('SQL Kills!',2003,'York Club',39.95),
    ('SQL Kills!',2003,'Waterloo Club',40.95),
    ('SQL Kills!',2003,'Guelph Club',39.95),
    ('Curiouser and Curiouser',1953,'Basic',29.95),
    ('Curiouser and Curiouser',1953,'YRB Bronze',28.95),
    ('Curiouser and Curiouser',1953,'UofT Club',27.95),
    ('Curiouser and Curiouser',1953,'CAA',25.95),
    ('Curiouser and Curiouser',1953,'Readers Digest',27.95),
    ('Curiouser and Curiouser',1953,'CARP',26.95),
    ('Curiouser and Curiouser',1953,'YRB Silver',27.95),
    ('Curiouser and Curiouser',1953,'YRB Gold',26.95),
    ('Curiouser and Curiouser',1953,'Oprah',27.95),
    ('Curiouser and Curiouser',1953,'York Club',26.95),
    ('Curiouser and Curiouser',1953,'Waterloo Club',26.45),
    ('Curiouser and Curiouser',1953,'Guelph Club',27.95),
    ('Dogs are not Cats',1995,'Basic',35.95),
    ('Dogs are not Cats',1995,'YRB Bronze',34.95),
    ('Dogs are not Cats',1995,'UofT Club',32.95),
    ('Dogs are not Cats',1995,'CAA',33.95),
    ('Dogs are not Cats',1995,'Readers Digest',32.95),
    ('Dogs are not Cats',1995,'CARP',31.95),
    ('Dogs are not Cats',1995,'YRB Silver',33.95),
    ('Dogs are not Cats',1995,'YRB Gold',32.95),
    ('Dogs are not Cats',1995,'Oprah',32.95),
    ('Dogs are not Cats',1995,'York Club',33.95),
    ('Dogs are not Cats',1995,'Waterloo Club',32.95),
    ('Dogs are not Cats',1995,'Guelph Club',32.45),
    ('Je ne me souvien pas',1997,'Basic',14.95),
    ('Je ne me souvien pas',1997,'YRB Bronze',14.45),
    ('Je ne me souvien pas',1997,'UofT Club',12.95),
    ('Je ne me souvien pas',1997,'CAA',13.45),
    ('Je ne me souvien pas',1997,'Readers Digest',13.95),
    ('Je ne me souvien pas',1997,'CARP',12.45),
    ('Je ne me souvien pas',1997,'YRB Silver',13.95),
    ('Je ne me souvien pas',1997,'YRB Gold',13.45),
    ('Je ne me souvien pas',1997,'Oprah',12.45),
    ('Je ne me souvien pas',1997,'York Club',13.45),
    ('Je ne me souvien pas',1997,'Waterloo Club',13.45),
    ('Je ne me souvien pas',1997,'Guelph Club',12.95),
    ('Okay, Why Not?',2001,'Basic',19.95),
    ('Okay, Why Not?',2001,'YRB Bronze',19.45),
    ('Okay, Why Not?',2001,'UofT Club',18.95),
    ('Okay, Why Not?',2001,'CAA',17.45),
    ('Okay, Why Not?',2001,'Readers Digest',18.95),
    ('Okay, Why Not?',2001,'CARP',17.45),
    ('Okay, Why Not?',2001,'YRB Silver',18.95),
    ('Okay, Why Not?',2001,'YRB Gold',18.45),
    ('Okay, Why Not?',2001,'Oprah',17.45),
    ('Okay, Why Not?',2001,'York Club',18.45),
    ('Okay, Why Not?',2001,'Waterloo Club',18.95),
    ('Okay, Why Not?',2001,'Guelph Club',18.45),
    ('Math is fun!',1993,'Basic',59.95),
    ('Math is fun!',1993,'YRB Bronze',56.95),
    ('Math is fun!',1993,'UofT Club',49.95),
    ('Math is fun!',1993,'CAA',47.95),
    ('Math is fun!',1993,'Readers Digest',56.95),
    ('Math is fun!',1993,'CARP',47.95),
    ('Math is fun!',1993,'YRB Silver',53.95),
    ('Math is fun!',1993,'YRB Gold',50.95),
    ('Math is fun!',1993,'Oprah',56.95),
    ('Math is fun!',1993,'York Club',52.95),
    ('Math is fun!',1993,'Waterloo Club',52.95),
    ('Math is fun!',1993,'Guelph Club',55.95),
    ('Math is fun!',1995,'Basic',14.50),
    ('Math is fun!',1995,'YRB Bronze',14.00),
    ('Math is fun!',1995,'UofT Club',13.50),
    ('Math is fun!',1995,'CAA',12.00),
    ('Math is fun!',1995,'Readers Digest',12.00),
    ('Math is fun!',1995,'CARP',13.50),
    ('Math is fun!',1995,'YRB Silver',13.50),
    ('Math is fun!',1995,'YRB Gold',13.00),
    ('Math is fun!',1995,'Oprah',13.50),
    ('Math is fun!',1995,'York Club',13.50),
    ('Math is fun!',1995,'Waterloo Club',13.00),
    ('Math is fun!',1995,'Guelph Club',13.00),
    ('Is Math is fun?',1996,'Basic',72.95),
    ('Is Math is fun?',1996,'YRB Bronze',69.95),
    ('Is Math is fun?',1996,'UofT Club',68.95),
    ('Is Math is fun?',1996,'CAA',60.95),
    ('Is Math is fun?',1996,'Readers Digest',60.95),
    ('Is Math is fun?',1996,'CARP',60.95),
    ('Is Math is fun?',1996,'YRB Silver',66.95),
    ('Is Math is fun?',1996,'YRB Gold',63.95),
    ('Is Math is fun?',1996,'Oprah',69.95),
    ('Is Math is fun?',1996,'York Club',68.95),
    ('Is Math is fun?',1996,'Waterloo Club',68.95),
    ('Is Math is fun?',1996,'Guelph Club',68.95),
    ('The Stars are not Enough',2002,'Basic',23.95),
    ('The Stars are not Enough',2002,'YRB Bronze',22.95),
    ('The Stars are not Enough',2002,'UofT Club',20.95),
    ('The Stars are not Enough',2002,'CAA',20.95),
    ('The Stars are not Enough',2002,'Readers Digest',21.95),
    ('The Stars are not Enough',2002,'CARP',19.95),
    ('The Stars are not Enough',2002,'YRB Silver',21.95),
    ('The Stars are not Enough',2002,'YRB Gold',20.95),
    ('The Stars are not Enough',2002,'Oprah',21.95),
    ('The Stars are not Enough',2002,'York Club',20.95),
    ('The Stars are not Enough',2002,'Waterloo Club',20.45),
    ('The Stars are not Enough',2002,'Guelph Club',20.95),
    ('Bobbie Sue Ellen',1999,'Basic',25.00),
    ('Bobbie Sue Ellen',1999,'YRB Bronze',24.00),
    ('Bobbie Sue Ellen',1999,'UofT Club',22.00),
    ('Bobbie Sue Ellen',1999,'CAA',23.00),
    ('Bobbie Sue Ellen',1999,'Readers Digest',23.00),
    ('Bobbie Sue Ellen',1999,'CARP',22.00),
    ('Bobbie Sue Ellen',1999,'YRB Silver',23.00),
    ('Bobbie Sue Ellen',1999,'YRB Gold',22.00),
    ('Bobbie Sue Ellen',1999,'Oprah',21.00),
    ('Bobbie Sue Ellen',1999,'York Club',23.00),
    ('Bobbie Sue Ellen',1999,'Waterloo Club',21.50),
    ('Bobbie Sue Ellen',1999,'Guelph Club',22.00),
    ('Akachan Furu',2003,'Basic',24.95),
    ('Akachan Furu',2003,'YRB Bronze',23.95),
    ('Akachan Furu',2003,'UofT Club',21.45),
    ('Akachan Furu',2003,'CAA',22.95),
    ('Akachan Furu',2003,'Readers Digest',22.95),
    ('Akachan Furu',2003,'CARP',20.95),
    ('Akachan Furu',2003,'YRB Silver',22.95),
    ('Akachan Furu',2003,'YRB Gold',21.95),
    ('Akachan Furu',2003,'Oprah',21.95),
    ('Akachan Furu',2003,'York Club',21.95),
    ('Akachan Furu',2003,'Waterloo Club',21.95),
    ('Akachan Furu',2003,'Guelph Club',21.95),
    ('Darmstadt',2004,'Basic',29.95),
    ('Darmstadt',2004,'YRB Bronze',28.95),
    ('Darmstadt',2004,'UofT Club',26.95),
    ('Darmstadt',2004,'CAA',26.95),
    ('Darmstadt',2004,'Readers Digest',25.95),
    ('Darmstadt',2004,'CARP',25.95),
    ('Darmstadt',2004,'YRB Silver',27.95),
    ('Darmstadt',2004,'YRB Gold',26.95),
    ('Darmstadt',2004,'Oprah',25.95),
    ('Darmstadt',2004,'York Club',27.95),
    ('Darmstadt',2004,'Waterloo Club',26.45),
    ('Darmstadt',2004,'Guelph Club',27.95),
    ('Been There Done That',2002,'Basic',9.95),
    ('Been There Done That',2002,'YRB Bronze',9.45),
    ('Been There Done That',2002,'UofT Club',8.95),
    ('Been There Done That',2002,'CAA',8.95),
    ('Been There Done That',2002,'Readers Digest',8.45),
    ('Been There Done That',2002,'CARP',7.45),
    ('Been There Done That',2002,'YRB Silver',8.95),
    ('Been There Done That',2002,'YRB Gold',8.45),
    ('Been There Done That',2002,'Oprah',8.95),
    ('Been There Done That',2002,'York Club',8.45),
    ('Been There Done That',2002,'Waterloo Club',8.95),
    ('Been There Done That',2002,'Guelph Club',8.95),
    ('Acrimony Made Simple',1996,'Basic',23.50),
    ('Acrimony Made Simple',1996,'YRB Bronze',22.50),
    ('Acrimony Made Simple',1996,'UofT Club',20.50),
    ('Acrimony Made Simple',1996,'CAA',20.50),
    ('Acrimony Made Simple',1996,'Readers Digest',21.50),
    ('Acrimony Made Simple',1996,'CARP',19.50),
    ('Acrimony Made Simple',1996,'YRB Silver',21.50),
    ('Acrimony Made Simple',1996,'YRB Gold',20.50),
    ('Acrimony Made Simple',1996,'Oprah',19.50),
    ('Acrimony Made Simple',1996,'York Club',21.50),
    ('Acrimony Made Simple',1996,'Waterloo Club',20.00),
    ('Acrimony Made Simple',1996,'Guelph Club',20.50),
    ('Tomenatte Kudasai!',2000,'Basic',32.95),
    ('Tomenatte Kudasai!',2000,'YRB Bronze',31.95),
    ('Tomenatte Kudasai!',2000,'UofT Club',30.95),
    ('Tomenatte Kudasai!',2000,'CAA',28.95),
    ('Tomenatte Kudasai!',2000,'Readers Digest',29.95),
    ('Tomenatte Kudasai!',2000,'CARP',28.95),
    ('Tomenatte Kudasai!',2000,'YRB Silver',30.95),
    ('Tomenatte Kudasai!',2000,'YRB Gold',29.95),
    ('Tomenatte Kudasai!',2000,'Oprah',28.95),
    ('Tomenatte Kudasai!',2000,'York Club',30.95),
    ('Tomenatte Kudasai!',2000,'Waterloo Club',29.45),
    ('Tomenatte Kudasai!',2000,'Guelph Club',30.95),
    ('Parthenon',2004,'Basic',29.95),
    ('Parthenon',2004,'YRB Bronze',28.95),
    ('Parthenon',2004,'UofT Club',26.95),
    ('Parthenon',2004,'CAA',25.95),
    ('Parthenon',2004,'Readers Digest',25.95),
    ('Parthenon',2004,'CARP',25.95),
    ('Parthenon',2004,'YRB Silver',27.95),
    ('Parthenon',2004,'YRB Gold',26.95),
    ('Parthenon',2004,'Oprah',25.95),
    ('Parthenon',2004,'York Club',26.95),
    ('Parthenon',2004,'Waterloo Club',26.45),
    ('Parthenon',2004,'Guelph Club',26.45),
    ('Where are my Socks?',1998,'Basic',24.95),
    ('Where are my Socks?',1998,'YRB Bronze',23.95),
    ('Where are my Socks?',1998,'UofT Club',21.45),
    ('Where are my Socks?',1998,'CAA',21.95),
    ('Where are my Socks?',1998,'Readers Digest',22.95),
    ('Where are my Socks?',1998,'CARP',21.95),
    ('Where are my Socks?',1998,'YRB Silver',22.95),
    ('Where are my Socks?',1998,'YRB Gold',21.95),
    ('Where are my Socks?',1998,'Oprah',20.95),
    ('Where are my Socks?',1998,'York Club',21.95),
    ('Where are my Socks?',1998,'Waterloo Club',21.95),
    ('Where are my Socks?',1998,'Guelph Club',21.95),
    ('The Earth is not Enough',2003,'Basic',40.37),
    ('The Earth is not Enough',2003,'YRB Bronze',39.37),
    ('The Earth is not Enough',2003,'UofT Club',38.37),
    ('The Earth is not Enough',2003,'CAA',38.37),
    ('The Earth is not Enough',2003,'Readers Digest',38.37),
    ('The Earth is not Enough',2003,'CARP',36.37),
    ('The Earth is not Enough',2003,'YRB Silver',38.37),
    ('The Earth is not Enough',2003,'YRB Gold',37.37),
    ('The Earth is not Enough',2003,'Oprah',36.37),
    ('The Earth is not Enough',2003,'York Club',37.37),
    ('The Earth is not Enough',2003,'Waterloo Club',37.37),
    ('The Earth is not Enough',2003,'Guelph Club',38.37),
    ('Legacy Software made Fun',2004,'Basic',51.95),
    ('Legacy Software made Fun',2004,'YRB Bronze',48.95),
    ('Legacy Software made Fun',2004,'UofT Club',47.95),
    ('Legacy Software made Fun',2004,'CAA',43.95),
    ('Legacy Software made Fun',2004,'Readers Digest',39.95),
    ('Legacy Software made Fun',2004,'CARP',43.95),
    ('Legacy Software made Fun',2004,'YRB Silver',45.95),
    ('Legacy Software made Fun',2004,'YRB Gold',42.95),
    ('Legacy Software made Fun',2004,'Oprah',39.95),
    ('Legacy Software made Fun',2004,'York Club',47.95),
    ('Legacy Software made Fun',2004,'Waterloo Club',44.95),
    ('Legacy Software made Fun',2004,'Guelph Club',47.95),
    ('Brats like Us',1999,'Basic',34.95),
    ('Brats like Us',1999,'YRB Bronze',33.95),
    ('Brats like Us',1999,'UofT Club',31.95),
    ('Brats like Us',1999,'CAA',32.95),
    ('Brats like Us',1999,'Readers Digest',31.95),
    ('Brats like Us',1999,'CARP',30.95),
    ('Brats like Us',1999,'YRB Silver',32.95),
    ('Brats like Us',1999,'YRB Gold',31.95),
    ('Brats like Us',1999,'Oprah',32.95),
    ('Brats like Us',1999,'York Club',31.95),
    ('Brats like Us',1999,'Waterloo Club',31.45),
    ('Brats like Us',1999,'Guelph Club',32.95),
    ('Where are my Socks?',1994,'Basic',28.19),
    ('Where are my Socks?',1994,'YRB Bronze',27.19),
    ('Where are my Socks?',1994,'UofT Club',24.69),
    ('Where are my Socks?',1994,'CAA',26.19),
    ('Where are my Socks?',1994,'Readers Digest',26.19),
    ('Where are my Socks?',1994,'CARP',26.19),
    ('Where are my Socks?',1994,'YRB Silver',26.19),
    ('Where are my Socks?',1994,'YRB Gold',25.19),
    ('Where are my Socks?',1994,'Oprah',26.19),
    ('Where are my Socks?',1994,'York Club',26.19),
    ('Where are my Socks?',1994,'Waterloo Club',24.69),
    ('Where are my Socks?',1994,'Guelph Club',26.19),
    ('Yum, Yum, English Cooking',1997,'Basic',5.00),
    ('Yum, Yum, English Cooking',1997,'YRB Bronze',4.50),
    ('Yum, Yum, English Cooking',1997,'UofT Club',3.50),
    ('Yum, Yum, English Cooking',1997,'CAA',3.50),
    ('Yum, Yum, English Cooking',1997,'Readers Digest',4.00),
    ('Yum, Yum, English Cooking',1997,'CARP',3.50),
    ('Yum, Yum, English Cooking',1997,'YRB Silver',4.00),
    ('Yum, Yum, English Cooking',1997,'YRB Gold',3.50),
    ('Yum, Yum, English Cooking',1997,'Oprah',2.50),
    ('Yum, Yum, English Cooking',1997,'York Club',4.00),
    ('Yum, Yum, English Cooking',1997,'Waterloo Club',3.00),
    ('Yum, Yum, English Cooking',1997,'Guelph Club',3.50),
    ('Cuisine Anglaise!?',1997,'Basic',5.00),
    ('Cuisine Anglaise!?',1997,'YRB Bronze',4.50),
    ('Cuisine Anglaise!?',1997,'UofT Club',3.00),
    ('Cuisine Anglaise!?',1997,'CAA',3.50),
    ('Cuisine Anglaise!?',1997,'Readers Digest',2.50),
    ('Cuisine Anglaise!?',1997,'CARP',2.50),
    ('Cuisine Anglaise!?',1997,'YRB Silver',4.00),
    ('Cuisine Anglaise!?',1997,'YRB Gold',3.50),
    ('Cuisine Anglaise!?',1997,'Oprah',3.50),
    ('Cuisine Anglaise!?',1997,'York Club',4.00),
    ('Cuisine Anglaise!?',1997,'Waterloo Club',3.50),
    ('Cuisine Anglaise!?',1997,'Guelph Club',4.00),
    ('Where art thou Bertha?',2003,'Basic',30.95),
    ('Where art thou Bertha?',2003,'YRB Bronze',29.95),
    ('Where art thou Bertha?',2003,'UofT Club',28.95),
    ('Where art thou Bertha?',2003,'CAA',26.95),
    ('Where art thou Bertha?',2003,'Readers Digest',26.95),
    ('Where art thou Bertha?',2003,'CARP',26.95),
    ('Where art thou Bertha?',2003,'YRB Silver',28.95),
    ('Where art thou Bertha?',2003,'YRB Gold',27.95),
    ('Where art thou Bertha?',2003,'Oprah',28.95),
    ('Where art thou Bertha?',2003,'York Club',28.95),
    ('Where art thou Bertha?',2003,'Waterloo Club',27.95),
    ('Where art thou Bertha?',2003,'Guelph Club',27.45),
    ('Rigor Mortis',1023,'Basic',26.95),
    ('Rigor Mortis',1023,'YRB Bronze',25.95),
    ('Rigor Mortis',1023,'UofT Club',23.95),
    ('Rigor Mortis',1023,'CAA',22.95),
    ('Rigor Mortis',1023,'Readers Digest',22.95),
    ('Rigor Mortis',1023,'CARP',24.95),
    ('Rigor Mortis',1023,'YRB Silver',24.95),
    ('Rigor Mortis',1023,'YRB Gold',23.95),
    ('Rigor Mortis',1023,'Oprah',22.95),
    ('Rigor Mortis',1023,'York Club',24.95),
    ('Rigor Mortis',1023,'Waterloo Club',24.95),
    ('Rigor Mortis',1023,'Guelph Club',23.45),
    ('Meine Kleine Katze',2002,'Basic',17.50),
    ('Meine Kleine Katze',2002,'YRB Bronze',17.00),
    ('Meine Kleine Katze',2002,'UofT Club',16.00),
    ('Meine Kleine Katze',2002,'CAA',16.50),
    ('Meine Kleine Katze',2002,'Readers Digest',15.00),
    ('Meine Kleine Katze',2002,'CARP',16.50),
    ('Meine Kleine Katze',2002,'YRB Silver',16.50),
    ('Meine Kleine Katze',2002,'YRB Gold',16.00),
    ('Meine Kleine Katze',2002,'Oprah',15.00),
    ('Meine Kleine Katze',2002,'York Club',16.50),
    ('Meine Kleine Katze',2002,'Waterloo Club',16.50),
    ('Meine Kleine Katze',2002,'Guelph Club',15.50),
    ('Pigs are nice',1996,'Basic',12.95),
    ('Pigs are nice',1996,'YRB Bronze',12.45),
    ('Pigs are nice',1996,'UofT Club',11.95),
    ('Pigs are nice',1996,'CAA',11.45),
    ('Pigs are nice',1996,'Readers Digest',11.45),
    ('Pigs are nice',1996,'CARP',11.95),
    ('Pigs are nice',1996,'YRB Silver',11.95),
    ('Pigs are nice',1996,'YRB Gold',11.45),
    ('Pigs are nice',1996,'Oprah',10.45),
    ('Pigs are nice',1996,'York Club',11.45),
    ('Pigs are nice',1996,'Waterloo Club',10.95),
    ('Pigs are nice',1996,'Guelph Club',10.95),
    ('Getting into Snork U.',2004,'Basic',23.95),
    ('Getting into Snork U.',2004,'YRB Bronze',22.95),
    ('Getting into Snork U.',2004,'UofT Club',20.45),
    ('Getting into Snork U.',2004,'CAA',20.95),
    ('Getting into Snork U.',2004,'Readers Digest',19.95),
    ('Getting into Snork U.',2004,'CARP',21.95),
    ('Getting into Snork U.',2004,'YRB Silver',21.95),
    ('Getting into Snork U.',2004,'YRB Gold',20.95),
    ('Getting into Snork U.',2004,'Oprah',21.95),
    ('Getting into Snork U.',2004,'York Club',21.95),
    ('Getting into Snork U.',2004,'Waterloo Club',20.45),
    ('Getting into Snork U.',2004,'Guelph Club',20.95),
    ('Are my feet too big?',1993,'Basic',13.95),
    ('Are my feet too big?',1993,'YRB Bronze',13.45),
    ('Are my feet too big?',1993,'UofT Club',12.45),
    ('Are my feet too big?',1993,'CAA',11.45),
    ('Are my feet too big?',1993,'Readers Digest',11.45),
    ('Are my feet too big?',1993,'CARP',12.95),
    ('Are my feet too big?',1993,'YRB Silver',12.95),
    ('Are my feet too big?',1993,'YRB Gold',12.45),
    ('Are my feet too big?',1993,'Oprah',11.45),
    ('Are my feet too big?',1993,'York Club',12.45),
    ('Are my feet too big?',1993,'Waterloo Club',11.95),
    ('Are my feet too big?',1993,'Guelph Club',12.45),
    ('Live in London?!',2002,'Basic',6.95),
    ('Live in London?!',2002,'YRB Bronze',6.45),
    ('Live in London?!',2002,'UofT Club',5.95),
    ('Live in London?!',2002,'CAA',5.95),
    ('Live in London?!',2002,'Readers Digest',5.45),
    ('Live in London?!',2002,'CARP',4.45),
    ('Live in London?!',2002,'YRB Silver',5.95),
    ('Live in London?!',2002,'YRB Gold',5.45),
    ('Live in London?!',2002,'Oprah',4.45),
    ('Live in London?!',2002,'York Club',5.95),
    ('Live in London?!',2002,'Waterloo Club',4.95),
    ('Live in London?!',2002,'Guelph Club',5.45),
    ('Not That London!',2003,'Basic',12.50),
    ('Not That London!',2003,'YRB Bronze',12.00),
    ('Not That London!',2003,'UofT Club',10.50),
    ('Not That London!',2003,'CAA',10.00),
    ('Not That London!',2003,'Readers Digest',10.00),
    ('Not That London!',2003,'CARP',11.50),
    ('Not That London!',2003,'YRB Silver',11.50),
    ('Not That London!',2003,'YRB Gold',11.00),
    ('Not That London!',2003,'Oprah',11.50),
    ('Not That London!',2003,'York Club',11.50),
    ('Not That London!',2003,'Waterloo Club',11.00),
    ('Not That London!',2003,'Guelph Club',10.50),
    ('Rabbits are nice',1996,'Basic',12.95),
    ('Rabbits are nice',1996,'YRB Bronze',12.45),
    ('Rabbits are nice',1996,'UofT Club',11.45),
    ('Rabbits are nice',1996,'CAA',11.95),
    ('Rabbits are nice',1996,'Readers Digest',11.95),
    ('Rabbits are nice',1996,'CARP',10.45),
    ('Rabbits are nice',1996,'YRB Silver',11.95),
    ('Rabbits are nice',1996,'YRB Gold',11.45),
    ('Rabbits are nice',1996,'Oprah',10.45),
    ('Rabbits are nice',1996,'York Club',11.95),
    ('Rabbits are nice',1996,'Waterloo Club',11.45),
    ('Rabbits are nice',1996,'Guelph Club',11.45),
    ('Rabbits are nice',2004,'Basic',21.95),
    ('Rabbits are nice',2004,'YRB Bronze',20.95),
    ('Rabbits are nice',2004,'UofT Club',18.45),
    ('Rabbits are nice',2004,'CAA',18.95),
    ('Rabbits are nice',2004,'Readers Digest',18.95),
    ('Rabbits are nice',2004,'CARP',19.95),
    ('Rabbits are nice',2004,'YRB Silver',19.95),
    ('Rabbits are nice',2004,'YRB Gold',18.95),
    ('Rabbits are nice',2004,'Oprah',18.95),
    ('Rabbits are nice',2004,'York Club',19.95),
    ('Rabbits are nice',2004,'Waterloo Club',19.95),
    ('Rabbits are nice',2004,'Guelph Club',19.95),
    ('Under Your Bed',2004,'Basic',16.35),
    ('Under Your Bed',2004,'YRB Bronze',15.85),
    ('Under Your Bed',2004,'UofT Club',15.35),
    ('Under Your Bed',2004,'CAA',13.85),
    ('Under Your Bed',2004,'Readers Digest',14.85),
    ('Under Your Bed',2004,'CARP',14.85),
    ('Under Your Bed',2004,'YRB Silver',15.35),
    ('Under Your Bed',2004,'YRB Gold',14.85),
    ('Under Your Bed',2004,'Oprah',14.85),
    ('Under Your Bed',2004,'York Club',15.35),
    ('Under Your Bed',2004,'Waterloo Club',14.35),
    ('Under Your Bed',2004,'Guelph Club',15.35),
    ('Strike Once, Strike Twice',2004,'Basic',19.95),
    ('Strike Once, Strike Twice',2004,'YRB Bronze',19.45),
    ('Strike Once, Strike Twice',2004,'UofT Club',17.95),
    ('Strike Once, Strike Twice',2004,'CAA',18.95),
    ('Strike Once, Strike Twice',2004,'Readers Digest',18.45),
    ('Strike Once, Strike Twice',2004,'CARP',17.45),
    ('Strike Once, Strike Twice',2004,'YRB Silver',18.95),
    ('Strike Once, Strike Twice',2004,'YRB Gold',18.45),
    ('Strike Once, Strike Twice',2004,'Oprah',18.45),
    ('Strike Once, Strike Twice',2004,'York Club',18.45),
    ('Strike Once, Strike Twice',2004,'Waterloo Club',18.45),
    ('Strike Once, Strike Twice',2004,'Guelph Club',18.45),
    ('Cats are not Dogs',1996,'Basic',35.95),
    ('Cats are not Dogs',1996,'YRB Bronze',34.95),
    ('Cats are not Dogs',1996,'UofT Club',33.95),
    ('Cats are not Dogs',1996,'CAA',31.95),
    ('Cats are not Dogs',1996,'Readers Digest',31.95),
    ('Cats are not Dogs',1996,'CARP',31.95),
    ('Cats are not Dogs',1996,'YRB Silver',33.95),
    ('Cats are not Dogs',1996,'YRB Gold',32.95),
    ('Cats are not Dogs',1996,'Oprah',33.95),
    ('Cats are not Dogs',1996,'York Club',33.95),
    ('Cats are not Dogs',1996,'Waterloo Club',32.95),
    ('Cats are not Dogs',1996,'Guelph Club',33.95),
    ('Chats ne sont pas Chiens',1996,'Basic',35.95),
    ('Chats ne sont pas Chiens',1996,'YRB Bronze',34.95),
    ('Chats ne sont pas Chiens',1996,'UofT Club',32.95),
    ('Chats ne sont pas Chiens',1996,'CAA',33.95),
    ('Chats ne sont pas Chiens',1996,'Readers Digest',31.95),
    ('Chats ne sont pas Chiens',1996,'CARP',32.95),
    ('Chats ne sont pas Chiens',1996,'YRB Silver',33.95),
    ('Chats ne sont pas Chiens',1996,'YRB Gold',32.95),
    ('Chats ne sont pas Chiens',1996,'Oprah',31.95),
    ('Chats ne sont pas Chiens',1996,'York Club',32.95),
    ('Chats ne sont pas Chiens',1996,'Waterloo Club',32.95),
    ('Chats ne sont pas Chiens',1996,'Guelph Club',32.45),
    ('The Fickle Pickle',2004,'Basic',27.95),
    ('The Fickle Pickle',2004,'YRB Bronze',26.95),
    ('The Fickle Pickle',2004,'UofT Club',24.45),
    ('The Fickle Pickle',2004,'CAA',24.95),
    ('The Fickle Pickle',2004,'Readers Digest',23.95),
    ('The Fickle Pickle',2004,'CARP',23.95),
    ('The Fickle Pickle',2004,'YRB Silver',25.95),
    ('The Fickle Pickle',2004,'YRB Gold',24.95),
    ('The Fickle Pickle',2004,'Oprah',23.95),
    ('The Fickle Pickle',2004,'York Club',25.95),
    ('The Fickle Pickle',2004,'Waterloo Club',24.95),
    ('The Fickle Pickle',2004,'Guelph Club',24.95),
    ('I don''t think so',2001,'Basic',14.00),
    ('I don''t think so',2001,'YRB Bronze',13.50),
    ('I don''t think so',2001,'UofT Club',12.50),
    ('I don''t think so',2001,'CAA',11.50),
    ('I don''t think so',2001,'Readers Digest',13.00),
    ('I don''t think so',2001,'CARP',12.50),
    ('I don''t think so',2001,'YRB Silver',13.00),
    ('I don''t think so',2001,'YRB Gold',12.50),
    ('I don''t think so',2001,'Oprah',13.00),
    ('I don''t think so',2001,'York Club',12.50),
    ('I don''t think so',2001,'Waterloo Club',13.00),
    ('I don''t think so',2001,'Guelph Club',12.50),
    ('Quantum Databases',2003,'Basic',74.95),
    ('Quantum Databases',2003,'YRB Bronze',71.95),
    ('Quantum Databases',2003,'UofT Club',67.95),
    ('Quantum Databases',2003,'CAA',62.95),
    ('Quantum Databases',2003,'Readers Digest',71.95),
    ('Quantum Databases',2003,'CARP',66.95),
    ('Quantum Databases',2003,'YRB Silver',68.95),
    ('Quantum Databases',2003,'YRB Gold',65.95),
    ('Quantum Databases',2003,'Oprah',71.95),
    ('Quantum Databases',2003,'York Club',70.95),
    ('Quantum Databases',2003,'Waterloo Club',64.95),
    ('Quantum Databases',2003,'Guelph Club',67.95),
    ('Are my feet too big?',1997,'Basic',12.95),
    ('Are my feet too big?',1997,'YRB Bronze',12.45),
    ('Are my feet too big?',1997,'UofT Club',11.95),
    ('Are my feet too big?',1997,'CAA',11.95),
    ('Are my feet too big?',1997,'Readers Digest',10.45),
    ('Are my feet too big?',1997,'CARP',11.95),
    ('Are my feet too big?',1997,'YRB Silver',11.95),
    ('Are my feet too big?',1997,'YRB Gold',11.45),
    ('Are my feet too big?',1997,'Oprah',10.45),
    ('Are my feet too big?',1997,'York Club',11.45),
    ('Are my feet too big?',1997,'Waterloo Club',11.95),
    ('Are my feet too big?',1997,'Guelph Club',11.95),
    ('Tsukimono to Tsukemono',2004,'Basic',8.95),
    ('Tsukimono to Tsukemono',2004,'YRB Bronze',8.45),
    ('Tsukimono to Tsukemono',2004,'UofT Club',7.95),
    ('Tsukimono to Tsukemono',2004,'CAA',6.45),
    ('Tsukimono to Tsukemono',2004,'Readers Digest',6.45),
    ('Tsukimono to Tsukemono',2004,'CARP',7.45),
    ('Tsukimono to Tsukemono',2004,'YRB Silver',7.95),
    ('Tsukimono to Tsukemono',2004,'YRB Gold',7.45),
    ('Tsukimono to Tsukemono',2004,'Oprah',7.95),
    ('Tsukimono to Tsukemono',2004,'York Club',7.45),
    ('Tsukimono to Tsukemono',2004,'Waterloo Club',7.95),
    ('Tsukimono to Tsukemono',2004,'Guelph Club',7.45),
    ('Tropical Windsor',2004,'Basic',18.95),
    ('Tropical Windsor',2004,'YRB Bronze',18.45),
    ('Tropical Windsor',2004,'UofT Club',17.95),
    ('Tropical Windsor',2004,'CAA',17.45),
    ('Tropical Windsor',2004,'Readers Digest',17.45),
    ('Tropical Windsor',2004,'CARP',17.45),
    ('Tropical Windsor',2004,'YRB Silver',17.95),
    ('Tropical Windsor',2004,'YRB Gold',17.45),
    ('Tropical Windsor',2004,'Oprah',17.95),
    ('Tropical Windsor',2004,'York Club',17.95),
    ('Tropical Windsor',2004,'Waterloo Club',17.95),
    ('Tropical Windsor',2004,'Guelph Club',17.95),
    ('Montreal pour les Idiots',2002,'Basic',34.95),
    ('Montreal pour les Idiots',2002,'YRB Bronze',33.95),
    ('Montreal pour les Idiots',2002,'UofT Club',31.45),
    ('Montreal pour les Idiots',2002,'CAA',32.95),
    ('Montreal pour les Idiots',2002,'Readers Digest',31.95),
    ('Montreal pour les Idiots',2002,'CARP',30.95),
    ('Montreal pour les Idiots',2002,'YRB Silver',32.95),
    ('Montreal pour les Idiots',2002,'YRB Gold',31.95),
    ('Montreal pour les Idiots',2002,'Oprah',31.95),
    ('Montreal pour les Idiots',2002,'York Club',32.95),
    ('Montreal pour les Idiots',2002,'Waterloo Club',31.45),
    ('Montreal pour les Idiots',2002,'Guelph Club',31.95),
    ('Base de Donne',2003,'Basic',24.95),
    ('Base de Donne',2003,'YRB Bronze',23.95),
    ('Base de Donne',2003,'UofT Club',21.95),
    ('Base de Donne',2003,'CAA',21.95),
    ('Base de Donne',2003,'Readers Digest',20.95),
    ('Base de Donne',2003,'CARP',21.95),
    ('Base de Donne',2003,'YRB Silver',22.95),
    ('Base de Donne',2003,'YRB Gold',21.95),
    ('Base de Donne',2003,'Oprah',20.95),
    ('Base de Donne',2003,'York Club',22.95),
    ('Base de Donne',2003,'Waterloo Club',21.95),
    ('Base de Donne',2003,'Guelph Club',21.95),
    ('The Wiley Snark',1980,'Basic',17.10),
    ('The Wiley Snark',1980,'YRB Bronze',16.60),
    ('The Wiley Snark',1980,'UofT Club',16.10),
    ('The Wiley Snark',1980,'CAA',15.60),
    ('The Wiley Snark',1980,'Readers Digest',15.60),
    ('The Wiley Snark',1980,'CARP',16.10),
    ('The Wiley Snark',1980,'YRB Silver',16.10),
    ('The Wiley Snark',1980,'YRB Gold',15.60),
    ('The Wiley Snark',1980,'Oprah',14.60),
    ('The Wiley Snark',1980,'York Club',16.10),
    ('The Wiley Snark',1980,'Waterloo Club',15.60),
    ('The Wiley Snark',1980,'Guelph Club',15.60),
    ('Press the Red Button!',2003,'Basic',53.71),
    ('Press the Red Button!',2003,'YRB Bronze',50.71),
    ('Press the Red Button!',2003,'UofT Club',49.71),
    ('Press the Red Button!',2003,'CAA',45.71),
    ('Press the Red Button!',2003,'Readers Digest',45.71),
    ('Press the Red Button!',2003,'CARP',45.71),
    ('Press the Red Button!',2003,'YRB Silver',47.71),
    ('Press the Red Button!',2003,'YRB Gold',44.71),
    ('Press the Red Button!',2003,'Oprah',50.71),
    ('Press the Red Button!',2003,'York Club',46.71),
    ('Press the Red Button!',2003,'Waterloo Club',43.71),
    ('Press the Red Button!',2003,'Guelph Club',49.71),
    ('Relational Algebra',2004,'Basic',12.95),
    ('Relational Algebra',2004,'YRB Bronze',12.45),
    ('Relational Algebra',2004,'UofT Club',10.95),
    ('Relational Algebra',2004,'CAA',11.95),
    ('Relational Algebra',2004,'Readers Digest',10.45),
    ('Relational Algebra',2004,'CARP',11.45),
    ('Relational Algebra',2004,'YRB Silver',11.95),
    ('Relational Algebra',2004,'YRB Gold',11.45),
    ('Relational Algebra',2004,'Oprah',11.45),
    ('Relational Algebra',2004,'York Club',11.95),
    ('Relational Algebra',2004,'Waterloo Club',11.95),
    ('Relational Algebra',2004,'Guelph Club',11.95),
    ('Ottawa Hot Spots',2002,'Basic',15.95),
    ('Ottawa Hot Spots',2002,'YRB Bronze',15.45),
    ('Ottawa Hot Spots',2002,'UofT Club',14.95),
    ('Ottawa Hot Spots',2002,'CAA',13.45),
    ('Ottawa Hot Spots',2002,'Readers Digest',13.45),
    ('Ottawa Hot Spots',2002,'CARP',14.95),
    ('Ottawa Hot Spots',2002,'YRB Silver',14.95),
    ('Ottawa Hot Spots',2002,'YRB Gold',14.45),
    ('Ottawa Hot Spots',2002,'Oprah',13.45),
    ('Ottawa Hot Spots',2002,'York Club',14.95),
    ('Ottawa Hot Spots',2002,'Waterloo Club',14.95),
    ('Ottawa Hot Spots',2002,'Guelph Club',13.95),
    ('Gigabytes still to go',2001,'Basic',23.50),
    ('Gigabytes still to go',2001,'YRB Bronze',22.50),
    ('Gigabytes still to go',2001,'UofT Club',20.50),
    ('Gigabytes still to go',2001,'CAA',19.50),
    ('Gigabytes still to go',2001,'Readers Digest',21.50),
    ('Gigabytes still to go',2001,'CARP',21.50),
    ('Gigabytes still to go',2001,'YRB Silver',21.50),
    ('Gigabytes still to go',2001,'YRB Gold',20.50),
    ('Gigabytes still to go',2001,'Oprah',19.50),
    ('Gigabytes still to go',2001,'York Club',21.50),
    ('Gigabytes still to go',2001,'Waterloo Club',20.50),
    ('Gigabytes still to go',2001,'Guelph Club',20.50),
    ('DB2, DB3, and Beyond!',2004,'Basic',41.95),
    ('DB2, DB3, and Beyond!',2004,'YRB Bronze',40.95),
    ('DB2, DB3, and Beyond!',2004,'UofT Club',39.95),
    ('DB2, DB3, and Beyond!',2004,'CAA',38.95),
    ('DB2, DB3, and Beyond!',2004,'Readers Digest',37.95),
    ('DB2, DB3, and Beyond!',2004,'CARP',37.95),
    ('DB2, DB3, and Beyond!',2004,'YRB Silver',39.95),
    ('DB2, DB3, and Beyond!',2004,'YRB Gold',38.95),
    ('DB2, DB3, and Beyond!',2004,'Oprah',39.95),
    ('DB2, DB3, and Beyond!',2004,'York Club',38.95),
    ('DB2, DB3, and Beyond!',2004,'Waterloo Club',38.95),
    ('DB2, DB3, and Beyond!',2004,'Guelph Club',38.45),
    ('DB2 Made Simple',2003,'Basic',108.95),
    ('DB2 Made Simple',2003,'YRB Bronze',105.95),
    ('DB2 Made Simple',2003,'UofT Club',101.95),
    ('DB2 Made Simple',2003,'CAA',96.95),
    ('DB2 Made Simple',2003,'Readers Digest',100.95),
    ('DB2 Made Simple',2003,'CARP',100.95),
    ('DB2 Made Simple',2003,'YRB Silver',102.95),
    ('DB2 Made Simple',2003,'YRB Gold',99.95),
    ('DB2 Made Simple',2003,'Oprah',105.95),
    ('DB2 Made Simple',2003,'York Club',104.95),
    ('DB2 Made Simple',2003,'Waterloo Club',98.95),
    ('DB2 Made Simple',2003,'Guelph Club',98.95),
    ('Avarice is Good',1998,'Basic',218.95),
    ('Avarice is Good',1998,'YRB Bronze',215.95),
    ('Avarice is Good',1998,'UofT Club',214.95),
    ('Avarice is Good',1998,'CAA',210.95),
    ('Avarice is Good',1998,'Readers Digest',210.95),
    ('Avarice is Good',1998,'CARP',215.95),
    ('Avarice is Good',1998,'YRB Silver',212.95),
    ('Avarice is Good',1998,'YRB Gold',209.95),
    ('Avarice is Good',1998,'Oprah',210.95),
    ('Avarice is Good',1998,'York Club',211.95),
    ('Avarice is Good',1998,'Waterloo Club',208.95),
    ('Avarice is Good',1998,'Guelph Club',214.95),
    ('Humor in SQL',2004,'Basic',29.95),
    ('Humor in SQL',2004,'YRB Bronze',28.95),
    ('Humor in SQL',2004,'UofT Club',26.45),
    ('Humor in SQL',2004,'CAA',27.95),
    ('Humor in SQL',2004,'Readers Digest',25.95),
    ('Humor in SQL',2004,'CARP',25.95),
    ('Humor in SQL',2004,'YRB Silver',27.95),
    ('Humor in SQL',2004,'YRB Gold',26.95),
    ('Humor in SQL',2004,'Oprah',26.95),
    ('Humor in SQL',2004,'York Club',26.95),
    ('Humor in SQL',2004,'Waterloo Club',26.45),
    ('Humor in SQL',2004,'Guelph Club',27.95);

insert into yrb_purchase (cid,club,title,year,when,qnty) values
    (1,'Basic','Will Snoopy find Lucy?',1990,'2005-12-1-11.59.00',1),
    (1,'Readers Digest','Flibber Gibber',2004,'2005-12-1-11.59.00',1),
    (1,'Readers Digest','Yon-juu Hachi',1948,'2003-4-20-12.12.00',1),
    (1,'York Club','Nothing but Steak',1995,'2005-12-1-11.59.00',1),
    (1,'Readers Digest','Getting into Snork U.',2004,'2005-12-1-11.59.00',1),
    (2,'Oprah','The Vampires Among Us',1999,'2002-8-8-17.33.00',1),
    (2,'YRB Gold','Rats Like Us',1997,'2005-10-21-11.05.00',1),
    (2,'CAA','Alpha Centauri',2002,'2003-4-16-11.46.00',1),
    (2,'Oprah','Vegetables are Good!',2003,'2005-4-24-17.02.00',1),
    (2,'YRB Gold','The Earth is not Enough',2003,'2005-2-23-12.37.00',1),
    (2,'YRB Gold','Cuisine Anglaise!?',1997,'2002-8-8-17.33.00',2),
    (2,'Oprah','Rabbits are nice',1996,'2003-2-13-15.13.00',1),
    (2,'Oprah','Under Your Bed',2004,'2005-4-24-17.02.00',1),
    (2,'CAA','Tsukimono to Tsukemono',2004,'2005-12-1-15.39.00',1),
    (2,'CAA','Tsukimono to Tsukemono',2004,'2005-10-21-11.05.00',1),
    (2,'YRB Gold','Press the Red Button!',2003,'2005-4-24-17.02.00',1),
    (3,'CARP','Rats Like Us',1997,'2002-1-27-09.19.00',1),
    (3,'Guelph Club','Tampopo Oishii',1999,'2005-10-6-11.12.00',1),
    (3,'CAA','Math is fun!',1995,'2002-1-27-09.19.00',1),
    (3,'CARP','Parthenon',2004,'2005-10-6-11.12.00',1),
    (3,'CAA','Rigor Mortis',1023,'2002-1-27-09.19.00',1),
    (3,'CARP','Live in London?!',2002,'2005-10-6-11.12.00',1),
    (3,'CAA','Tsukimono to Tsukemono',2004,'2005-10-6-11.12.00',1),
    (3,'CARP','Relational Algebra',2004,'2005-10-6-11.12.00',1),
    (4,'Oprah','Eigen Eigen',1980,'2005-8-11-17.40.00',1),
    (4,'Oprah','Food for Dummies',2004,'2005-6-30-13.58.00',1),
    (4,'Oprah','Rigor Mortis',1023,'2005-6-30-13.58.00',1),
    (4,'YRB Silver','Are my feet too big?',1993,'2004-6-13-09.45.00',1),
    (4,'Oprah','Chats ne sont pas Chiens',1996,'2005-6-30-13.58.00',1),
    (5,'Basic','Yon-juu Hachi',1948,'2005-7-17-16.27.00',1),
    (5,'CARP','Ou est Ce Canada?',1998,'2005-7-17-16.27.00',1),
    (5,'CARP','Montreal est dans Quebec',1999,'2005-7-17-16.27.00',1),
    (5,'CARP','Curiouser and Curiouser',1953,'2005-7-17-16.27.00',1),
    (5,'CARP','Under Your Bed',2004,'2005-7-17-16.27.00',1),
    (5,'CARP','The Wiley Snark',1980,'2005-7-17-16.27.00',1),
    (5,'Basic','Avarice is Good',1998,'2005-7-17-16.27.00',1),
    (6,'CAA','Je ne me souvien pas',1997,'2005-10-2-12.37.00',1),
    (6,'CAA','Acrimony Made Simple',1996,'2004-5-18-11.43.00',1),
    (6,'Readers Digest','Legacy Software made Fun',2004,'2005-7-8-18.09.00',1),
    (6,'Readers Digest','Live in London?!',2002,'2005-7-8-18.09.00',1),
    (6,'Basic','Not That London!',2003,'2004-5-18-11.43.00',1),
    (6,'Readers Digest','Base de Donne',2003,'2004-5-18-11.43.00',1),
    (7,'YRB Gold','Toronto Underground',2001,'2003-6-15-12.13.00',1),
    (7,'Basic','Ringo to Nashi',1997,'2003-6-15-12.13.00',1),
    (7,'Basic','Ringo to Nashi',1997,'2004-5-5-14.49.00',1),
    (7,'YRB Gold','Cats are not Dogs',1996,'2004-9-26-16.32.00',1),
    (8,'CAA','Ou est Ce Canada?',1998,'2004-7-3-12.39.00',1),
    (8,'Oprah','Capricia''s Conundrum',1993,'2003-1-19-09.32.00',1),
    (8,'Oprah','Eigen Eigen',1980,'2005-10-18-10.18.00',1),
    (8,'Oprah','Okay, Why Not?',2001,'2004-7-3-12.39.00',1),
    (8,'Oprah','Yum, Yum, English Cooking',1997,'2003-8-2-09.20.00',1),
    (8,'CAA','Not That London!',2003,'2005-10-18-10.18.00',1),
    (8,'CAA','I don''t think so',2001,'2005-8-13-13.11.00',1),
    (9,'Waterloo Club','Plato Rocks',1975,'2005-9-10-13.03.00',1),
    (9,'Oprah','Tampopo Oishii',1997,'2005-9-10-13.03.00',1),
    (9,'Oprah','Napolean''s Revenge',1952,'2005-9-10-13.03.00',1),
    (9,'CAA','Montreal est dans Quebec',1999,'2005-9-10-13.03.00',1),
    (9,'CAA','Food for Dummies',2004,'2005-9-10-13.03.00',1),
    (9,'CAA','Math is fun!',1993,'2005-9-10-13.03.00',1),
    (9,'CAA','Tropical Windsor',2004,'2005-9-10-13.03.00',1),
    (9,'Waterloo Club','Montreal pour les Idiots',2002,'2005-9-10-13.03.00',1),
    (10,'Basic','Tande mou nai',2002,'2005-3-11-15.46.00',1),
    (10,'CARP','Yakuza Kekkon Shita',1996,'2005-4-29-18.30.00',1),
    (10,'CARP','Capricia''s Conundrum',1993,'2004-3-11-10.05.00',1),
    (10,'CARP','Databases aren''t',2004,'2005-3-11-15.46.00',1),
    (10,'CARP','Vegetables are Good!',2003,'2005-4-29-18.30.00',1),
    (11,'YRB Silver','Radiator Barbecuing',2002,'2005-7-27-11.45.00',1),
    (11,'YRB Silver','Ringo to Nashi',1997,'2005-7-27-11.45.00',1),
    (11,'YRB Silver','The Stars are not Enough',2002,'2005-7-27-11.45.00',1),
    (11,'YRB Silver','Yum, Yum, English Cooking',1997,'2005-7-27-11.45.00',1),
    (11,'YRB Silver','Pigs are nice',1996,'2005-7-27-11.45.00',1),
    (12,'Oprah','Databases aren''t',2004,'2005-8-24-11.12.00',1),
    (12,'CAA','Getting into Snork U.',2004,'2005-8-24-11.12.00',1),
    (12,'Oprah','Are my feet too big?',1993,'2003-2-7-10.59.00',1),
    (12,'CAA','Not That London!',2003,'2005-8-24-11.12.00',1),
    (13,'YRB Silver','Suzy does Waterloo',2001,'2005-5-18-10.11.00',1),
    (13,'Waterloo Club','I''m Sorry, But No',2003,'2005-9-14-12.56.00',1),
    (13,'Oprah','Dogs are not Cats',1995,'2005-5-18-10.11.00',1),
    (13,'Oprah','Are my feet too big?',1993,'2005-5-18-10.11.00',1),
    (13,'Oprah','Are my feet too big?',1997,'2002-3-17-14.04.00',1),
    (14,'Oprah','Oberon',1963,'2005-10-10-17.18.00',1),
    (14,'Oprah','Yon-juu Hachi',1948,'2005-10-10-17.18.00',1),
    (14,'Oprah','Radiator Barbecuing',2002,'2005-10-10-17.18.00',1),
    (14,'Oprah','Bobbie Sue Ellen',1999,'2005-10-10-17.18.00',1),
    (14,'Oprah','Legacy Software made Fun',2004,'2005-10-10-17.18.00',1),
    (14,'Oprah','Cuisine Anglaise!?',1997,'2005-10-10-17.18.00',2),
    (14,'Oprah','Meine Kleine Katze',2002,'2005-10-10-17.18.00',1),
    (14,'Oprah','Rabbits are nice',2004,'2005-10-10-17.18.00',1),
    (15,'YRB Gold','Quarks and Other Matter',2000,'2004-12-1-18.27.00',1),
    (15,'YRB Gold','Databases made Real Hard',2002,'2004-12-1-18.27.00',1),
    (15,'YRB Gold','SQL Kills!',2003,'2004-12-1-18.27.00',1),
    (15,'CARP','Rabbits are nice',1996,'2004-12-1-18.27.00',1),
    (15,'CARP','Cats are not Dogs',1996,'2004-12-1-18.27.00',1),
    (16,'York Club','Tensor Calculus made Easy',1996,'2005-2-27-15.08.00',1),
    (16,'York Club','Plato Rocks',1975,'2004-1-4-14.18.00',1),
    (16,'York Club','The Stars are not Enough',2002,'2005-2-27-15.08.00',1),
    (16,'CAA','Under Your Bed',2004,'2005-11-16-09.52.00',1),
    (16,'CAA','Tropical Windsor',2004,'2005-11-16-09.52.00',3),
    (16,'CAA','Base de Donne',2003,'2005-2-27-15.08.00',1),
    (16,'York Club','Humor in SQL',2004,'2005-11-16-09.52.00',1),
    (17,'Basic','Quarks and Other Matter',2000,'2005-9-13-12.08.00',1),
    (17,'Basic','Montreal est dans Quebec',1999,'2003-6-7-10.13.00',1),
    (17,'Basic','Been There Done That',2002,'2005-9-13-12.08.00',1),
    (17,'Basic','Chats ne sont pas Chiens',1996,'2002-4-8-17.59.00',1),
    (17,'Basic','Humor in SQL',2004,'2005-9-13-12.08.00',1),
    (18,'Basic','Tande mou nai',2002,'2005-9-22-10.01.00',1),
    (18,'Basic','SQL Kills!',2003,'2005-9-22-10.01.00',1),
    (18,'Basic','The Fickle Pickle',2004,'2005-9-22-10.01.00',1),
    (19,'YRB Gold','Les Gens Miserable',1996,'2005-12-1-16.10.00',1),
    (19,'CAA','Pluto Collides With Mars',2004,'2005-12-1-16.10.00',1),
    (19,'CAA','Transmorgifacation',2004,'2005-7-23-09.27.00',1),
    (19,'Oprah','Recipes for Humans',2004,'2005-7-23-09.27.00',1),
    (19,'CAA','Please Beam Me Up',2004,'2005-12-1-16.10.00',1),
    (19,'YRB Gold','Nothing but Steak',1995,'2003-3-9-12.11.00',1),
    (19,'CAA','Math is fun!',1995,'2003-3-9-12.11.00',1),
    (19,'YRB Gold','I don''t think so',2001,'2003-3-9-12.11.00',1),
    (19,'CAA','Quantum Databases',2003,'2005-7-23-09.27.00',1),
    (19,'Oprah','Base de Donne',2003,'2005-12-1-16.10.00',1),
    (19,'YRB Gold','Press the Red Button!',2003,'2005-12-1-16.10.00',1),
    (20,'Oprah','Tchuss',2002,'2004-5-27-17.56.00',1),
    (20,'Readers Digest','Play me a Song',1997,'2003-11-22-14.29.00',1),
    (20,'Readers Digest','Cuisine Anglaise!?',1997,'2003-11-22-14.29.00',1),
    (20,'Readers Digest','Rabbits are nice',2004,'2005-6-1-09.37.00',4),
    (20,'Readers Digest','Tsukimono to Tsukemono',2004,'2005-6-1-09.37.00',3),
    (21,'Waterloo Club','Plato Rocks',1975,'2005-11-19-11.02.00',1),
    (21,'YRB Silver','Tande mou nai',2002,'2005-11-19-11.02.00',1),
    (21,'Waterloo Club','Oberon',1963,'2005-3-10-15.05.00',1),
    (21,'Waterloo Club','Play me a Song',1997,'2004-2-15-13.22.00',1),
    (21,'CAA','SQL Kills!',2003,'2005-3-10-15.05.00',1),
    (21,'Waterloo Club','Where are my Socks?',1998,'2002-2-17-16.08.00',1),
    (21,'YRB Silver','Getting into Snork U.',2004,'2005-3-10-16.22.00',1),
    (21,'Basic','Not That London!',2003,'2005-11-19-11.02.00',1),
    (21,'CAA','Rabbits are nice',2004,'2005-10-25-10.15.00',1),
    (21,'Waterloo Club','Avarice is Good',1998,'2005-11-19-11.02.00',1),
    (21,'Waterloo Club','Avarice is Good',1998,'2005-3-10-15.05.00',1),
    (22,'YRB Bronze','Will Snoopy find Lucy?',1990,'2005-3-4-17.13.00',1),
    (22,'YRB Gold','Tampopo Oishii',1997,'2005-8-16-16.59.00',1),
    (22,'Guelph Club','Where are my Socks?',1998,'2005-10-23-11.24.00',1),
    (22,'Guelph Club','Pigs are nice',1996,'2005-3-4-17.13.00',1),
    (22,'Readers Digest','Are my feet too big?',1997,'2005-3-4-17.13.00',1),
    (22,'YRB Gold','Avarice is Good',1998,'2005-3-4-17.13.00',1),
    (23,'Basic','Toronto Underground',2001,'2005-6-23-16.45.00',1),
    (23,'Basic','Toronto Underground',2001,'2005-10-27-18.01.00',1),
    (23,'Oprah','Rats Like Us',1997,'2002-7-4-16.33.00',1),
    (23,'Oprah','Voting for Dummies',2004,'2005-10-27-18.01.00',1),
    (23,'Oprah','Montreal est dans Quebec',1999,'2004-9-27-12.27.00',1),
    (23,'Basic','Is Math is fun?',1996,'2005-10-27-18.01.00',1),
    (23,'Oprah','Where are my Socks?',1998,'2004-9-26-13.17.00',1),
    (23,'Basic','Tropical Windsor',2004,'2005-10-27-18.01.00',1),
    (23,'Oprah','Relational Algebra',2004,'2005-6-23-16.45.00',1),
    (23,'Oprah','Ottawa Hot Spots',2002,'2004-9-26-13.17.00',1),
    (23,'Oprah','Ottawa Hot Spots',2002,'2004-9-27-12.27.00',1),
    (24,'Readers Digest','Rats Like Us',1999,'2005-10-23-14.59.00',1),
    (24,'Readers Digest','Food for Dummies',2004,'2005-10-23-14.59.00',1),
    (24,'Readers Digest','Humor in SQL',2004,'2005-10-23-14.59.00',1),
    (25,'CARP','Capricia''s Conundrum',1993,'2005-3-14-09.26.00',1),
    (25,'York Club','SQL Kills!',2003,'2005-11-30-14.23.00',10),
    (25,'CARP','Brats like Us',1999,'2005-3-14-09.26.00',1),
    (25,'CARP','Quantum Databases',2003,'2005-3-14-09.26.00',1),
    (26,'York Club','Plato Rocks',1975,'2005-4-27-15.07.00',1),
    (26,'York Club','Les Gens Miserable',1996,'2005-6-30-11.26.00',1),
    (26,'York Club','Tampopo Oishii',1997,'2005-12-1-18.04.00',1),
    (26,'YRB Silver','Flibber Gibber',2004,'2005-4-27-15.07.00',1),
    (26,'York Club','Eigen Eigen',1980,'2005-6-30-11.26.00',1),
    (26,'York Club','Ringo to Nashi',1997,'2005-12-1-18.04.00',1),
    (26,'YRB Silver','Math is fun!',1995,'2005-4-27-15.07.00',1),
    (26,'CAA','Acrimony Made Simple',1996,'2005-6-30-11.26.00',1),
    (26,'York Club','Brats like Us',1999,'2005-4-27-15.07.00',1),
    (26,'CAA','Getting into Snork U.',2004,'2005-4-27-15.07.00',1),
    (26,'CAA','Are my feet too big?',1993,'2005-12-1-18.04.00',1),
    (27,'CAA','Tchuss',2002,'2004-6-5-09.44.00',1),
    (27,'York Club','Je ne me souvien pas',1997,'2004-6-5-09.44.00',1),
    (28,'Oprah','Napolean''s Revenge',1952,'2003-7-17-10.14.00',1),
    (28,'Basic','Databases made Real Hard',2002,'2005-7-20-16.52.00',1),
    (28,'YRB Gold','SQL Kills!',2003,'2005-2-3-15.50.00',1),
    (28,'YRB Gold','The Stars are not Enough',2002,'2005-2-13-12.08.00',1),
    (28,'Oprah','Tomenatte Kudasai!',2000,'2005-2-13-12.08.00',1),
    (28,'Oprah','Meine Kleine Katze',2002,'2005-7-20-16.52.00',3),
    (28,'Oprah','Meine Kleine Katze',2002,'2005-2-3-15.50.00',1),
    (28,'Oprah','Relational Algebra',2004,'2005-2-3-15.50.00',1),
    (29,'UofT Club','Quarks and Other Matter',2000,'2005-9-20-10.19.00',1),
    (29,'UofT Club','Databases aren''t',2004,'2005-9-20-10.19.00',1),
    (29,'Basic','Dogs are not Cats',1995,'2005-6-10-17.16.00',1),
    (29,'UofT Club','Darmstadt',2004,'2005-6-10-17.16.00',1),
    (29,'Basic','Are my feet too big?',1993,'2005-9-20-10.19.00',1),
    (29,'UofT Club','Rabbits are nice',1996,'2005-6-10-17.16.00',1),
    (30,'YRB Silver','Will Snoopy find Lucy?',1990,'2005-10-20-15.28.00',1),
    (30,'Readers Digest','Tande mou nai',2002,'2005-10-20-15.28.00',1),
    (30,'YRB Silver','Suzy does Waterloo',2001,'2005-12-1-14.50.00',1),
    (30,'Basic','Tchuss',2002,'2003-5-22-16.59.00',1),
    (30,'Readers Digest','Parthenon',2004,'2005-10-20-15.28.00',1),
    (30,'Readers Digest','Getting into Snork U.',2004,'2005-12-1-14.50.00',1),
    (30,'Guelph Club','Strike Once, Strike Twice',2004,'2005-10-20-15.28.00',1),
    (32,'CAA','Transmorgifacation',2004,'2005-5-18-10.43.00',1),
    (32,'CAA','Alpha Centauri',2002,'2003-5-5-14.20.00',1),
    (32,'Oprah','Recipes for Humans',2004,'2005-5-18-10.43.00',1),
    (32,'CAA','Okay, Why Not?',2001,'2003-5-5-14.20.00',1),
    (32,'Oprah','The Earth is not Enough',2003,'2005-5-18-10.43.00',1),
    (32,'CAA','Cats are not Dogs',1996,'2004-5-12-13.51.00',1),
    (32,'YRB Gold','Press the Red Button!',2003,'2005-5-18-10.43.00',1),
    (32,'YRB Gold','DB2, DB3, and Beyond!',2004,'2005-5-18-10.43.00',1),
    (33,'Waterloo Club','Yon-juu Hachi',1948,'2003-9-30-14.05.00',2),
    (33,'Waterloo Club','Oui, Oui, Non!',1992,'2003-2-7-18.58.00',1),
    (33,'Waterloo Club','Tchuss',2002,'2003-9-30-14.05.00',1),
    (33,'CARP','Play me a Song',1997,'2003-2-7-18.58.00',1),
    (33,'Waterloo Club','Curiouser and Curiouser',1953,'2003-9-30-14.05.00',1),
    (33,'CARP','The Stars are not Enough',2002,'2003-2-7-18.58.00',1),
    (33,'Waterloo Club','Not That London!',2003,'2005-9-18-12.48.00',1),
    (33,'CARP','I don''t think so',2001,'2005-9-18-12.48.00',1),
    (34,'UofT Club','Rats Like Us',1999,'2003-5-29-15.57.00',1),
    (34,'UofT Club','Aubergines!',2000,'2003-5-29-15.57.00',1),
    (35,'Readers Digest','Napolean''s Revenge',1952,'2005-3-28-15.49.00',1),
    (35,'UofT Club','Databases aren''t',2004,'2005-3-19-18.38.00',1),
    (35,'UofT Club','Akachan Furu',2003,'2005-3-19-18.38.00',1),
    (35,'Readers Digest','Cats are not Dogs',1996,'2005-3-28-15.49.00',1),
    (36,'YRB Silver','The Vampires Among Us',1999,'2004-1-27-10.17.00',1),
    (36,'CARP','La Petite Chou',2001,'2003-10-30-15.25.00',1),
    (36,'CARP','Napolean''s Revenge',1952,'2003-10-30-15.25.00',1),
    (36,'Guelph Club','Databases made Real Hard',2002,'2003-10-30-15.25.00',1),
    (36,'CARP','Vegetables are Good!',1992,'2004-11-4-09.06.00',1),
    (36,'CARP','Vegetables are Good!',1992,'2003-6-22-11.42.00',1),
    (37,'York Club','Will Snoopy find Lucy?',1990,'2004-11-25-17.53.00',1),
    (37,'Oprah','Les Gens Miserable',1996,'2003-1-11-09.51.00',1),
    (37,'Oprah','La Petite Chou',2001,'2004-11-25-17.53.00',1),
    (37,'York Club','Rats Like Us',1997,'2003-1-11-09.51.00',1),
    (37,'Oprah','Eigen Eigen',1980,'2004-12-1-17.21.00',1),
    (37,'Oprah','Okay, Why Not?',2001,'2003-1-11-09.51.00',1),
    (37,'CAA','Is Math is fun?',1996,'2004-12-1-17.21.00',1),
    (37,'CAA','Avarice is Good',1998,'2005-10-21-16.49.00',1),
    (38,'YRB Silver','Will Snoopy find Lucy?',1990,'2001-10-11-17.15.00',1),
    (38,'Oprah','Les Gens Miserable',1996,'2001-10-11-17.15.00',1),
    (38,'YRB Silver','Ou est Ce Canada?',1998,'2001-10-11-17.15.00',1),
    (38,'Waterloo Club','Curiouser and Curiouser',1953,'2001-10-11-17.15.00',1),
    (38,'Waterloo Club','Math is fun!',1995,'2001-10-11-17.15.00',1),
    (38,'Oprah','Bobbie Sue Ellen',1999,'2001-10-11-17.15.00',1),
    (39,'Readers Digest','Rats Like Us',1999,'2005-1-9-16.22.00',1),
    (39,'Readers Digest','Databases made Real Hard',2002,'2004-3-9-13.46.00',1),
    (39,'Readers Digest','Databases made Real Hard',2002,'2005-1-9-16.22.00',2),
    (39,'CAA','I''m Sorry, But No',2003,'2005-7-3-14.12.00',1),
    (39,'CAA','Rigor Mortis',1023,'2005-1-9-16.22.00',1),
    (39,'YRB Bronze','Base de Donne',2003,'2005-1-9-16.22.00',1),
    (39,'YRB Bronze','Base de Donne',2003,'2004-3-9-13.46.00',1),
    (40,'Waterloo Club','Pluto Collides With Mars',2004,'2005-9-30-10.26.00',1),
    (40,'Waterloo Club','Quarks and Other Matter',2000,'2003-1-27-09.36.00',1),
    (40,'Waterloo Club','Bancroft''s Great!',2003,'2004-5-17-14.17.00',1),
    (40,'Waterloo Club','Montreal est dans Quebec',1999,'2003-6-12-17.18.00',1),
    (40,'Waterloo Club','Nothing but Steak',1995,'2002-7-27-17.39.00',1),
    (40,'Waterloo Club','Akachan Furu',2003,'2005-4-8-15.39.00',1),
    (40,'Waterloo Club','Legacy Software made Fun',2004,'2005-9-30-10.26.00',1),
    (40,'Waterloo Club','Avarice is Good',1998,'2003-6-12-17.18.00',1),
    (41,'CAA','Tampopo Oishii',1999,'2002-8-23-09.39.00',1),
    (41,'CAA','Play me a Song',1997,'2005-3-30-15.26.00',1),
    (41,'CAA','Play me a Song',1997,'2002-6-5-10.06.00',1),
    (41,'CAA','Math is fun!',1995,'2002-6-5-10.06.00',1),
    (41,'CAA','Bobbie Sue Ellen',1999,'2003-12-1-18.42.00',1),
    (41,'CAA','Been There Done That',2002,'2003-12-1-18.42.00',1),
    (41,'CAA','Yum, Yum, English Cooking',1997,'2003-12-1-18.42.00',1),
    (41,'Basic','Where art thou Bertha?',2003,'2005-3-30-15.26.00',1),
    (41,'CAA','I don''t think so',2001,'2002-8-23-09.39.00',1),
    (41,'CAA','Quantum Databases',2003,'2005-11-15-15.33.00',1),
    (41,'CAA','Avarice is Good',1998,'2002-6-5-10.06.00',1),
    (42,'Readers Digest','Rats Like Us',1999,'2005-8-19-14.18.00',1),
    (42,'Readers Digest','Nippon no Joodan',2001,'2004-6-22-12.16.00',1),
    (42,'Basic','Radiator Barbecuing',2002,'2005-1-13-15.03.00',2),
    (42,'York Club','Okay, Why Not?',2001,'2004-6-22-12.16.00',1),
    (42,'York Club','Where are my Socks?',1998,'2005-1-13-15.03.00',1),
    (42,'Readers Digest','Rabbits are nice',2004,'2005-8-19-14.18.00',1),
    (42,'Readers Digest','Strike Once, Strike Twice',2004,'2005-8-19-14.18.00',1),
    (42,'Readers Digest','Base de Donne',2003,'2005-8-19-14.18.00',2),
    (43,'YRB Gold','Bancroft''s Great!',2003,'2004-8-4-12.16.00',1),
    (43,'YRB Gold','Yon-juu Hachi',1948,'2003-1-22-15.46.00',1),
    (43,'YRB Gold','Vegetables are Good!',1992,'2002-7-7-11.29.00',1),
    (43,'YRB Gold','Legacy Software made Fun',2004,'2005-3-17-14.18.00',1),
    (43,'YRB Gold','Strike Once, Strike Twice',2004,'2005-3-17-14.18.00',1),
    (43,'YRB Gold','DB2, DB3, and Beyond!',2004,'2005-3-17-14.18.00',1),
    (44,'YRB Gold','Tensor Calculus made Easy',1996,'2003-11-3-09.32.00',1),
    (44,'Readers Digest','Oberon',1963,'2005-7-18-12.59.00',1),
    (44,'Basic','Transmorgifacation',2004,'2005-10-23-10.04.00',1),
    (44,'CAA','Okay, Why Not?',2001,'2005-10-23-10.04.00',1),
    (44,'CAA','Math is fun!',1993,'2005-10-23-10.04.00',1),
    (44,'Readers Digest','Cuisine Anglaise!?',1997,'2005-10-23-10.04.00',1),
    (44,'UofT Club','Rabbits are nice',2004,'2005-11-9-16.18.00',1),
    (44,'CAA','Quantum Databases',2003,'2005-5-26-17.23.00',1),
    (45,'Oprah','Capricia''s Conundrum',1993,'2004-3-19-10.31.00',1),
    (45,'York Club','Okay, Why Not?',2001,'2004-3-19-10.31.00',1),
    (45,'York Club','The Stars are not Enough',2002,'2004-3-19-10.31.00',1),
    (45,'York Club','Eigen Eigen',1980,'2005-7-14-11.36.00',1);

insert into yrb_shipping (weight, cost) values
    (6000,13.00),
    (5500,12.00),
    (5000,10.00),
    (4500,9.00),
    (4000,8.00),
    (3500,7.50),
    (3000,6.50),
    (2500,6.00),
    (2004,5.75),
    (1500,5.00),
    (1000,3.00),
    (500,2.00);