Find the top Value region wise

[Ramu_i]

Hi All,

We have restraints data 

Restraint Table:

Res_Id	Rest_Name	Type	Cuisines
3400299	Farsanwala	['Quick Bites']	North Indian, South Indian, Mithai, Street Food, Desserts
3400005	Murgi and Franky House	['Quick Bites']	North Indian, Mughlai, Rolls, Chinese, Fast Food, Street Food
3401013	Halwai ka khajana	['Quick Bites']	Fast Food, Mithai
3400290	Halwai ka khajana	['Quick Bites']	Desserts, Bakery, Fast Food, South Indian
3401744	Opal Kitchen Cafe and Bar	['Casual Dining']	North Indian, Continental, Italian
3400275	Mams Pizza	['Quick Bites']	Pizza, Fast Food
3400296	Ammus Restaurant	['Quick Bites']	North Indian, Fast Food, Chinese, South Indian
3400368	Mams Pizza	['Quick Bites']	Pizza, Fast Food
3401284	Cream & Company	['Bakery']	Bakery, Fast Food
3400838	Cafe Indian	['Café']	Cafe, Chinese, Continental, Italian, Bakery, Desserts
3400868	Desi Mirchi	['Casual Dining']	Continental, North Indian, Chinese
3400425	Farsanwala	['Casual Dining']	North Indian, South Indian, Mithai, Street Food, Desserts
3400105	Papa Jones Pizzeria	['Casual Dining']	Pizza, Fast Food, Italian
3400457	Yadav Dhaba Purana	['Dhaba']	North Indian
3400282	Maharashtrachi Spice	['Casual Dining']	North Indian, South Indian, Chinese, Bakery, Continental
3400611	Mams Pizza	['Quick Bites']	Pizza, Fast Food
3400017	Spice of Inda	['Casual Dining']	North Indian, Chinese, Mughlai
3400279	Burger House	['Quick Bites']	Burger, Fast Food
3400010	Krishna Sweets and Dining	['Casual Dining']	Desserts, North Indian, South Indian, Chinese, Fast Food, Street Food
3400712	Refresh and Fresh	['Quick Bites']	Fast Food, Wraps, Desserts, Beverages
3400297	Halwai ka khajana	['Quick Bites']	Mithai, Chinese, Fast Food, Street Food, South Indian, Bakery
3400370	Papa Jones Pizzeria	['Casual Dining']	Pizza, Fast Food, Italian

Location Table:

Res_Id , Rest_Name, Region, city 

Factors Table:

Res_Id	Rest_Name	Average_Cost_Two	Price_Range	Aggregate_Rating	Rating_Text	Votes	Photo_Count	Outdoor_Dining	Delivery	Takeaway
3400299	Farsanwala	700	2	4.4	Very Good	814	154	0	0	1
3400005	Murgi and Franky House	600	2	4.4	Very Good	1203	161	0	1	1
3401013	Halwai ka khajana	300	1	4.2	Very Good	801	107	1	1	1
3400290	Halwai ka khajana	300	1	4.3	Very Good	693	157	0	1	1
3401744	Opal Kitchen Cafe and Bar	1000	3	4.9	Excellent	470	291	1	0	0
3400275	Mams Pizza	400	2	4	Very Good	707	62	0	1	1
3400296	Ammus Restaurant	500	2	4.2	Very Good	647	46	0	1	1
3400368	Mams Pizza	400	2	3.8	Good	617	18	0	1	1
3401284	Cream & Company	500	2	3.4	Average	322	14	0	0	1
3400838	Cafe Indian	1000	3	4.4	Very Good	289	324	1	1	1
3400868	Desi Mirchi	1200	3	4.4	Very Good	683	229	0	1	1
3400425	Farsanwala	700	2	4.4	Very Good	523	162	0	1	1
3400105	Papa Jones Pizzeria	700	2	4.1	Very Good	626	99	1	1	1
3400457	Yadav Dhaba Purana	300	1	4.1	Very Good	361	9	0	0	1
3400282	Maharashtrachi Spice	700	2	4.1	Very Good	474	52	0	1	1
3400611	Mams Pizza	400	2	3.5	Good	490	17	0	1	1
3400017	Spice of Inda	1600	4	4.6	Excellent	915	105	0	1	1
3400279	Burger House	500	2	4.3	Very Good	837	45	0	0	1
3400010	Krishna Sweets and Dining	400	2	4.1	Very Good	362	86	1	1	1
3400712	Refresh and Fresh	300	1	4.4	Very Good	490	77	0	1	1
3400297	Halwai ka khajana	250	1	3.9	Good	417	52	0	1	1
3400370	Papa Jones Pizzeria	700	2	3.9	Good	376	54	0	1	1

Using the above three table to find the values

1. region wise top restaurants 

2. Top 5 cities with the highest no. of restaurants

3. Top 5 type of restaurants.

4. Avg. Pricing and Avg. Agg. rating according to the Type of restaurants.

5. No. of other cuisines served by the restaurants with the type and main cuisines showcased.

Thanks advance.

Ram