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.

Taidot: Tietokannan hallinto, Tietokantaohjelmointi, MySQL, PHP, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 9 arvostelua ) Wien, Austria

Projektin tunnus: #19640603

Myönnetty käyttäjälle:


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 Lisää

€80 EUR 1 päivässä
(15 Arvostelua)

30 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

€140 EUR 1 päivässä
(184 arvostelua)

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 päivässä
(87 arvostelua)

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 Lisää

€150 EUR 3 päivässä
(66 arvostelua)

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 Lisää

€50 EUR 1 päivässä
(124 arvostelua)

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 Lisää

€155 EUR 3 päivässä
(24 arvostelua)

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 Lisää

€120 EUR 7 päivässä
(29 arvostelua)

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 Lisää

€140 EUR 7 päivässä
(56 arvostelua)

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 Lisää

€350 EUR 3 päivässä
(21 arvostelua)

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 Lisää

€250 EUR 3 päivässä
(13 arvostelua)

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

€30 EUR 3 päivässä
(33 arvostelua)

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 Lisää

€140 EUR 7 päivässä
(12 arvostelua)

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 päivässä
(11 arvostelua)

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 Lisää

€150 EUR 3 päivässä
(13 arvostelua)

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 Lisää

€100 EUR 3 päivässä
(15 arvostelua)

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 Lisää

€140 EUR 7 päivässä
(5 arvostelua)

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 päivässä
(4 arvostelua)

✅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 Lisää

€150 EUR 7 päivässä
(7 arvostelua)

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 Lisää

€140 EUR 1 päivässä
(9 arvostelua)

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 Lisää

€138 EUR 2 päivässä
(4 arvostelua)

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# Lisää

€45 EUR 1 päivässä
(13 arvostelua)