Final answer:
A SQL query using SUM(), GROUP BY, and ORDER BY can show the total sales per state from the Orders table and reveal which state has the highest sales.
Step-by-step explanation:
To write a SQL query that shows the total dollar amount of items shipped to each state and to find out which state has the highest sales, we would need to sum the total sales for each state and order the results by the state. The SQL query could look something like this, assuming we have a table named Orders with the columns State and DollarAmount:
SELECT State, SUM(DollarAmount) AS TotalSales
FROM Orders
GROUP BY State
ORDER BY State;
This query uses the SUM() function to calculate the total sales for each state, the GROUP BY clause to aggregate the results by state, and the ORDER BY clause to sort the results by the state in ascending order. After running the query, the state with the highest total in the TotalSales column would be the state with the highest sales.