sql
Real Data Science SQL Interview Questions and Answers # 1 | Data Science Interview Questions - YouTube
https://www.youtube.com/watch?v=Td-cmLfQ7uU&ab_channel=TinaHuang 01:40 building a potential and reasonable schema 02:28 -- is a comment in SQL 03:06 FROM -> JOIN -> ON … AND 04:21 line 13: build a function by using SELECT 04:34 COUNT (DISTINCT …) 1. joining
Solving a LinkedIn Data Science SQL Interview Question
https://www.youtube.com/watch?v=d2920ysu2hQ&ab_channel=JayFeng 01:37 peepoThink (1) * we could use GROUP BY to see how many posting share the same uid * we could then SELECT WHERE count == 1 (2) * use DATE_TRUNC to group by year or * use WHERE to split each into