Task $5(20\%)$: Customer tracking is essential to your uncle. He requests a list

of his best customers based on the amount of money spent. Create a query that displays the Customer Name, The Customer State, and calculates the total amount of money that customer has spent. For the state of OK $($Oklahoma$),$ assume that $1\%$ of the amount spent is paid to the state, so you should only show $99\%$ of the calculation for OK$.$ Show the best spending customer on top. Save the query as Best Customers. The results should look like this $($only top portion of report is 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.