Execute the commands in this file to create the sampleparts table. If you already created a parts table for your project, you can work on that table instead.

The fields in the table are:

pno number(5) not null primary key,
pname varchar2(30),
qoh integer check(qoh >= 0),
listprice number(6,2) check(listprice >= 0.00),
reorderlevel integer,
reorderqty integer
lastordered date

1. List all the parts that have fallen below their reorder level.

2. Change the query above to include the part and quantity to be reordered.

3. Sum all the quantities to be reordered.

4. Change the query abovt to add the count of all the quantities being reordered.

5. Find all the parts last ordered in the month of march.

6. Find all the parts last ordered in the month of march and year 2000.