DataBase Query to verify quantitys

$10-30 USD

完了済み

投稿日:

約7年前

$10-30 USD

完了時にお支払い

hello , i am looking to fix a query to verify some stock accounts those 4 to 5 tables some sums to check if the stock is right must compare the current stock vrs the sum of initial+adjuments stock and if is wrong update with the right value. SELECT [login to view URL],[login to view URL] as cantidadInv,sum([login to view URL]) as compraSt , sum([login to view URL]) as vendido, SUM(IF([login to view URL] = 'addition', [login to view URL], 0))-SUM(IF([login to view URL] = 'subtraction', [login to view URL], 0))+sum([login to view URL]) as ajustes FROM `sma_purchase_items` compra inner join sma_products productos on [login to view URL] = compra.product_id left join sma_sale_items vendidos on [login to view URL] = vendidos.product_id left join sma_adjustment_items ajustes on vendidos.product_id = ajustes.product_id group by [login to view URL] this is mostly the query must be fixed due in some rows shows another information. if need i can share the db and explain via teamviewer or similar

Database Administration

Database Development

Database Programming

MySQL

プロジェクト ID: 13120054

プロジェクトについて

19個の提案

リモートプロジェクト

アクティブ 7年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@moeenahmed21

I am an experienced database developer and administrator. I will create query and solve your problem. Feel free to contact me for further discussion. Regards, Moeen Ahmed

$30 USD 1日以内

5.0

(8 レビュー)

3.3

この仕事に19人のフリーランサーが、平均$30 USDで入札しています

@nojnish

Hi, I can help you with the task as I have 15+ years experience and 5 years in MySQL. can you share what additional info you are getting for the query shared as it would help resolve the problem otherwise I can provide another query meeting your objective of comparing available stock with calculated stock based on purchases/sales/adjustments regards Babu

$22 USD 1日以内

5.0

(2 レビュー)

3.5

@celalaybar

Hello. Thank you very much for taking time to read my proposal. I can help you. I am a fulltime freelancer. You can check my portfolio and reviews. We can discuss further details. Hopefully, both of us will be happy after the job is done. Best Regards.

$29 USD 1日以内

5.0

(4 レビュー)

2.3

@swarm22

I am database developer , query writing and optimizing with mysql , oracle . I will able to do this task. Could you let me know , when could we arrange meeting regarding project

$30 USD 1日以内

4.1

(13 レビュー)

2.8

@AppsUNeed

This looks reasonably simple to carry out. I would probably simplify this by creating a view in your database that will do all of the aggregation so that you don't need the long string of LEFT JOINs but will confirm when I have seen your database.

$25 USD 1日以内

0.0

(0 レビュー)

0.0

@kunjmishra

Dear Client, With 6 years of experience in database (sql) and looking at the sample query provided it seems doable. Looking forward to hear from you. Regards, Kunj.

$15 USD 1日以内

0.0

(0 レビュー)

0.0

@im146

hi, I have experience in developing complex queries and I am interested in this task please ping me so we can discuss it further and can start the work thanks

$45 USD 1日以内

0.0

(0 レビュー)

0.0

@delphijdeveloper

I graduated from the department of Mathematics and specialized in Computer applications. I have been writing financial and business applications on Delphi and Mysql languages since last 20 years for small and big companies. I am always searching for new solutions. Furthermore one of my key strengths is Oracle. I can do every type of job at resonable prices. I am eagerly waiting for offers. *** 15+ years experience in SQL (Oracle, Mysql, Firebird...)

$45 USD 2日以内

0.0

(0 レビュー)

0.0

@aap31374

I have 10+ years database development experience in sql server, Mysql and Postgres. I have also worked in SSIS and SSRS. I assure that i will give you fully satisfaction about this assignment.

$25 USD 1日以内