Order id Order Date Cust ID Address

Room No. 322,

202308241001 43831 APS20231 Uttam Nagar - Delhi-110005
Seva Bhawan,
202308241002 43832 APS20232 Houz
RoomKhas-New Delhi-110016
No. 345,Shri Sakti Bhawan
202308241003 43833 APS20233 -Delhi-110014
Narnada Sadan,
202308241004 43836 APS20234 Sector
D Block,B-Delhi-Indore-452010
Flat 126,
202308241005 43837 APS20235 AD Bridge-Bengaluru-560048
202308241007 43839 APS20238 E/6F,
MayorMaruthi,
Road, Street No. 3-Hyderabad-500039
202308241008 43840 APS20239 KCM School-Chennai-600001
202308241009 43841 APS20240 Uttam Nagar-Delhi-110005
Room No. 3,Shri Sakti Bhawan
202308241010 43842 APS20242 -Delhi-110014
B Block, Flat 16,
Room No. 322,
202308241011 43843 APS20243 AD Bridge-Bengaluru-560048
Seva Bhawan,
202308241012 43844 APS20244 Houz
RoomKhas-New Delhi-110016
No. 345,Shri Sakti Bhawan
202308241013 43845 APS20245 -Delhi-110014
Room No. 3,Shri Sakti Bhawan
202308241014 43842 APS20242 -Delhi-110015
B Block, Flat 16,
202308241014 43843 APS20243 AD Bridge-Bengaluru-560049
202308241015
Region Cust Name Category Product Price Qty Amount
East Rakesh Maheta Computer Mouse 210 45 9450 3
West sonu sharma Electronics Monitor 4000 3 12000 5
North ANIL KUMAR Art Printer 3200 5 16000 5
ROHIT Storage SSD 256 GB NA 1 #VALUE! 5
Tinku Singh Mobiles HDD 256 GB 1500 3 4500 5
East raksingh Computer Monitor 4000 4 16000 5
West suresh Computer Printer 3200 1 3200 5
North NEELAM Computer Scanner NA 5 #VALUE! 5
West Sunita kumari Computer Keyboard 190 1 190 2
vijay singh Computer SSD 256 GB 4000 6 24000 2
South amandeep Computer HDD 256 GB NA 6 #VALUE! 5
harvinder Computer Mouse 210 6 1260 5
West Sunita kumari Computer Keyboard 7810 7.75 60527.5 3
vijay singh Computer SSD 256 GB 11620 8.75 101675 3
9.75 3
Order id Customer Rating Delivery Status Payment Mode Shipping Cost Delivery Date
Order id 4 Returned Credit Card 150 25/5/2020
202308241007.00 2 Delivered Debit Card 229 24/10/2020
202308241009.00 2 Returned Cash 476 27/3/2020
202308241012.00 3 Pending Cash 99 21/3/2020
202308241004.00 5 Returned UPI 384 11/4/2020
202308241015.00 2 Pending Debit Card 496 4/1/2020
N/A 4 Returned Debit Card 477 17/7/2020
N/A 2 Pending Credit Card 107 11/8/2020
202308241001.00 3 Returned Cash 209 17/8/2020
202308241008.00 2 Returned UPI 112 20/3/2020
202308241002.00 5 Pending Cash 339 20/9/2020
N/A 2 Delivered Credit Card 427 11/3/2020
N/A 1 Returned Debit Card 335 29/12/2020
202308241010.00 2 Pending UPI 262 19/10/2020
202308241011.00 2 Pending UPI 392 16/10/2020
N/A 5 Pending UPI 431 12/12/2020
202308241003.00 5 Delivered UPI 302 19/7/2020
202308241013.00 5 Delivered UPI 314 28/6/2020
202308241013.60 3 Pending Debit Card 105 23/7/2020
202308241014.30 4 Pending Debit Card 293 27/4/2020
202308241005.00 3 Delivered UPI 261 1/2/2020
 Please answer questions below for data analysis

1 What is the average Customer Rating for orders in each city

2 Whatmany
How is the orders
average Customer
have Rating forversus
been 'Delivered' orders'Pending'
in each region
or 'Returned'
3 for each 'Category' of products?
What is the total Amount spent on Delivered orders versus 'Returned'
4 orders?
Which 'Payment Mode' is most commonly used for orders in each
5 'Region'?
6 What is the average 'Shipping Cost' for each 'Product Category'?