Quick Overview

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).

Explain Joins and Write Coupon SQL

Company: eBay

Role: Data Analyst

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: HR Screen

Overview: 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).

Read the full eBay Data Analyst interview experience this question came from

Loading…