Suppose you have a table named "Sales" with columns: sale$\_$id $($integer$),$ sale$\_$date $($date$),$ revenue $($decimal$),$ and region $($varchar$).$ Write a SQL query to calculate the moving average revenue for each region over the previous $3$ days. The result should include sale$\_$id$,$ sale$\_$date, revenue, region, and the moving average revenue.

Tables Schema as Below:

Sales

columnName dataType

sale$\_$id int

sale$\_$date date

revenue decimal$(10,2)$