Complex Datasets with SQL (Data Scientist Mock Interview)

Ace your SQL interviews with our complete course: https://bit.ly/3PnLhzg

An Adobe data scientist pulls customer and transaction data at an e-commerce company, covering window functions, aggregations, and indexing.

0:00 - Intro
0:42 - Query reports users, transactions, order amounts
3:31 - Monthbymonth reporting with distinct counts
4:40 - Monthly reporting query pulling roles, transactions, order amount
5:00 - Date part function SQL for 2020 year summary
5:37 - Output Monthly name, customers, orders, order amount
5:57 - Perfect query improvement tips
8:18 - Query output for users orders
9:10 - Logic for capturing users orders
11:08 - Window functions offer more scalability, flexibility
12…