Write sql query that do some calculations
$10-30 USD
Paid on delivery
I need sql query that do the following
[url removed, login to view] certain items from items table.
2..Select certain restaurants from restaurants table.
[url removed, login to view] sum of items quantity from RequisitionDetails table for each restaurant in certain date.
[url removed, login to view] item not existed in selected date or not existed in RequisitionDetails table at all for certain restaurant it should be empty.
[url removed, login to view] the total
data base backup and script are included in the attachment.
out put should be like this
Cod ItemName Unit res1 res 2 res3 Total
1 item1 kg 4.00 5.00 3.00 12.00
2 item2 kg 2.00 Null 1.00 3.00
Project ID: #11737902
About the project
Awarded to:
Looks easy and straight forward, is is possible for you to give sample data in some other format then db? I just need tablename and columnnames of each table. I can do it in 3-4 hours only. You can check my past More
21 freelancers are bidding on average $28 for this job
HI, I can do your sql task today. I will delivery it in my afternoon (Rome Time). Please contact me if it is ok for you. Have a nice day. Angelo
Hi there, I'm Tom and I can write SQL for you. I can start with job today and it will be done today. Regards, Tom
I can start working right now.I can start working right now.I can start working right now.I can start working right now. Thanks,MEHUL
We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for project More
Hi, I am chetanghadiya007 from Rajkot,Gujarat,India. i'm developers and designer with around 6 years of experience. Completely passionate and self dependent. I believe in delivery with a quality. i'm developers an More
Hello Sir, I am a php developer and able to create such query and fetch data from your database on the following condition. i am working in IT Field from last 4 years. thanks!!!
I have a candidate who is having 6+ years of SQL Database experience and he is currently working in MNC. So we can complete your work with quality and within timeframe.
I can assure 100% satisfaction in this project , please come on chat to discuss more .. Ready to start the work now..
Hi I have been working in Asp.Net, MVC, Angularjs, Web Services, WCF , SQL Server since last 4 years.I am confident that i can finish your task in a jiffy. it's have a detail discussion. Looking forward to make a More
proficient in sql, i am regularly exposed to datasets in excess of 1 million records, your query will be efficient and accurate.