Help adding to MS SQL Query

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

We have a sales query we use to get total clients per salesperson, total sales per salesperson and a few other stats. I'm needing to add on to the current query so we can get current month statistics for daily average, On pace to complete, and variance (which is just Total Clients - Total Current Sales) columns so we can have stats for each salesperson.

SQL

Project ID: #33924493

About the project

40 proposals Remote project Active 1 year ago

Awarded to:

prasitkeng

Hi prospective client, I can complete this project in a short period of time. I have experience in SQL queries for more than 5 years. I strongly believe my experience can adapt to your project.

$50 USD in 1 day
(4 Reviews)
2.6

40 freelancers are bidding on average $131 for this job

Truonggiang86

Hello there, i think to add more the variace we still can use the old query but we need to add more formula total clients - total current sales but group by each month. Pls share me your current query and database and More

$180 USD in 2 days
(50 Reviews)
6.2
Sugidev

Hi there I have very good experience in sql. I can add the new columns into your existing query. Please message me and I can start right away. Thanks Suguna

$140 USD in 1 day
(29 Reviews)
5.2
Itblast

Hello I have gone through the job description and understand that you need Help adding to MS SQL Query I am an Expert IN SQL with over 6 years experience in working on it Can we discuss the project and scenarios in More

$140 USD in 7 days
(3 Reviews)
4.2
Shakerfawzy

Hi, I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an as More

$30 USD in 1 day
(13 Reviews)
4.1
Feriver

Hello there, How are you doing? ust saw your project posted. I am more than happy to discuss the task and work for you. That would be greater if I get some tasks so you can test my skill and expertise. Waiting for you More

$250 USD in 5 days
(2 Reviews)
3.6
nehashriva

Dear Client I am good in SQL and will help you out to add query. Please come on the chat to discuss further. Thanks Neha

$140 USD in 2 days
(2 Reviews)
3.5
freelancedev112

Hi,Kevin,How are you? I am good at MYSQL and can make mysql query for you,Please share me mysql file and Let's discuss more. Thank you.

$100 USD in 7 days
(1 Review)
2.3
Maxitnr

Hello, I am an engineer in information systems, specialist in warehousing, I can help you with your request quickly and with the expected results.

$50 USD in 1 day
(2 Reviews)
2.4
Asad9916

Hi I'm a professional Database Developer and Engineer. I have an 6 years experience in this field. I will do this task. Feel free to contact me. Thanks

$140 USD in 1 day
(5 Reviews)
2.1
shnexxx

Hi, I will be happy to help you work on this query. I think after getting the details we can decide on the best approach on how to structure it and how to get the best performance. I work daily with T-SQL and this ass More

$200 USD in 7 days
(2 Reviews)
1.5
shamshermanhas24

Main specialization: * developing Windows Desktop and Web solutions (mainly using C, C++, C#, ASP.NET) * converting/translating/porting code from one programming language to another programming language. * writing wrap More

$244 USD in 7 days
(0 Reviews)
0.0
Alikh12

Hi, I have carefully gone through your project requirements regarding your project. As an experienced Data Scientist and data analyst, I am sure I can help you with this project. I have worked for a few companies, and More

$170 USD in 4 days
(0 Reviews)
0.0
fabvelazquez3

PHP/SQL Guru Here. I can start right now. Please contact via chat.

$200 USD in 7 days
(0 Reviews)
0.0
jokicmarijan3

Dear kkdaybreak! I am sql expert and can perform your problem perfectly. If you want , chat more detail about your project. I will explain about your project.

$100 USD in 7 days
(0 Reviews)
0.0
alievprogramist

Dear sir, thanks for the job posting. I am very interested in this project. I have solid knowledge in MySQL and I have vast experience for more than 12 years in SQL queries. I am also well-versed in Postgres, MS Acce More

$140 USD in 7 days
(0 Reviews)
0.0
namembk

Hi, I can build you MySQL query for daily statistics with ease as I got over 5 years of experience in building websites. Ping me to discuss further Thanks Best Regards

$75 USD in 3 days
(0 Reviews)
0.0
PhDWriter12

Hello I am a professional web developer and have 10+ years long history. My major skills are PHP, Python(Django, Flask), Javascript(React, Angular, Vue), Bootstrap, jQuery and CSS3. most expert in chrome scripts and More

$140 USD in 1 day
(0 Reviews)
0.0
apprabhu24

Hi I've a strong knowledge in MS SQL Server with 10+ year experience. I'm developing software for FMCG and Textile Industry. I've a sales person performance report completed in my software which is similar as your requ More

$200 USD in 5 days
(0 Reviews)
0.0
vilyadd

Hi, Hope you are doing well. I built many SQL queries for web development. So i hope this opportunity because I'm very good at SQL Query. You can see my ability on real state. We can further more if you contact me and More

$50 USD in 1 day
(0 Reviews)
0.0
anamali7886

Hello, I am a Full-Stack developer with over 7+ years of experience in web development (PHP - Laravel, E-Commerce, wordpress and CI, NodeJS, HTML, CSS, React) & I have a good eye to React Native, Flutter. I have worked More

$150 USD in 3 days
(0 Reviews)
0.0