Restaurant Insights: SQL-Driven Analysis & ML Rating Prediction on Zomato NCR Data
1,063 restaurants
New Delhi leads with 1,192
SELECT cuisine_name, COUNT(*) as restaurant_count FROM Cuisines...
SELECT city, COUNT(*), AVG(rating) FROM Restaurants GROUP BY city...
SELECT CASE WHEN rating BETWEEN 4.0 AND 4.4 THEN 'Good'...
SELECT pricing_for_2, AVG(rating) FROM Restaurants GROUP BY...
Restaurant distribution by pricing tiers
Highest rated restaurant areas
Normalized table structure
SELECT c.cuisine_name, COUNT(*) as restaurant_count, AVG(r.dining_rating) as avg_rating, AVG(r.pricing_for_2) as avg_cost FROM Cuisines c JOIN Restaurant_Cuisines rc...
| Cuisine Type | Restaurant Count | Avg Rating | Market Share | Avg Cost | Performance |
|---|---|---|---|---|---|
| North Indian | 1,063 | 4.1 | 54.1% | ₹850 | Good |
| Chinese | 775 | 4.1 | 39.4% | ₹720 | Good |
| Beverages | 726 | 4.2 | 37% | ₹450 | Excellent |
| Fast Food | 605 | 4.1 | 30.8% | ₹450 | Good |
| Desserts | 425 | 4.2 | 21.6% | ₹380 | Excellent |
| Italian | 407 | 4.2 | 20.7% | ₹1350 | Excellent |
| Continental | 398 | 4.2 | 20.3% | ₹1200 | Excellent |
| Mughlai | 370 | 4.1 | 18.8% | ₹950 | Good |