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.

Skills: Database Administration, Database Programming, MySQL, PHP, SQL

See more: 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

About the Employer:
( 9 reviews ) Wien, Austria

Project ID: #19640603

Awarded to:


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 More

€80 EUR in 1 day
(15 Reviews)

30 freelancers are bidding on average €144 for this job


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 More

€140 EUR in 1 day
(184 Reviews)

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 in 7 days
(87 Reviews)

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 More

€150 EUR in 3 days
(66 Reviews)

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 More

€50 EUR in 1 day
(124 Reviews)

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 More

€155 EUR in 3 days
(24 Reviews)

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 More

€120 EUR in 7 days
(29 Reviews)

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 More

€140 EUR in 7 days
(56 Reviews)

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 More

€350 EUR in 3 days
(21 Reviews)

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 More

€250 EUR in 3 days
(13 Reviews)

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

€30 EUR in 3 days
(33 Reviews)

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 More

€140 EUR in 7 days
(12 Reviews)

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 in 7 days
(11 Reviews)

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 More

€150 EUR in 3 days
(13 Reviews)

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 More

€100 EUR in 3 days
(15 Reviews)

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 More

€140 EUR in 7 days
(5 Reviews)

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 in 7 days
(4 Reviews)

✅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 More

€150 EUR in 7 days
(7 Reviews)

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 More

€140 EUR in 1 day
(9 Reviews)

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 More

€138 EUR in 2 days
(4 Reviews)

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# More

€45 EUR in 1 day
(13 Reviews)