Paula Noone
SQL - Summer, 2009
Tutorial Assignment


#1 display tables in database
show tables;

#2 show fruit table
select * from fruit;

#3show inventory table
select * from inventory;

#4show format and field types or names for fruit table
describe fruit;

#5show format and field types or names for inventory table
describe inventory;

#6display only fruit names
select name from fruit;

#7display total inventory quantity for fruit
select sum(quantity) from inventory;

#8display fruit name with fruitID=1
select name from fruit where fruitID=1;

#9sum all fruit in inventory where fruitID 1
select sum(quantity) from inventory where fruitID=1;

#10verify both 7 and 9 are correct
select * from inventory;