Need Query and report help for MS access. SCHEMA = SQL

Queries:

1. For each Province and year, show the sum of Profit from the months of July, August, and September (use OrderDate). The sum should be for the entire three-month range. Each Province should have a separate value for each {Province, year} pair.
2. Show all fields of any records with delivery truck ShipMode if the ProductContainer is Jumbo Drum.

Reports:

1. Show all fields of all records, grouped by ShipMode and then by OrderPriority
2. For each ShipMode, show the sum of profit grouped by ProductContainer. You can include the sums using the "Summary Options" button in the third Report Wizard window, where you select ascending or descending order.

1 Invoices x Query6 Field Name RowID Order Date Order Priority OrderQuantity Sales Ship Mode Profit Unit Price Shipping Cost Province Query3 Data Type AutoNumber Date/Time Short Text Number Currency Short Text Currency Currency Currency Short Text Field Propert Long Integer Increment General Lookup Field Size New Values Format Caption Indexed Text Align Yes (No Duplicates) General 1 Invoices x Query6 Field Name RowID Order Date Order Priority OrderQuantity Sales Ship Mode Profit Unit Price Shipping Cost Province Query3 Data Type AutoNumber Date/Time Short Text Number Currency Short Text Currency Currency Currency Short Text Field Propert Long Integer Increment General Lookup Field Size New Values Format Caption Indexed Text Align Yes (No Duplicates) General