Calculating ratios is one of the most frequently asked SQL questions in data science interviews. In this video, I’ll go over the two most common ways to compute a ratio, and feature two examples to demonstrate solving the problems in real-time: how to calculate the premium subscription rate, and the immediate order from customers’ order data.

🟢Get all my free data science interview resources
https://www.emmading.com/get-all-my-f...
🟡 Product Case Interview Cheatsheet https://www.emmading.com/product-case...
🟠 Statistics Interview Cheatsheet https://www.emmading.com/statistics-i...
🟣 Behavioral Interview Cheatsheet https://www.emmading.com/behavioral-i...
🔵 Data Science Resume Checklist https://www.emmading.com/data-science...

✅ We work with Experienced Data Scientists to help them land their next dream jobs. Apply now: https://www.emmading.com/coaching

// Comment
Got any questions? Something to add?
Write a comment below to chat.

// Let's connect on LinkedIn:
  / emmading001  

====================
Contents of this video:
====================
00:00 Introduction
00:38 Ratios
01:10 Calculating Ratios
01:39 Two Methods
02:07 Example: Subscription Rate
05:00 Example: Immediate Order
08:58 Outro