Write sql query that do some calculations

Completed Posted 7 years ago Paid on delivery
Completed 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

Microsoft SQL Server SQL

Project ID: #11737902

About the project

21 proposals Remote project Active 7 years ago

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

dekinghtg

A proposal has not yet been provided

$30 USD in 1 day
(5 Reviews)
3.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
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
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
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
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
arradhakrishnan

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

$25 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
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
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