```json { "queries": [ { "query": "SELECT \"City\", COUNT(*) AS restaurant_count FROM \"Zomato Restaurant Dataset\" GROUP BY \"City\" ORDER BY restaurant_count DESC LIMIT 10", "description": "Top 10 cities by number of restaurants in the dataset." }, { "query": "SELECT \"Restaurant Name\", \"City\", \"Aggregate rating\", \"Votes\" FROM \"Zomato Restaurant Dataset\" WHERE \"Aggregate rating\" IS NOT NULL ORDER BY \"Aggregate rating\" DESC, \"Votes\" DESC LIMIT 15", "description": "Highest-rated restaurants with their cities and vote counts." }, { "query": "SELECT \"Cuisines\", COUNT(*) AS count, AVG(\"Aggregate rating\") AS avg_rating FROM \"Zomato Restaurant Dataset\" WHERE \"Cuisines\" IS NOT NULL GROUP BY \"Cuisines\" ORDER BY count DESC LIMIT 10", "description": "Most popular cuisine types with their average ratings." }, { "query": "SELECT \"City\", AVG(\"Average Cost for two\") AS avg_cost FROM \"Zomato Restaurant Dataset\" WHERE \"Average Cost for two\" IS NOT NULL AND \"Currency\" = 'Indian Rupees(Rs.)' GROUP BY \"City\" ORDER BY avg_cost DESC LIMIT 10", "description": "Cities with highest average dining costs for two people in Indian Rupees." }, { "query": "SELECT \"Has Online delivery\", COUNT(*) AS count, AVG(\"Aggregate rating\") AS avg_rating FROM \"Zomato Restaurant Dataset\" GROUP BY \"Has Online delivery\"", "description": "Comparison of restaurant counts and ratings by online delivery availability." }, { "query": "SELECT \"Price range\", COUNT(*) AS restaurants, AVG(\"Aggregate rating\") AS avg_rating FROM \"Zomato Restaurant Dataset\" WHERE \"Price range\" IS NOT NULL GROUP BY \"Price range\" ORDER BY \"Price range\"", "description": "Restaurant distribution and average ratings across different price ranges." }, { "query": "SELECT \"Restaurant Name\", \"Locality\", \"Votes\", \"Aggregate rating\" FROM \"Zomato Restaurant Dataset\" WHERE \"City\" = 'New Delhi' AND \"Votes\" IS NOT NULL ORDER BY \"Votes\" DESC LIMIT 15", "description": "Most reviewed restaurants in New Delhi by vote count." }, { "query": "SELECT \"Rating text\", COUNT(*) AS count FROM \"Zomato Restaurant Dataset\" WHERE \"Rating text\" IS NOT NULL GROUP BY \"Rating text\" ORDER BY count DESC", "description": "Distribution of restaurants by rating categories." }, { "query": "SELECT \"Locality\", COUNT(*) AS restaurant_count, AVG(\"Aggregate rating\") AS avg_rating FROM \"Zomato Restaurant Dataset\" WHERE \"City\" = 'Gurgaon' GROUP BY \"Locality\" ORDER BY restaurant_count DESC LIMIT 10", "description": "Top localities in Gurgaon by restaurant density and average rating." }, { "query": "SELECT \"Has Table booking\", \"Has Online delivery\", COUNT(*) AS count FROM \"Zomato Restaurant Dataset\" GROUP BY \"Has Table booking\", \"Has Online delivery\" ORDER BY count DESC", "description": "Restaurant counts by combinations of table booking and online delivery features." } ] } ```