Today I'm doing a mock SQL interview with Jitesh, a data engineering coach on Interview Query, with 10 years of experience in data engineering and analytics at companies like Databricks and Amazon.
Here's the question we're tackling: https://www.interviewquery.com/questions/conversations-distribution
Want to be featured in the next mock interview video? Apply here: https://airtable.com/shrdQrwKK7xxGLm6l
👉 Subscribe to my data science channel: https://bit.ly/2xYkyUM
Use the code "datasciencejay" and get 10% off data science interview prep 🔥 : https://www.interviewquery.com/pricing?via=jay
❓ Check out our new SQL interview course: https://www.interviewquery.com/learning-paths/sql-interview
🔑 Get professional coaching from Jitesh here: https://www.interviewquery.com/coaching?utm_source=youtube&utm_medium=social
🐦 Follow us on Twitter: https://twitter.com/interview_query
Chapters:
1:15 - What's the distribution look like for all conversations?
3:00 - Write a query to get the distribution
4:34 - Calculating the frequency
More from Jay:
Read my personal blog: https://datastream.substack.com/
Follow me on LinkedIn: https://www.linkedin.com/in/jay-feng-ab66b049/
