if exists (select name from sysobjects where name ='productSale')
drop table productSale

create table productSale (
buyer varchar(255)
, productName varchar(255)
, purchaseDate datetime
, qtypurchased int
, pricePaid decimal(9,2)
)

insert into productSale
select 'Shannon Lowder','paper','1/1/2000','2','1.00' union
select 'Shannon Lowder','Mountain Dew','1/1/2000','1','1.25' union
select 'Shannon Lowder','pencil','1/5/2000','1','.25' union
select 'Shannon Lowder','pencil','1/7/2000','1','.25' union
select 'Shannon Lowder','Mountain Dew','1/10/2000','1','1.25' union
select 'Shannon Lowder','Mountain Dew','1/11/2000','1','1.25' union
select 'Shannon Lowder','Mountain Dew','1/12/2000','1','1.25' union
select 'Shannon Lowder','Mountain Dew','1/13/2000','1','1.25' union
select 'Shannon Lowder','Mountain Dew','1/14/2000','1','1.25'

if exists (select name from sysobjects where name ='products')
drop table products

create table products (
productName varchar(255)
, price decimal(9,2)
, quantity int
, color varchar(255)
)

insert into products
select 'pencil','.25','100','yellow' union
select 'pen','.99','73','blue' union
select 'paper','1.00','500','white' union
select 'Mountain Dew','1.25','8','green'

select productName
from products

select productName
from productSale

select productName
from products
union
select productName
from productSale

select productName
from products
union all
select productName
from productSale

select productName
from products
except
select productName
from productSale

select productName
from products
intersect
select productName
from productSale