Write sql query that do some calculations

I need sql query that do the following [login to view URL] certain items from items table. 2..Select certain restaurants from restaurants table. [login to view URL] sum of items quantity from RequisitionDetails table for each restaurant in certain date. [login to view URL] item not existed in selected date or not existed in RequisitionDetails table at all for certain restaurant it should be empty. [login to view URL] 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