25 lines (20 loc) · 815 Bytes

Zomato Sales Data Analysis — SQL

Overview

SQL-based analysis of 5,000+ food delivery orders to identify top restaurants, high-value customers, and revenue trends.

Problem Statement

Food delivery platforms need data-driven insights on customer ordering behavior, restaurant performance, and revenue distribution.

Tools Used

MySQL (CTEs, Window Functions, Joins, Aggregations, Subqueries)
Query optimization for faster data retrieval

Key Findings

Identified top-performing restaurants by revenue and order count
Ranked high-value customers using window functions
Analyzed ordering behavior and revenue trends across cities

Key SQL Concepts Used

Common Table Expressions (CTEs)
RANK(), DENSE_RANK(), ROW_NUMBER()
GROUP BY with HAVING
Multi-table JOINs
Correlated subqueries