Back to Browse

Data Analysis using SQL | Cloud Kitchen | CTEs & Group BY | Excel to SQL

201 views
Sep 3, 2022
21:11

DB-Fiddle: An online SQL database playground for testing, debugging and sharing SQL snippets. Website Link: https://www.db-fiddle.com/ Index 0:34 - Introduction to Data 1:38 - Questions 1:57 - Introduction to db Fiddle 2:15 - Create table Query 4:24 - Solution to Question 1 (Most popular item?) 5:52 - Solution to Question 2 (Which Partner had the most order?) 6:30 - Solution to Question 3 (Which Brand is the most popular?) 7:01 - Solution to Question 4 (Which kitchen take longest time and shortest time to prepare?) 10:27 - Solution to Question 5 (How much time does the most popular item take to prepare in different kitchen location?) 16:35 - Solution to Question 6 (How many orders were prepared below and above the average preparation time?) 19:07 - Solution to Question 7 (Distribution of final bill by brand) How can DB-Fiddle help you? • Create sample datasets and query them • Share the scenario and queries with others * The information on the videos and the resources available for download/viewing through this YouTube Channel are for educational and informational purposes only.​

Download

0 formats

No download links available.

Data Analysis using SQL | Cloud Kitchen | CTEs & Group BY | Excel to SQL | NatokHD