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天之内