Write SQL using HAVING and window functions
Company: PayPal
Role: Data Scientist
Category: Data Manipulation (SQL/Python)
Difficulty: easy
Interview Round: Technical Screen
Quick Answer: This question evaluates SQL data manipulation competency, focusing on aggregation filtering with HAVING and the use of window functions for running counts and ranking within a fraud analytics scenario; Category: Data Manipulation (SQL/Python).