Have you ever wondered what kind of questions Amazon asks during their interviews? Here's a little sneak peak! They can def be tricky...
Link to the SQL File: https://drive.google.com/file/d/1h2EdAUhfeZhDjbbG7Y80lQ-akNqJh4Bu/view?usp=sharing
Follow me on the Socials!
Instagram: https://www.instagram.com/tim__joo/
Twitter: https://twitter.com/Tim__Joo
Tik Tok: https://www.tiktok.com/@tim__joo
if ur reading this, comment: self joins suck
current subscriber count: 1742
where i get my music 🎶: https://www.epidemicsound.com/referral/p2i1bj
MY GEAR:
Sony A7siii: https://amzn.to/3Qp1nX3
Fujifilm X100V: https://amzn.to/4dnf0SH
Sony A7C: https://amzn.to/3oEgY92
Sony 11mm f1.8: https://amzn.to/3xNtlHD
Tamron 17-28mm: https://amzn.to/3oA5gwb
Sony ECM-B1M Shotgun Mic : https://amzn.to/3AlSvLS
Rode Wireless GO 2: https://amzn.to/3vUFt9f
Sony Vlog Tripod: https://amzn.to/3y9bYP2
Sony 35mm f1.4 (Fave Lens) : https://amzn.to/3zEvGTC
Sigma 85mm f1.4: https://amzn.to/3bhOUoU
Sony 24-105mm: https://amzn.to/49JZ8X3
Peter Mckinion Polar Pro 67mm ND Filter: https://amzn.to/3UrbGOO
14inch MacBook Pro: https://amzn.to/3twLowp
** these are affiliate links so I do get some kickback when you do buy with my link :')
Timestamps:
0:00 intro
0:40 Q1 SQL joins output
3:17 Q2 list of customers who bought ALL products in Table Y
5:00 Q3 Cancelation Rate for trips
10:37 Q4 top 3 employees in each department
14:34 Q5 follower and followee
16:48 Q6 pivot and unpivot
19:07 final thoughts and thank you!
#lifestyle #interview #dataanalytics