Daily and MTD number of Sales and total revenue -- 2
Orçamento $10-30 USD
Job Description:
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
Hello, I have 10+ years of experience in web development and database programming. I read the problem statememt and screenshots(table structure) and I am sure that i can write the SQL query for mtd, day wise sale, and Mais
Hi , I have read your requirement. I'm an individual freelancer having 14 years of experience in Java, MySQL and it's related frameworks.I can complete the requirement at the earliest. Looking forward to your chat to Mais
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.
