Cancelled

Write sql query that do some calculations

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]

Skills: Microsoft SQL Server, SQL

See more: tree query sql, sql write query, dnn query sql, php html query sql, vbs sql write, parent child query sql, query sql 2005 csv

About the Employer:
( 5 reviews ) Doha, Qatar

Project ID: #11737902

Awarded to:

bhaveshghodasara

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

$20 USD in 1 day
(1 Review)
0.7

21 freelancers are bidding on average $28 for this job

manhpham

My name is Manh from Vietnam. I read your project details and I am sure I can complete your project.Can we can chat/discuss further on your project?

$45 USD in 1 day
(36 Reviews)
5.4
angnut

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

$30 USD in 1 day
(11 Reviews)
3.2
thampl

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

$27 USD in 1 day
(2 Reviews)
3.3
dekinghtg

A proposal has not yet been provided

$30 USD in 1 day
(5 Reviews)
3.4
mehulprajapati91

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

$30 USD in 0 days
(5 Reviews)
2.9
rambanstola

available for new project

$30 USD in 2 days
(1 Review)
1.8
DemonDeveloper

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

$30 USD in 1 day
(3 Reviews)
1.4
utkarshkatiyar19

A proposal has not yet been provided

$60 USD in 2 days
(1 Review)
1.2
saedabaid

Dear sir ,I read your proposal well. Please make sure i will exceed your expectation , thanks .. I’d happy to provide you some samples that you can review those before making hiring decision. http://www.eureeca. More

$45 USD in 1 day
(1 Review)
0.8
chetanghadiya007

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

$25 USD in 1 day
(0 Reviews)
0.0
diwakarm801

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

$20 USD in 1 day
(0 Reviews)
0.0
w3esolution

I can assure 100% satisfaction in this project , please come on chat to discuss more .. Ready to start the work now..

$25 USD in 1 day
(0 Reviews)
0.0
$15 USD in 1 day
(0 Reviews)
0.0
arradhakrishnan

Expert in stored procedure, TSQL, functions and db/table design.

$25 USD in 1 day
(0 Reviews)
0.0
ravirich20

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.

$25 USD in 1 day
(0 Reviews)
0.0
sdsubha8

I am a Software Engineer.I have experience on it.If you will give me a chance to prove myself , we will discuss further.

$20 USD in 1 day
(0 Reviews)
0.0
vishnu20sankar

Hi,being a data analyst I have strong grasp on SQL queries.You can trust me with your job without shelling out too much money

$10 USD in 1 day
(0 Reviews)
0.0
wasifmuneer

Hello, Please give me chance to work with you on this project, I am Microsoft Full Stack developer, having expertise on web based and desktop base application development, including mobile apps as well using Xamarin, More

$23 USD in 1 day
(0 Reviews)
0.0
logodesigingpk

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!!!

$30 USD in 1 day
(0 Reviews)
0.0
rikred

proficient in sql, i am regularly exposed to datasets in excess of 1 million records, your query will be efficient and accurate.

$20 USD in 1 day
(0 Reviews)
0.0