#<pre><code>
#1- First query is a source add a meaningful comment here
# source will not work in PHPMyAdmin
Source /home/premiere/public_html/fruitAlter.sql.html;

#2 Describe/explain column structure fruit
# this is easy its just one sql keyword then table name

#3 Display Contents of fruit table sort fruitID ASC

#4 Display inventory:table (use given order by clause)
# ORDER BY `inventory`.`fruitID` ASC , quantity ASC

#5 Include in comment why is order plural
analyze table customer, fruit, inventory, `orders`;


# Develop a Good Initial Plan (Outline - blueprint)
# Always Test Thoroughly Before Continuing
# You should verify that all your tables are correct
# 
# When you create your view code, make sure the views have the correct data
# you will see a view tab added to your database in PHPMyAdmin
# Refer to 2nd PMAView video set for rest of queries


</pre></code>