Færdiggjort

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.

Evner: Database Administration, Programmering af database, MySQL, PHP, SQL

Se mere: 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

Om arbejdsgiveren:
( 9 bedømmelser ) Wien, Austria

Projekt ID: #19640603

Tildelt til:

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 Flere

€80 EUR på 1 dag
(15 bedømmelser)
4.4

30 freelancere byder i gennemsnit €144 på dette job

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 Flere

€140 EUR på 1 dag
(184 bedømmelser)
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 in 7 dage
(87 bedømmelser)
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 Flere

€150 EUR in 3 dage
(66 bedømmelser)
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 Flere

€50 EUR på 1 dag
(124 bedømmelser)
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 Flere

€155 EUR in 3 dage
(24 bedømmelser)
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 Flere

€120 EUR in 7 dage
(29 bedømmelser)
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 Flere

€140 EUR in 7 dage
(56 bedømmelser)
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 Flere

€350 EUR in 3 dage
(21 bedømmelser)
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 Flere

€250 EUR in 3 dage
(13 bedømmelser)
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 in 3 dage
(33 bedømmelser)
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 Flere

€140 EUR in 7 dage
(12 bedømmelser)
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 in 7 dage
(11 bedømmelser)
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 Flere

€150 EUR in 3 dage
(13 bedømmelser)
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 Flere

€100 EUR in 3 dage
(15 bedømmelser)
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 Flere

€140 EUR in 7 dage
(5 bedømmelser)
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 in 7 dage
(4 bedømmelser)
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 Flere

€150 EUR in 7 dage
(7 bedømmelser)
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 Flere

€140 EUR på 1 dag
(9 bedømmelser)
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 Flere

€138 EUR in 2 dage
(4 bedømmelser)
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# Flere

€45 EUR på 1 dag
(13 bedømmelser)
2.9