Task $6(20\%)$: Create a report called Sales Report. First create a query that will feed into this report. Your query should also be saved as Sales Report. Display the Customer Name, Customer Address, Customer City, Customer State, Plant Name, and Quantity. Group the report on Customer Name and ensure that their full address is on the same line as the name. Subtotal the Quantity for each Customer as shown. All headings should be visible and data formatted correctly. Your output should resemble this $($note: only top of report showing$)$:

The dataset to be used has the "Customers" table has Customer ID$,$Customer Name, Customer Address, Customer City, Customer State, Customer Zip, Customer Country, Customer Telephone. The "Order Line" table has Order ID$,$Plant ID$,$Quantity$.$ The "Orders" table has Order ID$,$Customer ID$,$Date$,$ Clerk ID$.$The "Plants" table has Plant ID$,$Plant Name, Plant Type, Plant Description.

Please send sql on access that is used to create this.