HELP, HELP, HELP!!

I really really need help with the following SQL assignment. I am not sure how to do it and I have tried a lot but now there is not enough time to keep trying, it is due soon. Please help.

Can you please show both the Command line ( or SQL statement) and the OUTPUT results, please? Thank you.

Below are questions and tables.

The questions are:

1) List the green items of type C.

2) Find the names of green items sold by the Recreation Department.

3) Of those items delivered, find the items not delivered to the Books department.

4) Find the departments that have never sold a geopositioning system.

5) Find the departments that have sold compasses and at least two other items.

Please show both the Command line and Output results. Thank you.

Da QSALE deptname Clothes Clothes Navigation Clothes Equipment Clothes Recreation Navigation o saleqty itemname 2 Boots-snakeproof 1001 1002 1003 Pith helmet Sextant 3 Hat polar explorer 5 /Pith helmet 1005 1006 1- 1007 1008 1009 1010 5 Map measure Pocket knife-Nile Pocket knife-Nile es Compass Geopositioning system er Navigation 10111_Geopositioning system Books Sextant Pocket knife Nile Pocket knife-Nile Navigation Books Books 1012 1013 1014 10151 Pocket knife-Nile 1016 1017 1018 1019 1020 1 Pocket knife-Nile 1021 1022 1023 024 025 1026 Equipment Clothes Equipment Recreation Furniture Furniture Sextant me Sextant Sextant Sextant ket- eliv that Exploring in 10 Easy Lessons Books How to Win Foreign Friends Books Compass Books Books Recreation Recreation 1 Pith helmet s. Elephant polo stick Camel saddle QSPL splno splname 101 Global Books & Maps 102 Nepalese Corp 1All Sports Manufacturing 04 SweatshopsUnlimited 105 All Points, Inc. 106 So Paulo Manufacturing