sql

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

sql

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

sql

Complex SQL Query Breakdown Step By Step

<https://www.youtube.com/watch?v=f1vuGPuug9s&ab_channel=DatabaseStar> 03:02 use the FROM clause to understand tables in the query 04:60 LEFT JOIN (only join items into the union from the left table) uses a subquery where we can SELECT inside and the JOIN