Create a summary query that summarizes the total revenue for each store.

Use the following tables and fields to create your query:

Table

Field

Stores

StoreID

Transactions

Revenue

Your query will have $10$ records. Modify your query by inserting the State field after the StoreID field, set the query so results will be in ascending order by State. Re$-$run the query.

Close and save your query as RevenueByStoreQry.