Завершено

SQL Statements - Overwork

I have 2 tables which should be interpreted (table export is attached):

A order will be put in table wccrm_orders + in wccrm_prov (there it can be twice, if the sales_person and the account_person are not the same

1) I need to know how many revenue I have made per month (both tables, no duplicates, and only each dress one time)

2) I need to know how many tries (wccrm_anprobe -> uid) per month combined with sales (per month)

3) I need to know how many revenue I have made per year (wccrm_orders, wccrm_prov).

I will attach the file which I have now, but the calculations are not correct. You will see in the results. I have a problem with double entries (if sales_agent and account_agent are not the same) or when a dress is not in wccrm_orders, but in wccrm_prov.

Квалификация: Управление базами данных, Программирование баз данных, MySQL, PHP, SQL

Показать больше sql commands pdf, sql commands cheat sheet, sql commands with examples, types of sql commands, sql commands pdf with examples free download, study of sql commands, database command in sql, sql commands with syntax and examples, vbnet create sql xml insert file, dts sql 2005 csv file, source code export sql data csv file vb6, sql inserting xml file, sql 2005 ssis file exists, help writing sql statements software, guidelines writting sql statements, oracle sql statements, sql statements within certain amount days, site tidy sql statements, execute sql statements perl, discountasp sql server bak file

О работодателе:
( 9 отзыв(-а, -ов) ) Wien, Austria

ID проекта: #19640603

Поручен:

sudesharora0111

Hi, I Would like to work for you on provided data to write sql queries and get the expected results. Requirements are clear and I have reviewed the sql files, it contains table definitions and data. I can pull that on Больше

€80 EUR за 1 день
(15 отзывов(-а))
4.4

30 фрилансеров(-а) в среднем готовы выполнить эту работу за €144

brianconey

Hi there I have read the job description. Now I use Godaddy([login to view URL]) and AWS. I'm a WordPress developer with 7+ years experience I have skills in HTML5 / CSS3, PHP, javaSc Больше

€140 EUR за 1 день
(184 отзывов(-а))
7.0
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. Thank you. Best Regards.

€140 EUR за 7 дней(-я)
(87 отзывов(-а))
6.7
lovethomas1026

Thanks for your post. I have read your project description and I can do what exactly you want. I have rich experienced in php and mysql. Please check my profile. If you choose me, I will satisfy you with good resul Больше

€150 EUR за 3 дней(-я)
(66 отзывов(-а))
6.4
wbslivera

Hello, I am Oracle certified professional and work as oracle techno functional consultant with over 4 years of experience. I am working with complex sql and pl sql functions for last 3 years so I believe I have enough Больше

€50 EUR за 1 день
(124 отзывов(-а))
5.9
alexwmsoft

100% Completion Rate and 5 Stars Hi, there. My name is Lee, and I am an experienced web developer. I read your job description, and I am interested in your project. I have 6+ years of experiences in developing Больше

€155 EUR за 3 дней(-я)
(24 отзывов(-а))
6.0
stead121

Dear Employer. I saw your job description carefully and I am very interested in your project. Your project is the perfect match for my skills and experience. I am very familiar with PHP and Mysql. I have been develo Больше

€120 EUR за 7 дней(-я)
(29 отзывов(-а))
5.7
xinglong717

Hi. I've read carefully your job description I'm have a lot of experiences in JAVA, Visual Basic, C++, VB.NET, SQL SERVER , SQL QUERY, .... And I also have experiences in Excel VBA developing and data mining. If you Больше

€140 EUR за 7 дней(-я)
(56 отзывов(-а))
5.4
wpmonsters

Hello! We are a Russian-Canadian web development company with 10+ years experience and professional developers. We build all kinds of web applications: blogs, eCommerce and even custom solutions. We create thoroughly Больше

€350 EUR за 3 дней(-я)
(21 отзывов(-а))
5.4
honeyocs803

Dear Sir, Before Awarding to Anyone give me a chance & kindly discuss your project in detail with me. I have read your requirement carefully and got total understanding of the project. No fake commitment, 100% quali Больше

€250 EUR за 3 дней(-я)
(13 отзывов(-а))
4.8
PATechnology

Hi, I am interested in the task and have an experience in it. please ping me to discuss more. thanks

€30 EUR за 3 дней(-я)
(33 отзывов(-а))
4.7
fivestar10

Dear Client! Nice to meet you. High Quality, Resonable Budget!! have read your requirements carefully. and interested in your job. I have much experiences with projects like your project. And can complete your work ON Больше

€140 EUR за 7 дней(-я)
(12 отзывов(-а))
4.4
mdramindz

Hello, Please message me so we can discuss on that. Please view the profile to see more works of mine. Let's discuss so I can provide you more details about me. Waiting for Your Reply soon. Regards, Ramin

€199 EUR за 7 дней(-я)
(11 отзывов(-а))
4.6
finaldragon123

Hello! I think your project is best for me and send you a bid. I am a web expert who knows the value of time, working hard and always working on time. My motivation is to make my employer feel the greatest satisfact Больше

€150 EUR за 3 дней(-я)
(13 отзывов(-а))
4.3
marianakuzmich

Hello. I've just read your job carefully. I have enough experience to complete this job successfully. You can see my previous working on my profile and reviews. And I'm ready for you to work until you are 100% satisfie Больше

€100 EUR за 3 дней(-я)
(15 отзывов(-а))
4.5
huseyinaygun

Dear Sir/Madam, I have Oracle database design and development experience of 10 years. I performed the following database related jobs: - Oracle Financials (Oracle EBS) Project - Cognos BI project (MSSQL) - Oracle Tra Больше

€140 EUR за 7 дней(-я)
(5 отзывов(-а))
3.1
Alokumar

Hello, I have 6 Years of experience in website design and development. I can be your help in Resolving this issue . Ping me to discuss this further

€222 EUR за 7 дней(-я)
(4 отзывов(-а))
3.2
bluestar1027

✅Hello, Nice to meet you. If you really want the project to be completed with the best quality in a short time, I suggest that you consider me. I have experience in DBMS(Oracle, MongoDB, Mysql and Sqlite) field. I wi Больше

€150 EUR за 7 дней(-я)
(7 отзывов(-а))
3.5
sergeyprince

Hello. I looked carefully at your posts. i have a history of developing a website with using framework such as Wordpress, Codeigniter, nodejs, angularjs, pure php, html, mysql, ajax, javascript for 6 years and i can Больше

€140 EUR за 1 день
(9 отзывов(-а))
2.6
rathipankaj2005

Hi Hope you are doing well.I have 7yrs of experience on web developement with various assignment completed successfully and looking forward for many more. I have great exposure in php mysql html css javascript jque Больше

€138 EUR за 2 дней(-я)
(4 отзывов(-а))
2.7
prerak121

Hi , Hope you are doing well. I am excited to work on this project.I read a description and i will complete the project in 1 day. I am web developer and having 3 years of experience.  Expert: 1. Wordpress , PHP, C# Больше

€45 EUR за 1 день
(13 отзывов(-а))
2.9