$($Access$)$ Create static queries to summarize the results of transactions executed:

$$ Total Sales in Dollars by Customer: o Fields: Customer Name, Count of Sales, Total Sales $($$$)$ o Sort: Alphabetically by Customer Last Name $($or simply by Customer Name if you do not have First and Last Name fields separately$)$

$$ Gross Profit in Dollars by Inventory Item o Fields: Item #$,$ Item Description, Total Quantity Sold, Total Gross Profit o Sort: High to Low by Total Gross Profit

$$ EQOH $($Ending Quantity on Hand$)$ Report o Fields: Item #$,$ Item Description, Count of Items on Hand, Value of Items on Hand o Sort: High to Low by Value of Items on Hand

$$ Unshipped Inventory Report o Fields: Order #$,$ Item Description, Quantity Unshipped o Sort: High to Low by Order #

$$ Detailed Sales Report for Visualization o Fields: Ship #$,$ Ship Date, Order #$,$ Order Date, Customer #$,$ Customer Name, Street Address, Customer City, Customer State, Customer Zip, Customer Phone #$,$ Customer Segment, Sales Clerk #$,$ Sales Clerk Name, Ship Clerk #$,$ Ship Clerk Name, Total Inventory Cost for Order, Total Gross Profit for Order, SH Fee, Invoice Total

Please write in SQL code.