DataBase Query to verify quantitys

$10-30 USD

Completed

Posted

about 7 years ago

$10-30 USD

Paid on delivery

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

Project ID: 13120054

About the project

19 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

5.0

(8 reviews)

3.3

19 freelancers are bidding on average $30 USD for this job

@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 in 1 day

5.0

(2 reviews)

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 in 1 day

5.0

(4 reviews)

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 in 1 day

4.1

(13 reviews)

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 in 1 day

0.0

(0 reviews)

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 in 1 day

0.0

(0 reviews)

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 in 1 day

0.0

(0 reviews)

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 in 2 days

0.0

(0 reviews)

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 in 1 day