Daily and MTD number of Sales and total revenue -- 3

Job ID: 34859142

Budget: $10 – $30 USD

I have two tables, Sales and Revenue, which are the sales and revenue for each city.
please see the screenshot of the tables
I need a SQL Server query that gives today and MTD values:
* Total number of sales in each city- Today
* Total number of sales in each city- MTD
* Total Amount in each city - Today
* Total Amount in each city - MTD
I need these 4 columns in one table with the city column.
please see the screenshot of the result table

I appreciate your help.
Related categories: SQL Microsoft SQL Server