Percentage of Total by Group

Return each region's total sales and its percentage of the overall total, rounded to two decimals. Order by region.

Table schema

Sales(id INT PRIMARY KEY, region VARCHAR(10), amount INT)

Sample data

id | region | amount
1 | East | 60
2 | East | 40
3 | West | 100