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

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.

Habilidades: Microsoft SQL Server , SQL

Sobre o Cliente:
( 4 comentários ) ANAHEIM, United States

ID do Projeto: #34855766

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

$20 USD in 7 dias
(13 Comentários)

Hi There, Just went through your requirement of sales and revenue details as per mentioned format. I have been working on data systems for 15+ years and have extensive experience in Databases and designing complex SQL Mais

$20 USD em 1 dia
(8 Comentários)

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

$20 USD em 1 dia
(1 Comentário)

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.

$45 USD em 1 dia
(0 Comentários)