Zomato Most Asked SQL Interview Questions Experience : CTC - 25LPA

1/ How would you analyze a dataset with missing values?
2/ Can you explain the difference between inner join and left join in SQL?
3/ How do you approach data cleaning in a dataset?
4/ What is the difference between UNION and UNION ALL in SQL?
5/ How would you calculate the mean, median, and mode for a given dataset?
6/ Explain a time when you used data visualization to communicate insights effectively.
7/ How do you handle outliers in a dataset?
8/ Describe the differences between supervised and unsupervised learning.
9/ What is A/B testing, and how would you set it up in a real-world scenario?
10/ How would you approach building a recommendation system?
11/ Explain the concept of time series analysis and its applications.
12/ What is normalization in databases, and why is it important?
13/ How do you decide on the appropriate statistical test for a given dataset?
14/ How would you calculate and interpret correlation between two variables?
15/ What is the difference between a primary key and a foreign key in a relational database?
16/ Can you explain the concept of pivot tables in Excel?
17/ Describe a scenario where you had to clean and merge large datasets. How did you approach it?
18/ How would you determine if a dataset is biased?
19/ What methods would you use to assess the quality of a dataset?
20/ How would you use SQL to find the top 10 highest-grossing products in a sales database?

These questions cover a variety of advanced SQL concepts such as window functions, self-joins, aggregations, string operations, date/time handling, and recursive queries.

Remember these questions are just a part to help you for a quick revision.

But if you are aiming for top companies, you need indepth preparation of these topics. Only touching the surface won't help you.