Explain Joins and Write Coupon SQL
Company: eBay
Role: Data Analyst
Category: Data Manipulation (SQL/Python)
Difficulty: medium
Interview Round: HR Screen
Quick Answer: This question evaluates proficiency in SQL fundamentals—logical execution order of query clauses, join semantics (INNER/LEFT/RIGHT), timezone-aware timestamp handling, aggregation, grouping and filtering—alongside practical competency in cohort and campaign analytics such as conversion rate, transaction counts, and gross merchandise bought (GMB).