1. Create a report displaying all rows and columns.

2. Create a report by eliminating the duplicate rows for column class and warehouse.

3. Create a report specifying only the column PRICE, ONHAND and DESCRIPTION.

4. Create a report that will add 10% increase in PRICE. List only the column DESCRIPTION, CLASS and PRICE.

5. Create a report that will deduct 5 from ONHAND, multiply 5 in WAREHOUSE, after getting the value on both ONHAND and WAREHOUSE add their data: as shown below:

ONHAND - 5 + 5 * WAREHOUSE

Note that you have to force the Oracle to prioritize first the Subtraction over Multiplication. List only the column DESCRIPTION, ONHAND and WAREHOUSE.

6. Create a report that will rename the column DESCRIPTION to TITLE, PARTNUM to ID and ONHAND to STOCK.

7. Create a report the will merge the column CLASS and PRICE rename the COLUMN as CLASS PRICE.

8. Create a report that will combine the column PARTNUM and DESCRIPTION put a literal character string belongs to in between the two columns then rename the column as NUMBER TITLE. Note put space before and after the character literal string to avoid no spaces in the report.

9. Create a report that will display the unique value for WAREHOUSE rename the column as No. of Available Warehouse.

10. What is the help of SELECT statement? Is there any permanent made in the database once the user uses different SELECT.