6. Create a report listing only the column PARTNUM, CLASS and ONHAND of all parts where partnumis equal to AT94, DR93 and KV29. (Note 1 query only and do not use logical condition)

7. Create a report listing only the column DESCRIPTION, ONHAND, CLASS and PRICE of all pricewhere the description ends with letter N.

8. Create a report listing only the column DESCRIPTION, WAREHOUSE, CLASS and PRICE of all parts where the description contains keyword SHE.

9. Create a report listing only the column DESCIPTION, PARTNUM, CLASS and PRICE of all parts where the description fourth letter starting from the first is equal to D.

10. Create a report showing all rows and columns sort the description in ascending order.

11. Create a report that will merge the column DESCRIPTION and PRICE put a literal character string of = with a price of in between the two columns. Limit the rows returned by getting only the partnumthat starts with letter K.

12. Create a report that will display the distinct value for CLASS and WAREHOUSE limit the rows by getting only the parts under WAREHOUSE 3.

13. Create a report by listing the column DESCRIPTION, WAREHOUSE and ONHAND. Get only the warehouse value equal to 3 and the onhand value is equal to 21.

14. Create a report by listing the column PARTNO, DESCRIPTION and PRICE. Get only those Partnumthat either starts with letter K or price that is less than 500. Sort your report by price in ascending order.

15. Create a report by listing the column PARTNO, DESCRIPTION and WAREHOUSE. Get only that description that does not ends with ER. Note that you have to merge the said three columns, rename the merge column as Parts Record. Below is the sample output for column.

Parts Record

AT94 is the part number of IRON which belong to warehouse 3