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.
6 freelancers estão ofertando em média $23 nesse trabalho
Hi i can help you with the sql query i have experience 6+ years of experience in optimizing, writing and managing complex query. I believe i can do this as per your requirements. Let me know i xan start right now.