Skip to content

sql

Members Public

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

Members Public

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

Members Public

Complex SQL Query Breakdown Step By Step

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 it on a field to the computed table 08:50 any filters? HAVING