Write sql query that do some calculations

Budget $10 - $30 USD
Bids 21
Average Bid $28
Status Closed

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 [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view]

2 item2 kg [url removed, login to view] Null [url removed, login to view] [url removed, login to view]

Get Free Quotes For A Project Like This

This project was awarded to


6 stars! He understands the requirements very clearly and gave me the perfect result straight forward. While other freelancers trying to take time. bhaveshghodasara is a good English speaker so that there was no problem to communicate. I will definitely hire him again if I need more services that also he provides.
About the Freelancer
bhaveshghodasara Profile Picture

Expert web-scrapper, database designer and excel programmer.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • rikred Profile Picture


    United Kingdom

    Experienced and professional with a passion for all things data. sql, Oracle, vba, ssis, abap, excel

  • diwakarm801 Profile Picture


    kolkata,  India

    I am an experienced C#.net developer, focused on pragmatic solutions, with a passion for identifying and implementing the right pattern and approach for each task. I've been developing software targeting wide variety of domains, ranging from building cross browser compatible websites, to ‘n’ tier multi-threaded enterprise applications, with increasing use of design patterns, pair programming and test driven development techniques. Currently developing software using cutting edge technologies like bootstrap, Jquery, angular.js, etc. My Motive is to make my employer happy without adding additional charges. I have developed a lot of Desktop applications and web development too.

  • thampl Profile Picture


    Zg,  Croatia

    - Database SQL Expert - Microsoft SQL Server (ver. 2000/2005/2008/2012/2014) - Stored procedure, view, triggers, function - Data manipulation - Data migration - Data import / export

  • dekinghtg Profile Picture


    Jakarta,  Indonesia

    i am an expert of vb, c#, .net, asp.net, Java, j2ee, oracle, mssql, mysql, postgresql, Javascript, HTML

  • bhaveshghodasara Profile Picture


    ahmedabad,  India

    Expert web-scrapper, database designer and excel programmer.

  • utkarshkatiyar19 Profile Picture


    kanpur,  India

    Hi, I have good knowledge of C/C++/Java/Python programming on Linux, Windows and Mac OS. I have knowledge about Mathematics , and any Computer related concept such as Algorithms, Data Structures, Networking, Cryptography, Databases, Operating Systems , Compilers, Data Mining etc. I also have experience related to web. Feel free to discuss your project with me in these domains or any other relevant domain. I ensure 24*7 Support.

  • w3esolution Profile Picture


    Noida,  India

    WEB DEVELOPER I am a freelancer web developer having experience of more than 7+ year on great expertise in Core PHP, Wordpress ,Laravel, Cake PHP, Javascript, Jquery,Ajax, Mysql, HTML5,CSS, Webservices, Linux, Apache, 3rd party API’s like Payment Gateways(Moneybookers,Paypal,Endeavour etc),SMS,API, Facebook ,Twitter, Gmap etc. In linux os- LAMP server installation, ssl configuration, virtual hosting of websites on server, monitoring etc. Looking forward to hear from you.

  • angnut Profile Picture


    S. Cipriano Picentino (SA),  Italy

    I am a passionate programmer and software architect with over 14 years of experience in design and development client/server, web based and n-tier application, using Microsoft .NET and SQL Server. I have good technical and analytical experience and problem solving skill. I have managed international projects in healthcare domain. Over the years I have led teams of developers and leading the production process of framework and business solution. I received the B.S. degree in Computer Science from the University of Salerno. More info: https://it.linkedin.com/in/angnut

  • arradhakrishnan Profile Picture
  • rambanstola Profile Picture


    Espoo,  Finland

    Thank you for making an effort to visit my profile. My core skills are listed below. Contact me for fast and reliable wordpress websites. ★ Languages ★ Databases ✔ php ✔ mysql ✔ JavaScript, HTML5, CSS3 ✔ postgres ✔ Java ✔ mssql ✔ Python ✔ mongodb ✔ Bash Scripts ✔ jQuery ★ Server ✔ Linux ✔ Apache ✔ node ★ API : REST API ★ SOAP Client and Server Implementation ★ Data feed data extraction ✔ JSON , XML , CSV ★ API's ✔ google API ✔ facebook ✔ Twilio SMS integration ★ CMS ✔ Wordpress ★ Affordable online store creation using OScommerce framework for small businesses ★ HTML5 newsletter design