SQL Interview Question || Easy level ||Most Popular Restaurant || Data Analyst || ZOMATO Interview

Welcome to Data_Ki_Duniya
I'm a passionate Data Analyst with expertise in SQL, Python, Power BI, and everything data analytics. My channel is dedicated to helping aspiring analysts and professionals excel in their data-driven careers .

What You'll Learn Here:
Dive into practical tutorials, real-world interview questions, and hands-on projects in SQL, Python, Power BI, and more. Whether you're preparing for top company interviews or enhancing your skills, this channel has something for you.

Who This Channel is For:
If you're a beginner starting your data analytics journey or an experienced professional looking to sharpen your skills, you've come to the right place.

Subscribe and Grow With Me:
Join our community of data enthusiasts and level up your analytics game. Don’t forget to like, comment, and share your thoughts to keep learning together!


==========================================================
CREATE TABLE restaurants (
restaurant_id INT PRIMARY KEY,
restaurant_name VARCHAR(100)
);

CREATE TABLE orders (
order_id INT PRIMARY KEY,
restaurant_id INT,
order_date DATE,
FOREIGN KEY (restaurant_id) REFERENCES restaurants(restaurant_id)
);
INSERT INTO restaurants (restaurant_id, restaurant_name)
VALUES
(1, 'Spice Delight'),
(2, 'Burger Hub'),
(3, 'Pasta Palace'),
(4, 'Taco Fiesta');
INSERT INTO orders (order_id, restaurant_id, order_date)
VALUES
(1, 1, '2024-10-01'),
(2, 2, '2024-10-02'),
(3, 1, '2024-10-03'),
(4, 3, '2024-10-03'),
(5, 1, '2024-10-04'),
(6, 4, '2024-10-04'),
(7, 2, '2024-10-05'),
(8, 3, '2024-10-05'),
(9, 1, '2024-10-05');

My Linkedin : / pratik-jugant-mohapatra-
My Portfolio : https://linktr.ee/pratikjugant

Share this video with all the people who are preparing for SQL interviews


#DataAnalytics #DataScience #BigData #DataDriven #BusinessIntelligence #PowerBI #SQL #Tableau #ExcelTips #DataVisualization #PythonForDataScience #PredictiveAnalytics #MachineLearning #DeepLearning #DataEngineering #ETL #DataPreparation #Analytics #DataInsights #DataStorytelling #DataMining #Statistics #DataAutomation #VisualizationTools #KPIs #PowerQuery #DataPipeline #GoogleAnalytics #AdvancedAnalytics #DecisionMaking #InsightDriven #ExploratoryDataAnalysis #DataCompetency #DataTransformation #AIAnalytics #DataInnovation #DataCulture #DataFuture #DataSolutions #DataScienceCommunity #DataOperations #BusinessAnalytics #InsightDriven #DataStrategy #DataPipeline #DataArchitecture #DataScientistLife #AnalyticsLife #DataWrangling